PREVIEW / etf_1hour / 2009-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-21.parquet
  size:    142 KB
  rows:    4,408

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-08-21 04:00:00	SPY	ETF	100.79	101.0	100.79	101.0	1500.0
2009-08-21 05:00:00	SPY	ETF	101.02	101.25	101.02	101.25	5900.0
2009-08-21 06:00:00	SPY	ETF	101.29	101.55	101.29	101.46	20756.0
2009-08-21 07:00:00	SPY	ETF	101.46	101.6	101.39	101.45	566649.0
2009-08-21 08:00:00	SPY	ETF	101.46	101.63	100.19	101.63	1880416.0
2009-08-21 09:00:00	SPY	ETF	101.63	102.4273	101.61	101.99	30712519.0
2009-08-21 10:00:00	SPY	ETF	101.99	102.95	101.99	102.62	56537311.0
2009-08-21 11:00:00	SPY	ETF	102.62	102.87	102.61	102.78	17373408.0
2009-08-21 12:00:00	SPY	ETF	102.78	102.79	102.65	102.7	11017561.0
2009-08-21 13:00:00	SPY	ETF	102.7	102.8	102.54	102.57	15557048.0
2009-08-21 14:00:00	SPY	ETF	102.56	102.735	102.5	102.73	12304282.0
2009-08-21 15:00:00	SPY	ETF	102.73	103.13	102.65	102.92	48399548.0
2009-08-21 16:00:00	SPY	ETF	102.91	103.04	101.074	102.96	23589653.0
2009-08-21 17:00:00	SPY	ETF	102.97	103.02	101.074	103.02	1164394.0
2009-08-21 18:00:00	SPY	ETF	103.02	103.02	102.9	102.92	82962.0
2009-08-21 19:00:00	SPY	ETF	102.92	102.95	102.9	102.91	40262.0
2009-08-21 06:00:00	QQQ	ETF	39.92	39.92	39.85	39.87	4856.0
2009-08-21 07:00:00	QQQ	ETF	39.87	39.93	39.85	39.87	258587.0
2009-08-21 08:00:00	QQQ	ETF	39.87	39.93	39.38	39.92	567461.0
2009-08-21 09:00:00	QQQ	ETF	39.94	40.05	39.74	39.8905	18363556.0
2009-08-21 10:00:00	QQQ	ETF	39.9	40.36	39.8	40.24	26581100.0
2009-08-21 11:00:00	QQQ	ETF	40.24	40.2701	39.8	40.22	7396086.0
2009-08-21 12:00:00	QQQ	ETF	40.22	40.24	40.17	40.19	4883246.0
2009-08-21 13:00:00	QQQ	ETF	40.18	40.23	40.06	40.09	8151662.0
2009-08-21 14:00:00	QQQ	ETF	40.09	40.22	40.08	40.22	11096572.0
2009-08-21 15:00:00	QQQ	ETF	40.22	40.36	40.2	40.28	20388339.0
2009-08-21 16:00:00	QQQ	ETF	40.28	40.3484	39.7337	40.23	10682264.0
2009-08-21 17:00:00	QQQ	ETF	40.23	40.25	40.22	40.25	42300.0
2009-08-21 18:00:00	QQQ	ETF	40.24	40.29	40.21	40.22	23695.0
2009-08-21 19:00:00	QQQ	ETF	40.21	40.25	40.15	40.19	42837.0
2009-08-21 06:00:00	IWM	ETF	57.19	57.22	57.19	57.2	875.0
2009-08-21 07:00:00	IWM	ETF	57.22	57.29	57.19	57.2	42328.0
2009-08-21 08:00:00	IWM	ETF	57.21	57.3	57.02	57.3	251534.0
2009-08-21 09:00:00	IWM	ETF	57.3	57.66	57.3	57.63	5764408.0
2009-08-21 10:00:00	IWM	ETF	57.65	58.39	57.63	58.14	11637739.0
2009-08-21 11:00:00	IWM	ETF	58.13	58.2317	58.09	58.17	2591813.0
2009-08-21 12:00:00	IWM	ETF	58.1693	58.18	58.055	58.12	1785489.0
2009-08-21 13:00:00	IWM	ETF	58.11	58.19	57.95	57.98	2586355.0
2009-08-21 14:00:00	IWM	ETF	57.98	58.09	57.95	58.04	2101040.0
2009-08-21 15:00:00	IWM	ETF	58.05	58.3	58.02	58.16	9029088.0
2009-08-21 16:00:00	IWM	ETF	58.15	58.27	56.9184	58.2	2018499.0
2009-08-21 17:00:00	IWM	ETF	58.19	58.24	58.17	58.18	16502.0
2009-08-21 18:00:00	IWM	ETF	58.17	58.2	58.1	58.12	5078.0
2009-08-21 19:00:00	IWM	ETF	58.14	58.2	58.12	58.12	6816.0
2009-08-21 04:00:00	DIA	ETF	93.49	93.49	93.38	93.38	400.0
2009-08-21 06:00:00	DIA	ETF	93.73	93.73	93.73	93.73	2000.0
2009-08-21 07:00:00	DIA	ETF	93.84	93.89	93.73	93.74	20894.0
2009-08-21 08:00:00	DIA	ETF	93.74	93.85	93.66	93.85	56994.0
2009-08-21 09:00:00	DIA	ETF	93.84	94.24	93.84	94.22	1888694.0
2009-08-21 10:00:00	DIA	ETF	94.23	95.09	94.23	94.85	3379290.0

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

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