PREVIEW / etf_30min / 2008-01-03

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-03.parquet
  size:    143 KB
  rows:    5,283

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-01-03 05:30:00	SPY	ETF	144.73	144.73	144.71	144.71	3000.0
2008-01-03 06:00:00	SPY	ETF	144.65	144.65	144.65	144.65	1000.0
2008-01-03 06:30:00	SPY	ETF	144.64	144.64	144.58	144.59	44000.0
2008-01-03 07:00:00	SPY	ETF	144.6	145.13	144.6	145.0	220300.0
2008-01-03 07:30:00	SPY	ETF	144.98	145.04	144.7	144.73	123400.0
2008-01-03 08:00:00	SPY	ETF	144.75	145.3	144.6	145.15	1418600.0
2008-01-03 08:30:00	SPY	ETF	145.18	145.41	144.93	145.18	2369500.0
2008-01-03 09:00:00	SPY	ETF	145.17	145.23	144.88	144.92	803600.0
2008-01-03 09:30:00	SPY	ETF	144.91	145.12	144.51	144.8	16862064.0
2008-01-03 10:00:00	SPY	ETF	144.8	145.41	144.8	144.97	13615246.0
2008-01-03 10:30:00	SPY	ETF	144.97	145.24	144.6	144.79	12011925.0
2008-01-03 11:00:00	SPY	ETF	144.79	145.23	144.77	145.0	6778082.0
2008-01-03 11:30:00	SPY	ETF	145.0	145.32	144.93	145.13	5519924.0
2008-01-03 12:00:00	SPY	ETF	145.14	145.46	145.12	145.46	5132016.0
2008-01-03 12:30:00	SPY	ETF	145.45	145.49	145.03	145.19	6982651.0
2008-01-03 13:00:00	SPY	ETF	145.19	145.19	144.86	145.0	5285709.0
2008-01-03 13:30:00	SPY	ETF	145.0	145.1	144.75	144.8	3828390.0
2008-01-03 14:00:00	SPY	ETF	144.8	145.49	144.61	144.91	8362904.0
2008-01-03 14:30:00	SPY	ETF	144.91	144.99	144.7	144.78	4357585.0
2008-01-03 15:00:00	SPY	ETF	144.78	144.82	144.12	144.22	11421600.0
2008-01-03 15:30:00	SPY	ETF	144.23	144.61	144.15	144.46	11161262.0
2008-01-03 16:00:00	SPY	ETF	144.49	145.18	144.49	144.9	2955300.0
2008-01-03 16:30:00	SPY	ETF	144.9	144.92	144.5081	144.87	4052700.0
2008-01-03 17:00:00	SPY	ETF	144.86	144.86	144.79	144.86	109900.0
2008-01-03 17:30:00	SPY	ETF	144.86	144.87	144.84	144.86	1700.0
2008-01-03 18:00:00	SPY	ETF	144.87	144.89	144.85	144.86	45100.0
2008-01-03 18:30:00	SPY	ETF	144.83	144.92	144.83	144.92	16700.0
2008-01-03 19:00:00	SPY	ETF	144.91	144.91	144.69	144.75	17800.0
2008-01-03 19:30:00	SPY	ETF	144.72	144.77	144.61	144.61	7500.0
2008-01-03 06:30:00	QQQ	ETF	50.28	50.31	50.27	50.31	27100.0
2008-01-03 07:00:00	QQQ	ETF	50.31	50.47	50.29	50.44	136067.0
2008-01-03 07:30:00	QQQ	ETF	50.44	50.47	50.29	50.31	227500.0
2008-01-03 08:00:00	QQQ	ETF	50.33	50.55	50.27	50.53	639831.0
2008-01-03 08:30:00	QQQ	ETF	50.52	50.59	50.41	50.5	1029290.0
2008-01-03 09:00:00	QQQ	ETF	50.49	50.5	50.37	50.4	1121982.0
2008-01-03 09:30:00	QQQ	ETF	50.39	50.52	50.2	50.28	19064114.0
2008-01-03 10:00:00	QQQ	ETF	50.28	50.64	50.28	50.4	16878511.0
2008-01-03 10:30:00	QQQ	ETF	50.41	50.47	50.25	50.37	11297980.0
2008-01-03 11:00:00	QQQ	ETF	50.37	50.54	50.37	50.43	6111595.0
2008-01-03 11:30:00	QQQ	ETF	50.42	50.57	50.4	50.51	4492043.0
2008-01-03 12:00:00	QQQ	ETF	50.51	50.73	50.472	50.72	4935351.0
2008-01-03 12:30:00	QQQ	ETF	50.71	50.76	50.54	50.6	5839442.0
2008-01-03 13:00:00	QQQ	ETF	50.6	50.6199	50.47	50.5289	4948070.0
2008-01-03 13:30:00	QQQ	ETF	50.52	50.59	50.43	50.4605	2988388.0
2008-01-03 14:00:00	QQQ	ETF	50.46	50.5	50.31	50.44	5226237.0
2008-01-03 14:30:00	QQQ	ETF	50.442	50.49	50.39	50.43	3242724.0
2008-01-03 15:00:00	QQQ	ETF	50.43	50.43	50.18	50.21	8080390.0
2008-01-03 15:30:00	QQQ	ETF	50.2199	50.44	50.15	50.43	11641970.0
2008-01-03 16:00:00	QQQ	ETF	50.43	50.63	50.43	50.57	6229237.0
2008-01-03 16:30:00	QQQ	ETF	50.59	50.62	50.53	50.56	998062.0

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

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