PREVIEW / etf_1hour / 2010-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-11.parquet
  size:    153 KB
  rows:    4,756

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-11 04:00:00	SPY	ETF	114.7	114.78	114.7	114.78	1750.0
2010-03-11 05:00:00	SPY	ETF	114.86	114.86	114.72	114.72	3200.0
2010-03-11 06:00:00	SPY	ETF	114.72	114.92	114.69	114.74	10200.0
2010-03-11 07:00:00	SPY	ETF	114.73	114.86	114.69	114.82	233999.0
2010-03-11 08:00:00	SPY	ETF	114.82	115.0	114.45	114.65	2340845.0
2010-03-11 09:00:00	SPY	ETF	114.66	114.83	114.35	114.51	18587783.0
2010-03-11 10:00:00	SPY	ETF	114.515	115.09	114.5	114.9884	22512418.0
2010-03-11 11:00:00	SPY	ETF	114.99	115.02	114.76	114.92	14027027.0
2010-03-11 12:00:00	SPY	ETF	114.92	114.93	114.62	114.87	25638634.0
2010-03-11 13:00:00	SPY	ETF	114.86	115.05	114.8	114.86	9541828.0
2010-03-11 14:00:00	SPY	ETF	114.87	114.98	114.75	114.9	14809700.0
2010-03-11 15:00:00	SPY	ETF	114.91	115.48	114.9	115.46	32633950.0
2010-03-11 16:00:00	SPY	ETF	115.45	115.58	114.52	115.52	12695842.0
2010-03-11 17:00:00	SPY	ETF	115.52	115.56	115.029	115.53	2157382.0
2010-03-11 18:00:00	SPY	ETF	115.51	115.53	115.45	115.52	299652.0
2010-03-11 19:00:00	SPY	ETF	115.5	115.57	115.45	115.57	194743.0
2010-03-11 04:00:00	QQQ	ETF	47.18	47.18	47.18	47.18	100.0
2010-03-11 06:00:00	QQQ	ETF	47.2	47.2	47.14	47.14	3487.0
2010-03-11 07:00:00	QQQ	ETF	47.14	47.17	47.12	47.13	403382.0
2010-03-11 08:00:00	QQQ	ETF	47.16	47.18	47.02	47.05	1279227.0
2010-03-11 09:00:00	QQQ	ETF	47.05	47.11	46.98	47.0507	10642397.0
2010-03-11 10:00:00	QQQ	ETF	47.06	47.26	47.05	47.215	12008010.0
2010-03-11 11:00:00	QQQ	ETF	47.22	47.24	47.11	47.18	4605702.0
2010-03-11 12:00:00	QQQ	ETF	47.18	47.18	47.03	47.15	7437385.0
2010-03-11 13:00:00	QQQ	ETF	47.16	47.19	47.1	47.11	3231131.0
2010-03-11 14:00:00	QQQ	ETF	47.12	47.17	47.06	47.1501	6991048.0
2010-03-11 15:00:00	QQQ	ETF	47.15	47.35	47.15	47.339	10864527.0
2010-03-11 16:00:00	QQQ	ETF	47.34	47.41	46.9742	47.4	3686068.0
2010-03-11 17:00:00	QQQ	ETF	47.4	47.41	47.38	47.4	13195.0
2010-03-11 18:00:00	QQQ	ETF	47.39	47.4	47.36	47.37	29632.0
2010-03-11 19:00:00	QQQ	ETF	47.37	47.37	47.35	47.35	43732.0
2010-03-11 06:00:00	IWM	ETF	67.31	67.31	67.31	67.31	1000.0
2010-03-11 07:00:00	IWM	ETF	67.28	67.35	67.25	67.34	21570.0
2010-03-11 08:00:00	IWM	ETF	67.3	67.52	67.0	67.21	679659.0
2010-03-11 09:00:00	IWM	ETF	67.21	67.28	66.9	67.06	9154820.0
2010-03-11 10:00:00	IWM	ETF	67.05	67.53	67.02	67.47	9253994.0
2010-03-11 11:00:00	IWM	ETF	67.4783	67.51	67.23	67.368	4801053.0
2010-03-11 12:00:00	IWM	ETF	67.36	67.38	67.16	67.37	4453271.0
2010-03-11 13:00:00	IWM	ETF	67.371	67.5	67.35	67.36	2557341.0
2010-03-11 14:00:00	IWM	ETF	67.366	67.48	67.3	67.435	7479102.0
2010-03-11 15:00:00	IWM	ETF	67.43	67.86	67.43	67.75	13350300.0
2010-03-11 16:00:00	IWM	ETF	67.76	67.83	67.2702	67.79	5950455.0
2010-03-11 17:00:00	IWM	ETF	67.79	67.85	67.5875	67.75	2049756.0
2010-03-11 18:00:00	IWM	ETF	67.8	67.84	67.79	67.81	2446.0
2010-03-11 19:00:00	IWM	ETF	67.81	67.85	67.81	67.85	1800.0
2010-03-11 07:00:00	DIA	ETF	105.7	105.7	105.7	105.7	100.0
2010-03-11 08:00:00	DIA	ETF	105.75	105.8	105.48	105.52	8574.0
2010-03-11 09:00:00	DIA	ETF	105.55	105.72	105.24	105.31	944192.0
2010-03-11 10:00:00	DIA	ETF	105.31	105.95	105.3	105.85	1110404.0
2010-03-11 11:00:00	DIA	ETF	105.85	105.88	105.709	105.85	741776.0

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

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