PREVIEW / etf_1hour / 2010-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-19.parquet
  size:    155 KB
  rows:    4,782

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-19 04:00:00	SPY	ETF	117.09	117.09	116.24	116.53	25482.0
2010-03-19 05:00:00	SPY	ETF	116.63	116.63	116.58	116.6	2075.0
2010-03-19 06:00:00	SPY	ETF	116.57	116.72	116.57	116.65	1450.0
2010-03-19 07:00:00	SPY	ETF	116.69	116.69	116.5	116.63	232400.0
2010-03-19 08:00:00	SPY	ETF	116.65	116.8	116.6	116.8	2138088.0
2010-03-19 09:00:00	SPY	ETF	116.8	116.97	116.52	116.62	28925129.0
2010-03-19 10:00:00	SPY	ETF	116.63	117.293	115.94	116.06	37860264.0
2010-03-19 11:00:00	SPY	ETF	116.06	116.6	115.66	115.9	31263997.0
2010-03-19 12:00:00	SPY	ETF	115.9079	116.0	115.74	115.84	19307864.0
2010-03-19 13:00:00	SPY	ETF	115.84	115.97	115.72	115.92	12444264.0
2010-03-19 14:00:00	SPY	ETF	115.93	116.09	115.83	115.84	18672541.0
2010-03-19 15:00:00	SPY	ETF	115.84	116.5762	115.52	115.96	51333936.0
2010-03-19 16:00:00	SPY	ETF	115.97	116.95	115.75	115.99	20970217.0
2010-03-19 17:00:00	SPY	ETF	115.98	116.5762	115.91	115.98	2520216.0
2010-03-19 18:00:00	SPY	ETF	115.98	115.98	115.9	115.91	85375.0
2010-03-19 19:00:00	SPY	ETF	115.91	115.94	115.88	115.93	36533.0
2010-03-19 05:00:00	QQQ	ETF	47.75	47.75	47.75	47.75	600.0
2010-03-19 07:00:00	QQQ	ETF	47.81	47.83	47.76	47.82	134050.0
2010-03-19 08:00:00	QQQ	ETF	47.81	47.93	47.72	47.92	2497580.0
2010-03-19 09:00:00	QQQ	ETF	47.92	47.96	47.72	47.77	19894499.0
2010-03-19 10:00:00	QQQ	ETF	47.76	47.77	47.45	47.51	16432762.0
2010-03-19 11:00:00	QQQ	ETF	47.5162	47.53	47.38	47.5	11358172.0
2010-03-19 12:00:00	QQQ	ETF	47.5	47.55	47.39	47.43	5589374.0
2010-03-19 13:00:00	QQQ	ETF	47.43	47.48	47.4	47.47	4183711.0
2010-03-19 14:00:00	QQQ	ETF	47.4699	47.53	47.44	47.45	5283845.0
2010-03-19 15:00:00	QQQ	ETF	47.4501	47.51	47.32	47.49	12091855.0
2010-03-19 16:00:00	QQQ	ETF	47.49	47.7941	47.3588	47.47	5101965.0
2010-03-19 17:00:00	QQQ	ETF	47.47	47.53	47.47	47.48	40797.0
2010-03-19 18:00:00	QQQ	ETF	47.46	47.48	47.46	47.46	7156.0
2010-03-19 19:00:00	QQQ	ETF	47.46	47.47	47.46	47.46	32815.0
2010-03-19 07:00:00	IWM	ETF	68.23	68.23	68.12	68.14	85879.0
2010-03-19 08:00:00	IWM	ETF	68.16	68.37	68.16	68.37	247205.0
2010-03-19 09:00:00	IWM	ETF	68.37	68.51	67.81	68.13	8699316.0
2010-03-19 10:00:00	IWM	ETF	68.13	68.16	67.48	67.56	15155524.0
2010-03-19 11:00:00	IWM	ETF	67.56	67.6	67.2	67.41	12585255.0
2010-03-19 12:00:00	IWM	ETF	67.41	67.51	67.2	67.25	4325231.0
2010-03-19 13:00:00	IWM	ETF	67.24	67.39	67.24	67.36	3678244.0
2010-03-19 14:00:00	IWM	ETF	67.35	67.52	67.3	67.36	6546446.0
2010-03-19 15:00:00	IWM	ETF	67.36	67.51	67.16	67.39	17449487.0
2010-03-19 16:00:00	IWM	ETF	67.37	67.5998	67.25	67.4	8845389.0
2010-03-19 17:00:00	IWM	ETF	67.37	68.2692	67.35	67.35	508496.0
2010-03-19 18:00:00	IWM	ETF	67.33	67.35	67.3	67.3	2850.0
2010-03-19 19:00:00	IWM	ETF	67.31	67.31	67.28	67.28	500.0
2010-03-19 07:00:00	DIA	ETF	107.76	107.76	107.69	107.74	1200.0
2010-03-19 08:00:00	DIA	ETF	107.8	107.93	107.72	107.93	20016.0
2010-03-19 09:00:00	DIA	ETF	107.92	108.17	107.73	107.85	1964441.0
2010-03-19 10:00:00	DIA	ETF	107.85	107.89	107.37	107.44	2295814.0
2010-03-19 11:00:00	DIA	ETF	107.4395	107.47	107.08	107.28	1539379.0
2010-03-19 12:00:00	DIA	ETF	107.28	107.34	107.13	107.14	701688.0
2010-03-19 13:00:00	DIA	ETF	107.17	107.26	106.99	107.21	896369.0

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

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