PREVIEW / etf_30min / 2007-07-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-23.parquet
  size:    120 KB
  rows:    4,608

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
2007-07-23 06:00:00	SPY	ETF	153.51	153.51	153.51	153.51	10000.0
2007-07-23 06:30:00	SPY	ETF	153.62	153.9	153.57	153.9	62000.0
2007-07-23 07:00:00	SPY	ETF	153.8	154.12	153.8	154.08	633300.0
2007-07-23 07:30:00	SPY	ETF	154.07	154.15	153.92	153.92	495000.0
2007-07-23 08:00:00	SPY	ETF	153.985	154.14	153.1	153.93	1737900.0
2007-07-23 08:30:00	SPY	ETF	153.9	154.0	153.89	153.95	403400.0
2007-07-23 09:00:00	SPY	ETF	153.95	154.3	153.95	154.29	2157936.0
2007-07-23 09:30:00	SPY	ETF	154.28	154.42	154.01	154.09	17289404.0
2007-07-23 10:00:00	SPY	ETF	154.09	154.27	153.84	154.09	12476938.0
2007-07-23 10:30:00	SPY	ETF	154.09	154.45	154.02	154.45	7860040.0
2007-07-23 11:00:00	SPY	ETF	154.44	154.56	154.39	154.55	7099923.0
2007-07-23 11:30:00	SPY	ETF	154.55	154.72	154.4	154.5	7442040.0
2007-07-23 12:00:00	SPY	ETF	154.5	154.63	154.43	154.49	2885300.0
2007-07-23 12:30:00	SPY	ETF	154.49	154.63	154.4	154.4201	3192758.0
2007-07-23 13:00:00	SPY	ETF	154.44	154.48	154.25	154.3	4644192.0
2007-07-23 13:30:00	SPY	ETF	154.29	154.41	154.19	154.26	4060784.0
2007-07-23 14:00:00	SPY	ETF	154.26	154.29	153.94	154.13	8730703.0
2007-07-23 14:30:00	SPY	ETF	154.13	154.52	154.13	154.37	7907961.0
2007-07-23 15:00:00	SPY	ETF	154.375	154.475	154.22	154.4	5946792.0
2007-07-23 15:30:00	SPY	ETF	154.41	154.42	153.95	154.06	15102965.0
2007-07-23 16:00:00	SPY	ETF	154.04	154.15	153.9	154.03	5773300.0
2007-07-23 16:30:00	SPY	ETF	153.99	154.09	153.84	153.91	606300.0
2007-07-23 17:00:00	SPY	ETF	153.92	153.98	153.3566	153.96	1006300.0
2007-07-23 17:30:00	SPY	ETF	153.92	153.92	153.88	153.89	13200.0
2007-07-23 18:00:00	SPY	ETF	153.89	153.97	153.88	153.97	26300.0
2007-07-23 18:30:00	SPY	ETF	153.88	153.89	153.88	153.88	2500.0
2007-07-23 19:30:00	SPY	ETF	153.88	153.88	153.87	153.87	2000.0
2007-07-23 04:00:00	QQQ	ETF	50.09	50.09	50.09	50.09	500.0
2007-07-23 05:30:00	QQQ	ETF	50.12	50.14	50.12	50.14	20000.0
2007-07-23 06:30:00	QQQ	ETF	50.05	50.17	50.05	50.16	109300.0
2007-07-23 07:00:00	QQQ	ETF	50.16	50.2	50.13	50.2	55822.0
2007-07-23 07:30:00	QQQ	ETF	50.21	50.21	50.14	50.14	318490.0
2007-07-23 08:00:00	QQQ	ETF	50.14	50.17	50.13	50.15	263388.0
2007-07-23 08:30:00	QQQ	ETF	50.15	50.2	50.15	50.16	632664.0
2007-07-23 09:00:00	QQQ	ETF	50.16	50.22	50.16	50.22	1597424.0
2007-07-23 09:30:00	QQQ	ETF	50.21	50.25	50.05	50.07	11946734.0
2007-07-23 10:00:00	QQQ	ETF	50.07	50.15	49.92	50.03	10818950.0
2007-07-23 10:30:00	QQQ	ETF	50.03	50.24	50.02	50.24	10180692.0
2007-07-23 11:00:00	QQQ	ETF	50.24	50.28	50.21	50.25	5781530.0
2007-07-23 11:30:00	QQQ	ETF	50.25	50.31	50.17	50.2	4801094.0
2007-07-23 12:00:00	QQQ	ETF	50.19	50.25	50.17	50.19	2991735.0
2007-07-23 12:30:00	QQQ	ETF	50.19	50.27	50.18	50.2	2361084.0
2007-07-23 13:00:00	QQQ	ETF	50.21	50.22	50.07	50.09	3690173.0
2007-07-23 13:30:00	QQQ	ETF	50.0886	50.14	50.0	50.05	3097328.0
2007-07-23 14:00:00	QQQ	ETF	50.05	50.08	49.97	50.01	7093957.0
2007-07-23 14:30:00	QQQ	ETF	50.01	50.17	50.01	50.13	4999448.0
2007-07-23 15:00:00	QQQ	ETF	50.13	50.18	50.08	50.14	4718030.0
2007-07-23 15:30:00	QQQ	ETF	50.14	50.15	50.01	50.0601	8813222.0
2007-07-23 16:00:00	QQQ	ETF	50.066	50.12	50.03	50.04	9942233.0
2007-07-23 16:30:00	QQQ	ETF	50.05	50.08	49.85	49.95	1632467.0

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

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