PREVIEW / etf_1hour / 2010-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-26.parquet
  size:    157 KB
  rows:    4,816

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
2010-03-26 04:00:00	SPY	ETF	116.96	116.96	116.9	116.9	405.0
2010-03-26 06:00:00	SPY	ETF	117.02	117.05	117.01	117.03	9260.0
2010-03-26 07:00:00	SPY	ETF	116.97	117.13	116.95	117.06	433014.0
2010-03-26 08:00:00	SPY	ETF	117.06	117.28	116.8	117.03	4379828.0
2010-03-26 09:00:00	SPY	ETF	117.02	117.15	116.71	117.01	25172974.0
2010-03-26 10:00:00	SPY	ETF	117.01	117.42	117.0	117.16	31580298.0
2010-03-26 11:00:00	SPY	ETF	117.16	117.34	117.1	117.13	19019835.0
2010-03-26 12:00:00	SPY	ETF	117.13	117.22	116.4	116.52	30003080.0
2010-03-26 13:00:00	SPY	ETF	116.52	116.62	116.12	116.44	28854937.0
2010-03-26 14:00:00	SPY	ETF	116.44	116.83	116.25	116.57	22731552.0
2010-03-26 15:00:00	SPY	ETF	116.56	116.71	116.41	116.65	26379099.0
2010-03-26 16:00:00	SPY	ETF	116.66	117.2538	116.582	116.8	15629543.0
2010-03-26 17:00:00	SPY	ETF	116.8	116.81	116.77	116.8	93775.0
2010-03-26 18:00:00	SPY	ETF	116.78	116.81	116.77	116.8	27395.0
2010-03-26 19:00:00	SPY	ETF	116.81	117.31	116.81	117.3	155403.0
2010-03-26 05:00:00	QQQ	ETF	48.14	48.14	48.13	48.13	13500.0
2010-03-26 06:00:00	QQQ	ETF	48.08	48.11	48.08	48.11	8060.0
2010-03-26 07:00:00	QQQ	ETF	48.09	48.22	48.09	48.19	1150822.0
2010-03-26 08:00:00	QQQ	ETF	48.18	48.24	48.06	48.13	1531206.0
2010-03-26 09:00:00	QQQ	ETF	48.13	48.27	48.05	48.16	10084331.0
2010-03-26 10:00:00	QQQ	ETF	48.16	48.33	48.13	48.15	12416944.0
2010-03-26 11:00:00	QQQ	ETF	48.15	48.25	48.13	48.15	5300777.0
2010-03-26 12:00:00	QQQ	ETF	48.1501	48.2	47.84	47.86	11021590.0
2010-03-26 13:00:00	QQQ	ETF	47.8699	47.92	47.74	47.82	9872284.0
2010-03-26 14:00:00	QQQ	ETF	47.81	48.02	47.75	47.9275	9225391.0
2010-03-26 15:00:00	QQQ	ETF	47.93	48.03	47.874	48.01	8330896.0
2010-03-26 16:00:00	QQQ	ETF	48.01	48.17	47.8581	48.03	6314883.0
2010-03-26 17:00:00	QQQ	ETF	48.04	48.06	48.01	48.05	19676.0
2010-03-26 18:00:00	QQQ	ETF	48.03	48.04	48.03	48.04	3700.0
2010-03-26 19:00:00	QQQ	ETF	48.04	48.13	48.03	48.13	10544.0
2010-03-26 07:00:00	IWM	ETF	68.15	68.24	68.14	68.19	8050.0
2010-03-26 08:00:00	IWM	ETF	68.18	68.3	68.07	68.14	506157.0
2010-03-26 09:00:00	IWM	ETF	68.15	68.39	67.955	68.21	9612227.0
2010-03-26 10:00:00	IWM	ETF	68.22	68.57	68.16	68.3	8872943.0
2010-03-26 11:00:00	IWM	ETF	68.31	68.5274	68.29	68.32	3751177.0
2010-03-26 12:00:00	IWM	ETF	68.325	68.43	67.76	67.89	6106524.0
2010-03-26 13:00:00	IWM	ETF	67.89	67.99	67.56	67.81	6858584.0
2010-03-26 14:00:00	IWM	ETF	67.81	68.4	67.63	67.73	6003253.0
2010-03-26 15:00:00	IWM	ETF	67.73	67.88	67.57	67.8	8330675.0
2010-03-26 16:00:00	IWM	ETF	67.8	68.4871	67.7459	67.9	6081735.0
2010-03-26 17:00:00	IWM	ETF	67.92	67.94	67.91	67.91	516.0
2010-03-26 19:00:00	IWM	ETF	67.92	68.01	67.92	68.01	9700.0
2010-03-26 06:00:00	DIA	ETF	108.75	108.78	108.75	108.78	400.0
2010-03-26 07:00:00	DIA	ETF	108.73	108.75	108.73	108.75	700.0
2010-03-26 08:00:00	DIA	ETF	108.86	108.96	108.73	108.74	24450.0
2010-03-26 09:00:00	DIA	ETF	108.74	108.84	108.49	108.73	792840.0
2010-03-26 10:00:00	DIA	ETF	108.73	109.03	108.73	108.905	1159591.0
2010-03-26 11:00:00	DIA	ETF	108.91	109.07	108.83	108.86	514792.0
2010-03-26 12:00:00	DIA	ETF	108.86	108.94	108.34	108.47	1222381.0
2010-03-26 13:00:00	DIA	ETF	108.44	108.56	108.131	108.41	1378675.0

> showing 50 of 4,816 rows — these rows as CSV

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