PREVIEW / etf_30min / 2007-02-01

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-01.parquet
  size:    99 KB
  rows:    3,469

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-02-01 05:00:00	SPY	ETF	143.98	143.98	143.98	143.98	400.0
2007-02-01 06:00:00	SPY	ETF	144.07	144.07	144.07	144.07	1000.0
2007-02-01 06:30:00	SPY	ETF	144.05	144.05	144.05	144.05	5000.0
2007-02-01 07:00:00	SPY	ETF	143.99	143.99	143.92	143.99	50400.0
2007-02-01 07:30:00	SPY	ETF	143.99	144.03	143.94	144.03	70400.0
2007-02-01 08:00:00	SPY	ETF	144.01	144.07	143.8	144.07	460200.0
2007-02-01 08:30:00	SPY	ETF	144.05	144.25	144.05	144.23	949600.0
2007-02-01 09:00:00	SPY	ETF	144.21	144.27	143.8	144.15	1195900.0
2007-02-01 09:30:00	SPY	ETF	144.15	144.39	144.05	144.31	8528300.0
2007-02-01 10:00:00	SPY	ETF	144.31	144.39	144.02	144.0901	12659600.0
2007-02-01 10:30:00	SPY	ETF	144.09	144.41	144.02	144.2	5551700.0
2007-02-01 11:00:00	SPY	ETF	144.2	144.21	143.91	144.01	6074000.0
2007-02-01 11:30:00	SPY	ETF	144.0	144.25	143.99	144.19	4915700.0
2007-02-01 12:00:00	SPY	ETF	144.19	144.25	144.11	144.15	2883600.0
2007-02-01 12:30:00	SPY	ETF	144.15	144.24	144.09	144.18	2869300.0
2007-02-01 13:00:00	SPY	ETF	144.18	144.25	144.12	144.17	2190200.0
2007-02-01 13:30:00	SPY	ETF	144.17	144.38	144.14	144.27	4273100.0
2007-02-01 14:00:00	SPY	ETF	144.27	144.38	144.2	144.35	2201400.0
2007-02-01 14:30:00	SPY	ETF	144.34	144.49	144.31	144.47	2455400.0
2007-02-01 15:00:00	SPY	ETF	144.48	144.66	144.47	144.49	4513100.0
2007-02-01 15:30:00	SPY	ETF	144.49	144.65	144.48	144.57	4731900.0
2007-02-01 16:00:00	SPY	ETF	144.57	144.62	144.5	144.61	819700.0
2007-02-01 16:30:00	SPY	ETF	144.59	144.6	144.52	144.59	305300.0
2007-02-01 17:00:00	SPY	ETF	144.59	144.6	144.59	144.6	13800.0
2007-02-01 17:30:00	SPY	ETF	144.61	144.64	144.57	144.58	30600.0
2007-02-01 18:00:00	SPY	ETF	144.6	144.6	144.56	144.56	2900.0
2007-02-01 18:30:00	SPY	ETF	144.55	144.55	144.54	144.54	4500.0
2007-02-01 19:00:00	SPY	ETF	144.53	144.53	144.53	144.53	100.0
2007-02-01 19:30:00	SPY	ETF	144.53	144.53	144.53	144.53	300.0
2007-02-01 05:30:00	QQQ	ETF	44.13	44.13	44.13	44.13	1000.0
2007-02-01 06:00:00	QQQ	ETF	44.18	44.18	44.18	44.18	25000.0
2007-02-01 07:00:00	QQQ	ETF	44.14	44.14	44.14	44.14	5100.0
2007-02-01 07:30:00	QQQ	ETF	44.13	44.14	44.13	44.14	22000.0
2007-02-01 08:00:00	QQQ	ETF	44.16	44.17	44.14	44.16	358519.0
2007-02-01 08:30:00	QQQ	ETF	44.16	44.28	44.15	44.27	1337203.0
2007-02-01 09:00:00	QQQ	ETF	44.27	44.32	44.24	44.27	1853922.0
2007-02-01 09:30:00	QQQ	ETF	44.27	44.4	44.2	44.33	25917000.0
2007-02-01 10:00:00	QQQ	ETF	44.33	44.39	44.11	44.13	25613800.0
2007-02-01 10:30:00	QQQ	ETF	44.13	44.24	44.1	44.14	9053700.0
2007-02-01 11:00:00	QQQ	ETF	44.14	44.15	43.85	43.96	15362800.0
2007-02-01 11:30:00	QQQ	ETF	43.95	44.04	43.91	44.01	9715300.0
2007-02-01 12:00:00	QQQ	ETF	44.01	44.08	43.98	43.99	7944600.0
2007-02-01 12:30:00	QQQ	ETF	43.99	44.03	43.95	43.95	2990400.0
2007-02-01 13:00:00	QQQ	ETF	43.95	44.0	43.87	43.94	4547200.0
2007-02-01 13:30:00	QQQ	ETF	43.94	44.02	43.9	43.95	8298600.0
2007-02-01 14:00:00	QQQ	ETF	43.96	44.01	43.88	43.98	7923900.0
2007-02-01 14:30:00	QQQ	ETF	43.98	44.03	43.94	44.02	2950100.0
2007-02-01 15:00:00	QQQ	ETF	44.02	44.15	44.01	44.08	8499200.0
2007-02-01 15:30:00	QQQ	ETF	44.09	44.11	44.0	44.0	10223000.0
2007-02-01 16:00:00	QQQ	ETF	44.01	44.08	44.0	44.07	2736210.0

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

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