PREVIEW / etf_1hour / 2011-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-07.parquet
  size:    181 KB
  rows:    5,551

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-06-07 04:00:00	SPY	ETF	129.41	129.88	129.41	129.79	8660.0
2011-06-07 05:00:00	SPY	ETF	129.78	129.8	129.5	129.72	2585.0
2011-06-07 06:00:00	SPY	ETF	129.73	129.9	129.65	129.7	119010.0
2011-06-07 07:00:00	SPY	ETF	129.72	129.74	129.54	129.58	582794.0
2011-06-07 08:00:00	SPY	ETF	129.57	129.78	129.45	129.77	2648134.0
2011-06-07 09:00:00	SPY	ETF	129.77	129.85	129.35	129.55	23363962.0
2011-06-07 10:00:00	SPY	ETF	129.55	129.99	129.53	129.91	24057104.0
2011-06-07 11:00:00	SPY	ETF	129.91	129.93	129.46	129.67	15451749.0
2011-06-07 12:00:00	SPY	ETF	129.68	129.8	129.52	129.77	10150508.0
2011-06-07 13:00:00	SPY	ETF	129.77	129.92	129.68	129.76	10690493.0
2011-06-07 14:00:00	SPY	ETF	129.76	130.07	129.69	129.8	15085755.0
2011-06-07 15:00:00	SPY	ETF	129.8	129.87	128.87	128.94	47977646.0
2011-06-07 16:00:00	SPY	ETF	128.93	129.65	128.79	129.11	10070992.0
2011-06-07 17:00:00	SPY	ETF	129.09	129.33	129.07	129.29	577239.0
2011-06-07 18:00:00	SPY	ETF	129.28	129.29	128.85	129.18	161039.0
2011-06-07 19:00:00	SPY	ETF	129.17	129.25	129.15	129.2	170186.0
2011-06-07 06:00:00	QQQ	ETF	56.15	56.17	56.14	56.17	5200.0
2011-06-07 07:00:00	QQQ	ETF	56.11	56.11	56.05	56.08	35136.0
2011-06-07 08:00:00	QQQ	ETF	56.09	56.14	56.02	56.14	305702.0
2011-06-07 09:00:00	QQQ	ETF	56.15	56.18	55.88	55.99	5362944.0
2011-06-07 10:00:00	QQQ	ETF	55.99	56.2	55.98	56.17	6651123.0
2011-06-07 11:00:00	QQQ	ETF	56.17	56.18	55.9	55.99	5330047.0
2011-06-07 12:00:00	QQQ	ETF	56.0	56.01	55.89	56.0	2288567.0
2011-06-07 13:00:00	QQQ	ETF	56.0	56.13	55.98	56.065	3949115.0
2011-06-07 14:00:00	QQQ	ETF	56.07	56.26	56.045	56.09	4124984.0
2011-06-07 15:00:00	QQQ	ETF	56.08	56.13	55.75	55.77	8564860.0
2011-06-07 16:00:00	QQQ	ETF	55.78	55.9792	55.76	55.93	3863337.0
2011-06-07 17:00:00	QQQ	ETF	55.93	55.98	55.93	55.95	63092.0
2011-06-07 18:00:00	QQQ	ETF	55.97	56.0	55.97	55.99	22336.0
2011-06-07 19:00:00	QQQ	ETF	55.96	55.99	55.95	55.98	19620.0
2011-06-07 06:00:00	IWM	ETF	80.04	80.12	80.04	80.12	3600.0
2011-06-07 07:00:00	IWM	ETF	79.97	80.0	79.91	79.94	76100.0
2011-06-07 08:00:00	IWM	ETF	79.98	80.07	79.84	80.07	330715.0
2011-06-07 09:00:00	IWM	ETF	80.08	80.2	79.7	79.9533	7616155.0
2011-06-07 10:00:00	IWM	ETF	79.95	80.41	79.93	80.33	12657892.0
2011-06-07 11:00:00	IWM	ETF	80.33	80.38	79.9199	80.12	4491162.0
2011-06-07 12:00:00	IWM	ETF	80.12	80.2401	80.03	80.21	3115280.0
2011-06-07 13:00:00	IWM	ETF	80.22	80.39	80.15	80.2701	3217464.0
2011-06-07 14:00:00	IWM	ETF	80.28	80.43	80.16	80.29	4839598.0
2011-06-07 15:00:00	IWM	ETF	80.29	80.36	79.71	79.74	10643029.0
2011-06-07 16:00:00	IWM	ETF	79.74	79.81	79.6	79.75	923252.0
2011-06-07 17:00:00	IWM	ETF	79.77	80.02	79.76	79.93	114100.0
2011-06-07 18:00:00	IWM	ETF	79.97	79.98	79.84	79.94	9200.0
2011-06-07 19:00:00	IWM	ETF	79.9	79.96	79.89	79.94	7236.0
2011-06-07 07:00:00	DIA	ETF	121.25	121.33	121.22	121.25	5190.0
2011-06-07 08:00:00	DIA	ETF	121.27	121.34	121.13	121.34	7776.0
2011-06-07 09:00:00	DIA	ETF	121.36	121.43	121.0	121.15	650503.0
2011-06-07 10:00:00	DIA	ETF	121.16	121.55	121.16	121.51	650297.0
2011-06-07 11:00:00	DIA	ETF	121.51	121.53	121.13	121.28	502216.0
2011-06-07 12:00:00	DIA	ETF	121.28	121.43	121.2	121.38	209083.0

> showing 50 of 5,551 rows — these rows as CSV

> unlock the full archive -- $79 one-time