PREVIEW / etf_1hour / 2009-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-19.parquet
  size:    137 KB
  rows:    4,203

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
2009-05-19 04:00:00	SPY	ETF	91.57	91.73	91.57	91.71	6200.0
2009-05-19 05:00:00	SPY	ETF	91.71	91.88	91.45	91.73	9200.0
2009-05-19 06:00:00	SPY	ETF	91.71	92.0	91.67	91.89	90910.0
2009-05-19 07:00:00	SPY	ETF	91.85	91.88	91.57	91.61	879180.0
2009-05-19 08:00:00	SPY	ETF	91.62	92.05	91.08	91.16	7060428.0
2009-05-19 09:00:00	SPY	ETF	91.16	91.46	90.87	90.89	26721295.0
2009-05-19 10:00:00	SPY	ETF	90.89	91.89	90.81	91.58	40268948.0
2009-05-19 11:00:00	SPY	ETF	91.57	91.74	91.26	91.59	20222163.0
2009-05-19 12:00:00	SPY	ETF	91.59	91.78	91.33	91.34	15772806.0
2009-05-19 13:00:00	SPY	ETF	91.33	91.86	91.32	91.58	20510216.0
2009-05-19 14:00:00	SPY	ETF	91.58	91.97	91.35	91.78	23118319.0
2009-05-19 15:00:00	SPY	ETF	91.78	91.97	91.03	91.11	40909877.0
2009-05-19 16:00:00	SPY	ETF	91.08	91.4786	90.88	90.88	9187904.0
2009-05-19 17:00:00	SPY	ETF	90.86	90.94	90.73	90.86	372573.0
2009-05-19 18:00:00	SPY	ETF	90.85	91.04	90.83	90.95	234471.0
2009-05-19 19:00:00	SPY	ETF	90.93	91.1	90.93	91.08	87009.0
2009-05-19 06:00:00	QQQ	ETF	34.36	34.43	34.32	34.38	81375.0
2009-05-19 07:00:00	QQQ	ETF	34.38	34.38	34.22	34.24	1030811.0
2009-05-19 08:00:00	QQQ	ETF	34.24	34.36	34.06	34.09	4736123.0
2009-05-19 09:00:00	QQQ	ETF	34.09	34.28	33.95	34.08	21352237.0
2009-05-19 10:00:00	QQQ	ETF	34.07	34.47	34.03	34.34	20076188.0
2009-05-19 11:00:00	QQQ	ETF	34.34	34.39	34.21	34.34	11380098.0
2009-05-19 12:00:00	QQQ	ETF	34.35	34.47	34.31	34.36	6447546.0
2009-05-19 13:00:00	QQQ	ETF	34.36	34.66	34.35	34.57	14749756.0
2009-05-19 14:00:00	QQQ	ETF	34.5699	34.74	34.49	34.6412	12517491.0
2009-05-19 15:00:00	QQQ	ETF	34.65	34.69	34.37	34.38	20029228.0
2009-05-19 16:00:00	QQQ	ETF	34.38	34.4955	34.04	34.23	7679480.0
2009-05-19 17:00:00	QQQ	ETF	34.24	34.24	34.19	34.24	183616.0
2009-05-19 18:00:00	QQQ	ETF	34.22	34.29	34.21	34.23	59835.0
2009-05-19 19:00:00	QQQ	ETF	34.21	34.28	34.21	34.27	29700.0
2009-05-19 04:00:00	IWM	ETF	49.71	49.71	49.71	49.71	200.0
2009-05-19 05:00:00	IWM	ETF	49.7	49.88	49.7	49.88	2000.0
2009-05-19 06:00:00	IWM	ETF	49.88	49.92	49.88	49.92	2200.0
2009-05-19 07:00:00	IWM	ETF	49.87	49.87	49.67	49.69	153603.0
2009-05-19 08:00:00	IWM	ETF	49.69	50.03	49.32	49.36	1779892.0
2009-05-19 09:00:00	IWM	ETF	49.35	49.49	48.86	48.9101	7954210.0
2009-05-19 10:00:00	IWM	ETF	48.9	49.63	48.8	49.32	8313671.0
2009-05-19 11:00:00	IWM	ETF	49.32	49.43	49.08	49.36	5087047.0
2009-05-19 12:00:00	IWM	ETF	49.36	49.5001	49.2	49.26	2332743.0
2009-05-19 13:00:00	IWM	ETF	49.25	49.77	49.2	49.61	6530261.0
2009-05-19 14:00:00	IWM	ETF	49.61	49.9501	49.48	49.8	6465321.0
2009-05-19 15:00:00	IWM	ETF	49.8	49.96	49.26	49.35	11732137.0
2009-05-19 16:00:00	IWM	ETF	49.36	49.55	48.85	49.14	1684893.0
2009-05-19 17:00:00	IWM	ETF	49.2	49.21	49.09	49.21	20824.0
2009-05-19 18:00:00	IWM	ETF	49.21	49.24	49.21	49.24	700.0
2009-05-19 19:00:00	IWM	ETF	49.29	49.29	49.23	49.23	1500.0
2009-05-19 06:00:00	DIA	ETF	85.4	85.7	85.4	85.68	8128.0
2009-05-19 07:00:00	DIA	ETF	85.57	85.59	85.36	85.36	3680.0
2009-05-19 08:00:00	DIA	ETF	85.35	85.45	84.87	84.89	102539.0
2009-05-19 09:00:00	DIA	ETF	84.89	85.13	84.66	84.68	1399410.0

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

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