PREVIEW / etf_30min / 2007-02-21

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-21.parquet
  size:    102 KB
  rows:    3,591

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-21 06:00:00	SPY	ETF	145.98	145.98	145.98	145.98	10000.0
2007-02-21 06:30:00	SPY	ETF	145.97	145.98	145.97	145.98	7000.0
2007-02-21 07:00:00	SPY	ETF	145.95	145.95	145.86	145.86	30100.0
2007-02-21 07:30:00	SPY	ETF	145.88	145.9	145.85	145.9	16500.0
2007-02-21 08:00:00	SPY	ETF	145.93	146.03	145.92	146.01	891800.0
2007-02-21 08:30:00	SPY	ETF	145.97	145.97	145.47	145.58	1997300.0
2007-02-21 09:00:00	SPY	ETF	145.6	145.64	145.56	145.59	466000.0
2007-02-21 09:30:00	SPY	ETF	145.61	145.74	145.47	145.66	8164200.0
2007-02-21 10:00:00	SPY	ETF	145.66	145.82	145.57	145.75	4829200.0
2007-02-21 10:30:00	SPY	ETF	145.74	145.75	145.35	145.61	5557400.0
2007-02-21 11:00:00	SPY	ETF	145.62	145.74	145.5	145.61	2974300.0
2007-02-21 11:30:00	SPY	ETF	145.6	145.78	145.57	145.74	2633900.0
2007-02-21 12:00:00	SPY	ETF	145.738	145.97	145.66	145.94	4041700.0
2007-02-21 12:30:00	SPY	ETF	145.94	146.07	145.82	146.0	4299800.0
2007-02-21 13:00:00	SPY	ETF	146.0	146.06	145.93	145.99	2700700.0
2007-02-21 13:30:00	SPY	ETF	145.99	146.0	145.7	145.79	5230600.0
2007-02-21 14:00:00	SPY	ETF	145.78	146.0	145.6	145.86	7257000.0
2007-02-21 14:30:00	SPY	ETF	145.86	145.98	145.76	145.92	3142600.0
2007-02-21 15:00:00	SPY	ETF	145.93	145.96	145.82	145.86	2951200.0
2007-02-21 15:30:00	SPY	ETF	145.85	145.97	145.845	145.89	3912200.0
2007-02-21 16:00:00	SPY	ETF	145.9	145.99	145.88	145.94	725200.0
2007-02-21 16:30:00	SPY	ETF	145.95	145.98	145.9	145.96	287000.0
2007-02-21 17:00:00	SPY	ETF	145.92	145.96	145.92	145.96	27400.0
2007-02-21 18:00:00	SPY	ETF	145.95	145.95	145.94	145.95	1200.0
2007-02-21 18:30:00	SPY	ETF	145.94	145.95	145.92	145.95	22100.0
2007-02-21 07:00:00	QQQ	ETF	45.0	45.02	44.97	44.97	23000.0
2007-02-21 07:30:00	QQQ	ETF	44.97	45.0	44.97	44.99	128000.0
2007-02-21 08:00:00	QQQ	ETF	45.0	45.02	44.98	44.99	171533.0
2007-02-21 08:30:00	QQQ	ETF	44.98	44.98	44.81	44.86	2329636.0
2007-02-21 09:00:00	QQQ	ETF	44.87	44.93	44.86	44.92	1468273.0
2007-02-21 09:30:00	QQQ	ETF	44.92	45.0	44.83	44.95	18428700.0
2007-02-21 10:00:00	QQQ	ETF	44.94	45.07	44.89	45.05	9823600.0
2007-02-21 10:30:00	QQQ	ETF	45.05	45.1	44.88	45.06	8763100.0
2007-02-21 11:00:00	QQQ	ETF	45.06	45.07	44.97	44.98	6894800.0
2007-02-21 11:30:00	QQQ	ETF	44.98	45.07	44.97	45.03	2913700.0
2007-02-21 12:00:00	QQQ	ETF	45.03	45.11	44.98	45.09	6919600.0
2007-02-21 12:30:00	QQQ	ETF	45.1	45.15	45.03	45.11	4327200.0
2007-02-21 13:00:00	QQQ	ETF	45.11	45.17	45.1	45.15	2797500.0
2007-02-21 13:30:00	QQQ	ETF	45.16	45.18	44.98	45.03	7285100.0
2007-02-21 14:00:00	QQQ	ETF	45.03	45.12	44.96	45.08	8199200.0
2007-02-21 14:30:00	QQQ	ETF	45.08	45.14	45.0	45.13	2643700.0
2007-02-21 15:00:00	QQQ	ETF	45.12	45.14	45.07	45.12	2374500.0
2007-02-21 15:30:00	QQQ	ETF	45.12	45.21	45.12	45.19	6894900.0
2007-02-21 16:00:00	QQQ	ETF	45.19	45.27	45.18	45.25	2165339.0
2007-02-21 16:30:00	QQQ	ETF	45.24	45.26	45.22	45.23	627596.0
2007-02-21 17:00:00	QQQ	ETF	45.23	45.24	45.21	45.23	91953.0
2007-02-21 17:30:00	QQQ	ETF	45.23	45.23	45.23	45.23	3717.0
2007-02-21 18:00:00	QQQ	ETF	45.22	45.24	45.22	45.22	13613.0
2007-02-21 18:30:00	QQQ	ETF	45.23	45.26	45.23	45.26	43008.0
2007-02-21 19:00:00	QQQ	ETF	45.24	45.26	45.23	45.23	11548.0

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

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