PREVIEW / etf_1hour / 2009-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-27.parquet
  size:    125 KB
  rows:    3,856

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-01-27 04:00:00	SPY	ETF	84.78	84.85	84.73	84.85	700.0
2009-01-27 05:00:00	SPY	ETF	84.33	84.33	84.21	84.23	2388.0
2009-01-27 06:00:00	SPY	ETF	84.14	84.14	83.8	83.91	24700.0
2009-01-27 07:00:00	SPY	ETF	84.0	84.18	83.67	84.09	759254.0
2009-01-27 08:00:00	SPY	ETF	84.1	84.58	84.06	84.46	2084375.0
2009-01-27 09:00:00	SPY	ETF	84.49	84.85	83.99	84.42	29904331.0
2009-01-27 10:00:00	SPY	ETF	84.44	84.58	83.56	84.11	50778258.0
2009-01-27 11:00:00	SPY	ETF	84.11	84.7	84.01	84.38	31714588.0
2009-01-27 12:00:00	SPY	ETF	84.38	85.15	84.23	84.86	29332958.0
2009-01-27 13:00:00	SPY	ETF	84.8609	85.07	84.42	84.44	31297936.0
2009-01-27 14:00:00	SPY	ETF	84.43	84.77	84.02	84.7	39489309.0
2009-01-27 15:00:00	SPY	ETF	84.7	85.09	83.3	84.58	47658569.0
2009-01-27 16:00:00	SPY	ETF	84.65	85.0	84.2	84.57	8004282.0
2009-01-27 17:00:00	SPY	ETF	84.57	85.49	84.57	85.44	1460798.0
2009-01-27 18:00:00	SPY	ETF	85.35	85.52	85.25	85.39	246418.0
2009-01-27 19:00:00	SPY	ETF	85.39	85.56	85.3	85.35	155813.0
2009-01-27 04:00:00	QQQ	ETF	29.32	29.34	29.22	29.22	1900.0
2009-01-27 05:00:00	QQQ	ETF	29.19	29.19	29.19	29.19	300.0
2009-01-27 06:00:00	QQQ	ETF	29.22	29.23	29.05	29.08	2050.0
2009-01-27 07:00:00	QQQ	ETF	29.06	29.21	28.99	29.17	113507.0
2009-01-27 08:00:00	QQQ	ETF	29.15	29.28	29.01	29.27	533356.0
2009-01-27 09:00:00	QQQ	ETF	29.28	29.49	29.11	29.37	15026265.0
2009-01-27 10:00:00	QQQ	ETF	29.37	29.4	29.12	29.28	19333945.0
2009-01-27 11:00:00	QQQ	ETF	29.28	29.46	29.24	29.32	10009530.0
2009-01-27 12:00:00	QQQ	ETF	29.32	29.57	29.26	29.48	11607603.0
2009-01-27 13:00:00	QQQ	ETF	29.49	29.53	29.36	29.36	11139883.0
2009-01-27 14:00:00	QQQ	ETF	29.36	29.46	29.2	29.44	17062250.0
2009-01-27 15:00:00	QQQ	ETF	29.45	29.57	29.321	29.36	16983699.0
2009-01-27 16:00:00	QQQ	ETF	29.35	29.45	29.17	29.38	7537660.0
2009-01-27 17:00:00	QQQ	ETF	29.4	29.63	29.37	29.59	608063.0
2009-01-27 18:00:00	QQQ	ETF	29.56	29.65	29.55	29.62	311491.0
2009-01-27 19:00:00	QQQ	ETF	29.59	29.67	29.59	29.67	49786.0
2009-01-27 07:00:00	IWM	ETF	44.84	44.94	44.84	44.94	7350.0
2009-01-27 08:00:00	IWM	ETF	44.97	45.25	44.94	45.25	272733.0
2009-01-27 09:00:00	IWM	ETF	45.24	45.75	45.0	45.35	5420085.0
2009-01-27 10:00:00	IWM	ETF	45.37	45.42	44.72	45.26	8448114.0
2009-01-27 11:00:00	IWM	ETF	45.26	45.56	45.15	45.3	4600338.0
2009-01-27 12:00:00	IWM	ETF	45.3	45.81	45.2	45.65	7103419.0
2009-01-27 13:00:00	IWM	ETF	45.65	45.82	45.4305	45.47	6054980.0
2009-01-27 14:00:00	IWM	ETF	45.46	45.6	45.15	45.56	5480926.0
2009-01-27 15:00:00	IWM	ETF	45.55	45.68	45.29	45.42	8672953.0
2009-01-27 16:00:00	IWM	ETF	45.42	45.64	45.12	45.28	1741700.0
2009-01-27 17:00:00	IWM	ETF	45.38	45.93	45.38	45.77	109492.0
2009-01-27 18:00:00	IWM	ETF	45.78	45.9	45.78	45.9	4100.0
2009-01-27 19:00:00	IWM	ETF	45.9	45.96	45.76	45.96	4318.0
2009-01-27 06:00:00	DIA	ETF	81.48	81.48	81.25	81.29	712.0
2009-01-27 07:00:00	DIA	ETF	81.28	81.46	81.11	81.42	7885.0
2009-01-27 08:00:00	DIA	ETF	81.4	81.81	81.38	81.73	37013.0
2009-01-27 09:00:00	DIA	ETF	81.65	82.0	81.32	81.64	3021602.0
2009-01-27 10:00:00	DIA	ETF	81.64	81.75	80.8	81.28	4699743.0

> showing 50 of 3,856 rows — these rows as CSV

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