PREVIEW / etf_1hour / 2008-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-05.parquet
  size:    109 KB
  rows:    3,510

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-05 04:00:00	SPY	ETF	125.5	126.1	125.5	125.9	5300.0
2008-08-05 05:00:00	SPY	ETF	125.98	126.02	125.85	126.02	3600.0
2008-08-05 06:00:00	SPY	ETF	126.03	126.21	125.92	126.08	123200.0
2008-08-05 07:00:00	SPY	ETF	126.07	126.12	125.78	125.86	861975.0
2008-08-05 08:00:00	SPY	ETF	125.86	126.1	125.76	125.95	3321723.0
2008-08-05 09:00:00	SPY	ETF	125.92	126.49	125.86	126.45	27074594.0
2008-08-05 10:00:00	SPY	ETF	126.45	126.89	126.4	126.89	38935216.0
2008-08-05 11:00:00	SPY	ETF	126.89	127.18	126.81	127.17	16921849.0
2008-08-05 12:00:00	SPY	ETF	127.17	127.38	126.98	127.25	16385558.0
2008-08-05 13:00:00	SPY	ETF	127.24	127.5	127.16	127.3	18822031.0
2008-08-05 14:00:00	SPY	ETF	127.305	128.04	126.78	127.81	72285275.0
2008-08-05 15:00:00	SPY	ETF	127.8	128.47	127.15	128.42	48406001.0
2008-08-05 16:00:00	SPY	ETF	128.421	128.56	127.1	128.45	5497765.0
2008-08-05 17:00:00	SPY	ETF	128.46	128.62	128.44	128.58	347990.0
2008-08-05 18:00:00	SPY	ETF	128.6	128.62	128.36	128.5	134614.0
2008-08-05 19:00:00	SPY	ETF	128.49	128.54	128.49	128.54	41703.0
2008-08-05 04:00:00	QQQ	ETF	44.76	44.96	44.76	44.96	2200.0
2008-08-05 05:00:00	QQQ	ETF	44.98	45.0	44.98	45.0	200.0
2008-08-05 06:00:00	QQQ	ETF	44.92	44.96	44.9	44.96	150700.0
2008-08-05 07:00:00	QQQ	ETF	44.92	44.92	44.8	44.81	858972.0
2008-08-05 08:00:00	QQQ	ETF	44.81	44.91	44.8	44.86	1623762.0
2008-08-05 09:00:00	QQQ	ETF	44.85	45.06	44.84	45.05	16690923.0
2008-08-05 10:00:00	QQQ	ETF	45.04	45.2	45.03	45.18	19762011.0
2008-08-05 11:00:00	QQQ	ETF	45.18	45.43	45.161	45.4201	12839075.0
2008-08-05 12:00:00	QQQ	ETF	45.43	45.43	45.3	45.3812	7787128.0
2008-08-05 13:00:00	QQQ	ETF	45.39	45.48	45.34	45.39	9012739.0
2008-08-05 14:00:00	QQQ	ETF	45.38	45.8	45.14	45.69	38877108.0
2008-08-05 15:00:00	QQQ	ETF	45.68	45.97	45.61	45.95	28186206.0
2008-08-05 16:00:00	QQQ	ETF	45.93	46.07	45.3354	46.06	11027032.0
2008-08-05 17:00:00	QQQ	ETF	46.05	46.25	46.05	46.19	1391186.0
2008-08-05 18:00:00	QQQ	ETF	45.93	46.19	45.93	46.15	243377.0
2008-08-05 19:00:00	QQQ	ETF	46.15	46.18	46.14	46.18	63947.0
2008-08-05 04:00:00	IWM	ETF	70.78	70.78	70.73	70.73	300.0
2008-08-05 05:00:00	IWM	ETF	70.86	70.86	70.86	70.86	100.0
2008-08-05 06:00:00	IWM	ETF	70.87	70.97	70.87	70.91	22300.0
2008-08-05 07:00:00	IWM	ETF	70.95	71.02	70.77	70.81	278700.0
2008-08-05 08:00:00	IWM	ETF	70.81	70.93	70.76	70.85	1072350.0
2008-08-05 09:00:00	IWM	ETF	70.84	71.3	70.75	71.27	11235766.0
2008-08-05 10:00:00	IWM	ETF	71.27	71.48	71.12	71.35	13318834.0
2008-08-05 11:00:00	IWM	ETF	71.34	71.39	71.16	71.38	11392290.0
2008-08-05 12:00:00	IWM	ETF	71.39	71.43	71.23	71.29	5965167.0
2008-08-05 13:00:00	IWM	ETF	71.29	71.32	71.14	71.15	7649286.0
2008-08-05 14:00:00	IWM	ETF	71.16	71.57	70.91	71.41	18592248.0
2008-08-05 15:00:00	IWM	ETF	71.41	71.97	71.34	71.75	14899397.0
2008-08-05 16:00:00	IWM	ETF	71.75	72.02	71.36	71.99	3093802.0
2008-08-05 17:00:00	IWM	ETF	71.99	72.02	71.99	72.02	21199.0
2008-08-05 18:00:00	IWM	ETF	71.97	71.97	71.89	71.89	1368.0
2008-08-05 19:00:00	IWM	ETF	71.95	72.0	71.95	72.0	81900.0
2008-08-05 06:00:00	DIA	ETF	113.36	113.36	113.36	113.36	100.0
2008-08-05 07:00:00	DIA	ETF	113.71	113.73	113.55	113.58	6400.0

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

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