PREVIEW / etf_1hour / 2008-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-20.parquet
  size:    110 KB
  rows:    3,566

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
2008-08-20 04:00:00	SPY	ETF	127.53	127.55	127.53	127.55	400.0
2008-08-20 05:00:00	SPY	ETF	127.63	127.67	127.63	127.66	7100.0
2008-08-20 06:00:00	SPY	ETF	127.63	127.63	127.32	127.55	160570.0
2008-08-20 07:00:00	SPY	ETF	127.53	127.6	127.4	127.47	766816.0
2008-08-20 08:00:00	SPY	ETF	127.49	127.63	127.08	127.08	3360074.0
2008-08-20 09:00:00	SPY	ETF	127.12	127.44	126.38	126.65	31693204.0
2008-08-20 10:00:00	SPY	ETF	126.64	127.86	126.34	127.83	54287173.0
2008-08-20 11:00:00	SPY	ETF	127.83	127.95	127.15	127.36	28734550.0
2008-08-20 12:00:00	SPY	ETF	127.37	127.48	126.72	126.95	23635555.0
2008-08-20 13:00:00	SPY	ETF	126.95	127.29	126.9	127.17	14787002.0
2008-08-20 14:00:00	SPY	ETF	127.17	127.23	126.59	127.2	22739045.0
2008-08-20 15:00:00	SPY	ETF	127.21	127.78	126.85	127.71	36919864.0
2008-08-20 16:00:00	SPY	ETF	127.7024	127.75	127.58	127.68	6227699.0
2008-08-20 17:00:00	SPY	ETF	127.65	127.79	126.99	127.76	56389.0
2008-08-20 18:00:00	SPY	ETF	127.72	127.72	127.6	127.65	17270.0
2008-08-20 19:00:00	SPY	ETF	127.62	127.65	127.62	127.62	6315.0
2008-08-20 04:00:00	QQQ	ETF	47.37	47.39	47.35	47.39	4100.0
2008-08-20 05:00:00	QQQ	ETF	47.4	47.43	47.4	47.42	500.0
2008-08-20 06:00:00	QQQ	ETF	47.31	47.32	47.29	47.32	77000.0
2008-08-20 07:00:00	QQQ	ETF	47.33	47.39	47.3	47.36	375446.0
2008-08-20 08:00:00	QQQ	ETF	47.36	47.37	47.18	47.19	4053746.0
2008-08-20 09:00:00	QQQ	ETF	47.2	47.36	46.92	47.0799	19492588.0
2008-08-20 10:00:00	QQQ	ETF	47.07	47.55	46.93	47.5	40178335.0
2008-08-20 11:00:00	QQQ	ETF	47.5	47.56	47.12	47.24	15812587.0
2008-08-20 12:00:00	QQQ	ETF	47.24	47.3	46.88	46.98	14023619.0
2008-08-20 13:00:00	QQQ	ETF	46.98	47.15	46.94	47.0722	7933817.0
2008-08-20 14:00:00	QQQ	ETF	47.08	47.08	46.74	47.02	19219972.0
2008-08-20 15:00:00	QQQ	ETF	47.02	47.1	46.78	47.08	20911202.0
2008-08-20 16:00:00	QQQ	ETF	47.08	47.27	46.964	47.05	1959444.0
2008-08-20 17:00:00	QQQ	ETF	47.03	47.07	47.03	47.07	160608.0
2008-08-20 18:00:00	QQQ	ETF	47.07	47.07	46.99	47.0	27956.0
2008-08-20 19:00:00	QQQ	ETF	47.0	47.01	46.98	46.98	9781.0
2008-08-20 05:00:00	IWM	ETF	73.25	73.25	73.25	73.25	200.0
2008-08-20 06:00:00	IWM	ETF	73.06	73.08	73.06	73.08	4500.0
2008-08-20 07:00:00	IWM	ETF	73.18	73.24	73.07	73.22	276513.0
2008-08-20 08:00:00	IWM	ETF	73.22	73.28	73.01	73.01	1889711.0
2008-08-20 09:00:00	IWM	ETF	73.02	73.46	72.57	72.82	13918311.0
2008-08-20 10:00:00	IWM	ETF	72.82	73.82	72.45	73.78	20387316.0
2008-08-20 11:00:00	IWM	ETF	73.78	73.8	72.91	73.1	13834089.0
2008-08-20 12:00:00	IWM	ETF	73.1	73.18	72.57	72.72	9372400.0
2008-08-20 13:00:00	IWM	ETF	72.72	73.2	72.67	73.1	6019806.0
2008-08-20 14:00:00	IWM	ETF	73.09	73.11	72.28	72.88	15663940.0
2008-08-20 15:00:00	IWM	ETF	72.88	73.12	72.55	73.07	14635179.0
2008-08-20 16:00:00	IWM	ETF	73.07	73.15	72.79	73.02	2774464.0
2008-08-20 17:00:00	IWM	ETF	73.05	73.15	73.05	73.15	1425.0
2008-08-20 18:00:00	IWM	ETF	73.08	73.09	73.08	73.09	500.0
2008-08-20 19:00:00	IWM	ETF	73.09	73.09	73.01	73.01	2100.0
2008-08-20 05:00:00	DIA	ETF	113.72	113.97	113.72	113.97	200.0
2008-08-20 06:00:00	DIA	ETF	113.88	113.92	113.88	113.92	200.0
2008-08-20 07:00:00	DIA	ETF	113.96	114.11	113.96	113.98	3801.0

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

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