PREVIEW / etf_1hour / 2013-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-13.parquet
  size:    195 KB
  rows:    6,056

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
2013-03-13 04:00:00	SPY	ETF	155.57	155.61	155.56	155.56	5000.0
2013-03-13 05:00:00	SPY	ETF	155.51	155.6	155.47	155.48	36400.0
2013-03-13 06:00:00	SPY	ETF	155.55	155.55	155.38	155.4	29318.0
2013-03-13 07:00:00	SPY	ETF	155.4	155.41	155.28	155.33	276753.0
2013-03-13 08:00:00	SPY	ETF	155.31	155.87	155.27	155.82	1704205.0
2013-03-13 09:00:00	SPY	ETF	155.82	155.82	155.23	155.55	14655191.0
2013-03-13 10:00:00	SPY	ETF	155.55	155.75	155.3	155.7099	11311721.0
2013-03-13 11:00:00	SPY	ETF	155.71	155.81	155.55	155.59	10492270.0
2013-03-13 12:00:00	SPY	ETF	155.59	156.04	155.57	155.94	9569887.0
2013-03-13 13:00:00	SPY	ETF	155.94	156.12	155.83	156.045	6184778.0
2013-03-13 14:00:00	SPY	ETF	156.04	156.08	155.85	155.89	8132808.0
2013-03-13 15:00:00	SPY	ETF	155.895	156.01	155.7025	155.88	14707036.0
2013-03-13 16:00:00	SPY	ETF	155.86	156.14	155.7025	156.1	12397369.0
2013-03-13 17:00:00	SPY	ETF	156.11	156.13	155.97	156.04	1282688.0
2013-03-13 18:00:00	SPY	ETF	156.05	156.09	155.96	156.05	160268.0
2013-03-13 19:00:00	SPY	ETF	156.01	156.07	155.99	156.01	38614.0
2013-03-13 05:00:00	QQQ	ETF	68.68	68.7	68.65	68.65	12000.0
2013-03-13 06:00:00	QQQ	ETF	68.65	68.65	68.63	68.65	25800.0
2013-03-13 07:00:00	QQQ	ETF	68.63	68.64	68.58	68.6	41710.0
2013-03-13 08:00:00	QQQ	ETF	68.6	68.81	68.6	68.8	151103.0
2013-03-13 09:00:00	QQQ	ETF	68.78	68.81	68.44	68.54	2891932.0
2013-03-13 10:00:00	QQQ	ETF	68.54	68.7201	68.39	68.69	3828252.0
2013-03-13 11:00:00	QQQ	ETF	68.68	68.73	68.535	68.54	2544042.0
2013-03-13 12:00:00	QQQ	ETF	68.55	68.79	68.53	68.76	2638619.0
2013-03-13 13:00:00	QQQ	ETF	68.7501	68.89	68.7099	68.86	1960788.0
2013-03-13 14:00:00	QQQ	ETF	68.85	68.87	68.681	68.72	1641314.0
2013-03-13 15:00:00	QQQ	ETF	68.72	68.75	68.61	68.63	4206932.0
2013-03-13 16:00:00	QQQ	ETF	68.63	68.72	68.62	68.7	3270130.0
2013-03-13 17:00:00	QQQ	ETF	68.69	68.7	68.69	68.7	21250.0
2013-03-13 18:00:00	QQQ	ETF	68.69	68.7	68.68	68.68	57035.0
2013-03-13 19:00:00	QQQ	ETF	68.68	68.69	68.68	68.68	21244.0
2013-03-13 07:00:00	IWM	ETF	93.33	93.34	93.3	93.3	16925.0
2013-03-13 08:00:00	IWM	ETF	93.32	93.62	93.31	93.6	329288.0
2013-03-13 09:00:00	IWM	ETF	93.58	93.7	93.25	93.5	3852968.0
2013-03-13 10:00:00	IWM	ETF	93.51	93.6625	93.29	93.65	3293137.0
2013-03-13 11:00:00	IWM	ETF	93.66	93.74	93.54	93.55	2484661.0
2013-03-13 12:00:00	IWM	ETF	93.56	93.95	93.55	93.89	3068376.0
2013-03-13 13:00:00	IWM	ETF	93.89	94.02	93.81	93.95	2279832.0
2013-03-13 14:00:00	IWM	ETF	93.96	94.0	93.85	93.87	2476952.0
2013-03-13 15:00:00	IWM	ETF	93.88	93.94	93.74	93.87	4256160.0
2013-03-13 16:00:00	IWM	ETF	93.86	93.97	93.84	93.93	2120478.0
2013-03-13 17:00:00	IWM	ETF	93.97	93.98	93.91	93.91	13350.0
2013-03-13 19:00:00	IWM	ETF	93.93	93.93	93.92	93.92	700.0
2013-03-13 04:00:00	DIA	ETF	144.44	144.44	144.34	144.34	5490.0
2013-03-13 06:00:00	DIA	ETF	144.25	144.25	144.25	144.25	300.0
2013-03-13 07:00:00	DIA	ETF	144.21	144.21	144.17	144.21	9300.0
2013-03-13 08:00:00	DIA	ETF	144.2	144.56	144.19	144.53	33990.0
2013-03-13 09:00:00	DIA	ETF	144.51	144.54	144.12	144.29	722534.0
2013-03-13 10:00:00	DIA	ETF	144.3	144.4	144.09	144.35	927697.0
2013-03-13 11:00:00	DIA	ETF	144.36	144.46	144.31	144.34	235808.0

> showing 50 of 6,056 rows — these rows as CSV

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