PREVIEW / etf_30min / 2008-08-20

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-20.parquet
  size:    170 KB
  rows:    5,971

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.53	127.53	127.53	300.0
2008-08-20 04:30:00	SPY	ETF	127.55	127.55	127.55	127.55	100.0
2008-08-20 05:00:00	SPY	ETF	127.63	127.67	127.63	127.67	4600.0
2008-08-20 05:30:00	SPY	ETF	127.66	127.66	127.66	127.66	2500.0
2008-08-20 06:00:00	SPY	ETF	127.63	127.63	127.32	127.35	142270.0
2008-08-20 06:30:00	SPY	ETF	127.42	127.55	127.38	127.55	18300.0
2008-08-20 07:00:00	SPY	ETF	127.53	127.6	127.43	127.5	179950.0
2008-08-20 07:30:00	SPY	ETF	127.5	127.56	127.4	127.47	586866.0
2008-08-20 08:00:00	SPY	ETF	127.49	127.63	127.15	127.22	2369770.0
2008-08-20 08:30:00	SPY	ETF	127.21	127.32	127.08	127.08	990304.0
2008-08-20 09:00:00	SPY	ETF	127.12	127.44	127.07	127.39	2078309.0
2008-08-20 09:30:00	SPY	ETF	127.39	127.39	126.38	126.65	29614895.0
2008-08-20 10:00:00	SPY	ETF	126.64	127.25	126.34	126.92	26763960.0
2008-08-20 10:30:00	SPY	ETF	126.92	127.86	126.9	127.83	27523213.0
2008-08-20 11:00:00	SPY	ETF	127.83	127.95	127.58	127.69	15584937.0
2008-08-20 11:30:00	SPY	ETF	127.68	127.8	127.15	127.36	13149613.0
2008-08-20 12:00:00	SPY	ETF	127.37	127.48	126.86	127.05	12662015.0
2008-08-20 12:30:00	SPY	ETF	127.06	127.17	126.72	126.95	10973540.0
2008-08-20 13:00:00	SPY	ETF	126.95	127.24	126.9	127.13	8665537.0
2008-08-20 13:30:00	SPY	ETF	127.14	127.29	127.03	127.17	6121465.0
2008-08-20 14:00:00	SPY	ETF	127.17	127.18	126.59	126.73	10551777.0
2008-08-20 14:30:00	SPY	ETF	126.74	127.23	126.62	127.2	12187268.0
2008-08-20 15:00:00	SPY	ETF	127.21	127.38	126.91	127.1	15401661.0
2008-08-20 15:30:00	SPY	ETF	127.1	127.78	126.85	127.71	21518203.0
2008-08-20 16:00:00	SPY	ETF	127.7024	127.75	127.6	127.65	2569003.0
2008-08-20 16:30:00	SPY	ETF	127.65	127.68	127.58	127.68	3658696.0
2008-08-20 17:00:00	SPY	ETF	127.65	127.78	127.65	127.76	18864.0
2008-08-20 17:30:00	SPY	ETF	127.75	127.79	126.99	127.76	37525.0
2008-08-20 18:00:00	SPY	ETF	127.72	127.72	127.6	127.6	9700.0
2008-08-20 18:30:00	SPY	ETF	127.65	127.65	127.6	127.65	7570.0
2008-08-20 19:00:00	SPY	ETF	127.62	127.65	127.62	127.65	3100.0
2008-08-20 19:30:00	SPY	ETF	127.62	127.63	127.62	127.62	3215.0
2008-08-20 04:00:00	QQQ	ETF	47.37	47.37	47.37	47.37	1000.0
2008-08-20 04:30:00	QQQ	ETF	47.35	47.39	47.35	47.39	3100.0
2008-08-20 05:00:00	QQQ	ETF	47.4	47.4	47.4	47.4	200.0
2008-08-20 05:30:00	QQQ	ETF	47.43	47.43	47.42	47.42	300.0
2008-08-20 06:00:00	QQQ	ETF	47.31	47.31	47.29	47.29	20000.0
2008-08-20 06:30:00	QQQ	ETF	47.31	47.32	47.3	47.32	57000.0
2008-08-20 07:00:00	QQQ	ETF	47.33	47.37	47.33	47.37	45950.0
2008-08-20 07:30:00	QQQ	ETF	47.36	47.39	47.3	47.36	329496.0
2008-08-20 08:00:00	QQQ	ETF	47.36	47.37	47.21	47.22	3390417.0
2008-08-20 08:30:00	QQQ	ETF	47.22	47.25	47.18	47.19	663329.0
2008-08-20 09:00:00	QQQ	ETF	47.2	47.36	47.2	47.36	1042869.0
2008-08-20 09:30:00	QQQ	ETF	47.36	47.36	46.92	47.0799	18449719.0
2008-08-20 10:00:00	QQQ	ETF	47.07	47.24	46.93	47.01	16389559.0
2008-08-20 10:30:00	QQQ	ETF	47.01	47.55	47.01	47.5	23788776.0
2008-08-20 11:00:00	QQQ	ETF	47.5	47.56	47.36	47.43	8360127.0
2008-08-20 11:30:00	QQQ	ETF	47.43	47.43	47.12	47.24	7452460.0
2008-08-20 12:00:00	QQQ	ETF	47.24	47.3	46.88	46.99	9514728.0
2008-08-20 12:30:00	QQQ	ETF	47.0	47.08	46.89	46.98	4508891.0

> showing 50 of 5,971 rows — these rows as CSV

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