PREVIEW / etf_1hour / 2009-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-22.parquet
  size:    141 KB
  rows:    4,355

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-06-22 04:00:00	SPY	ETF	91.65	91.65	91.24	91.27	6750.0
2009-06-22 05:00:00	SPY	ETF	91.2	91.3	91.2	91.29	18038.0
2009-06-22 06:00:00	SPY	ETF	91.42	91.44	91.19	91.29	46018.0
2009-06-22 07:00:00	SPY	ETF	91.28	91.39	91.13	91.23	649182.0
2009-06-22 08:00:00	SPY	ETF	91.23	91.32	90.96	91.06	2848656.0
2009-06-22 09:00:00	SPY	ETF	91.06	91.19	90.4	90.47	28088674.0
2009-06-22 10:00:00	SPY	ETF	90.47	90.62	90.065	90.16	41068260.0
2009-06-22 11:00:00	SPY	ETF	90.1525	90.28	89.68	89.73	29801595.0
2009-06-22 12:00:00	SPY	ETF	89.73	89.9	89.64	89.805	18478216.0
2009-06-22 13:00:00	SPY	ETF	89.81	89.82	89.35	89.74	21262362.0
2009-06-22 14:00:00	SPY	ETF	89.74	89.89	89.57	89.78	27495748.0
2009-06-22 15:00:00	SPY	ETF	89.79	89.96	89.26	89.26	52110325.0
2009-06-22 16:00:00	SPY	ETF	89.27	90.34	89.21	89.37	13618359.0
2009-06-22 17:00:00	SPY	ETF	89.37	89.38	89.29	89.35	186867.0
2009-06-22 18:00:00	SPY	ETF	89.34	89.37	89.27	89.37	4632539.0
2009-06-22 19:00:00	SPY	ETF	89.35	89.43	89.33	89.43	56480.0
2009-06-22 04:00:00	QQQ	ETF	35.88	35.88	35.77	35.77	1200.0
2009-06-22 05:00:00	QQQ	ETF	35.75	35.75	35.75	35.75	400.0
2009-06-22 06:00:00	QQQ	ETF	35.76	35.76	35.75	35.75	500.0
2009-06-22 07:00:00	QQQ	ETF	35.76	35.85	35.73	35.76	651144.0
2009-06-22 08:00:00	QQQ	ETF	35.78	35.81	35.7	35.74	1427860.0
2009-06-22 09:00:00	QQQ	ETF	35.73	35.89	35.45	35.5	21635413.0
2009-06-22 10:00:00	QQQ	ETF	35.5	35.51	35.23	35.29	24853669.0
2009-06-22 11:00:00	QQQ	ETF	35.28	35.39	35.14	35.16	15535795.0
2009-06-22 12:00:00	QQQ	ETF	35.165	35.22	35.09	35.15	10597956.0
2009-06-22 13:00:00	QQQ	ETF	35.15	35.17	35.02	35.16	11697483.0
2009-06-22 14:00:00	QQQ	ETF	35.17	35.27	35.12	35.215	14612300.0
2009-06-22 15:00:00	QQQ	ETF	35.2269	35.33	35.07	35.08	24627016.0
2009-06-22 16:00:00	QQQ	ETF	35.08	35.85	35.07	35.17	6232926.0
2009-06-22 17:00:00	QQQ	ETF	35.17	35.18	35.12	35.13	81168.0
2009-06-22 18:00:00	QQQ	ETF	35.09	35.17	35.09	35.16	270772.0
2009-06-22 19:00:00	QQQ	ETF	35.16	35.17	35.15	35.17	18630.0
2009-06-22 06:00:00	IWM	ETF	51.01	51.13	51.0	51.0	500.0
2009-06-22 07:00:00	IWM	ETF	50.96	51.01	50.92	50.92	77800.0
2009-06-22 08:00:00	IWM	ETF	50.96	51.0	50.8	50.95	84955.0
2009-06-22 09:00:00	IWM	ETF	50.95	51.12	50.07	50.12	6018911.0
2009-06-22 10:00:00	IWM	ETF	50.13	50.485	49.88	49.94	7445755.0
2009-06-22 11:00:00	IWM	ETF	49.94	50.08	49.74	49.8	3745603.0
2009-06-22 12:00:00	IWM	ETF	49.8	49.94	49.7562	49.9301	3593989.0
2009-06-22 13:00:00	IWM	ETF	49.93	49.935	49.65	49.87	3617614.0
2009-06-22 14:00:00	IWM	ETF	49.86	49.96	49.76	49.89	3383221.0
2009-06-22 15:00:00	IWM	ETF	49.89	49.98	49.45	49.47	11322737.0
2009-06-22 16:00:00	IWM	ETF	49.48	51.3938	49.4	49.68	10087783.0
2009-06-22 17:00:00	IWM	ETF	49.66	49.72	49.63	49.63	17225.0
2009-06-22 18:00:00	IWM	ETF	49.64	49.64	49.6	49.6	352.0
2009-06-22 19:00:00	IWM	ETF	49.55	49.62	49.49	49.6	1348.0
2009-06-22 05:00:00	DIA	ETF	84.89	84.89	84.89	84.89	100.0
2009-06-22 07:00:00	DIA	ETF	84.73	84.77	84.65	84.75	11975.0
2009-06-22 08:00:00	DIA	ETF	84.7	84.75	84.49	84.57	44700.0
2009-06-22 09:00:00	DIA	ETF	84.56	84.77	84.14	84.191	2359681.0

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

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