PREVIEW / etf_30min / 2007-10-24

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-24.parquet
  size:    139 KB
  rows:    5,121

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-10-24 04:30:00	SPY	ETF	150.88	150.88	150.88	150.88	2000.0
2007-10-24 05:30:00	SPY	ETF	151.01	151.01	150.98	150.98	18500.0
2007-10-24 06:00:00	SPY	ETF	150.97	151.0	150.97	151.0	200.0
2007-10-24 06:30:00	SPY	ETF	150.99	151.0	150.85	150.85	78000.0
2007-10-24 07:00:00	SPY	ETF	150.84	150.92	150.57	150.77	674200.0
2007-10-24 07:30:00	SPY	ETF	150.79	151.26	150.59	151.07	1603900.0
2007-10-24 08:00:00	SPY	ETF	151.09	151.76	150.6	150.93	983300.0
2007-10-24 08:30:00	SPY	ETF	150.93	151.19	150.6	151.15	2722800.0
2007-10-24 09:00:00	SPY	ETF	151.15	151.29	151.11	151.2	3443473.0
2007-10-24 09:30:00	SPY	ETF	151.21	151.48	150.95	151.28	17374874.0
2007-10-24 10:00:00	SPY	ETF	151.29	151.3	150.51	150.839	23710700.0
2007-10-24 10:30:00	SPY	ETF	150.83	150.99	149.0	150.0	31623507.0
2007-10-24 11:00:00	SPY	ETF	150.0	151.0	148.84	149.53	41268607.0
2007-10-24 11:30:00	SPY	ETF	149.53	149.93	149.29	149.51	21472042.0
2007-10-24 12:00:00	SPY	ETF	149.51	150.0	149.37	149.89	14466000.0
2007-10-24 12:30:00	SPY	ETF	149.88	150.07	149.45	149.7	12425817.0
2007-10-24 13:00:00	SPY	ETF	149.7	150.0	149.44	149.78	12089900.0
2007-10-24 13:30:00	SPY	ETF	149.78	149.82	148.0	149.56	12156200.0
2007-10-24 14:00:00	SPY	ETF	149.56	150.18	148.95	150.01	19317800.0
2007-10-24 14:30:00	SPY	ETF	150.01	150.71	149.94	150.65	30368800.0
2007-10-24 15:00:00	SPY	ETF	150.65	151.72	150.51	151.71	34973200.0
2007-10-24 15:30:00	SPY	ETF	151.71	151.73	150.77	151.56	29093500.0
2007-10-24 16:00:00	SPY	ETF	151.53	151.8739	149.4932	151.6	5442100.0
2007-10-24 16:30:00	SPY	ETF	151.53	151.87	151.44	151.73	3305100.0
2007-10-24 17:00:00	SPY	ETF	151.8	151.95	151.75	151.85	3685200.0
2007-10-24 17:30:00	SPY	ETF	151.8	151.89	151.54	151.78	268300.0
2007-10-24 18:00:00	SPY	ETF	151.78	151.82	151.74	151.74	96600.0
2007-10-24 18:30:00	SPY	ETF	151.73	151.81	151.73	151.81	42700.0
2007-10-24 19:00:00	SPY	ETF	151.81	151.89	151.78	151.83	71300.0
2007-10-24 19:30:00	SPY	ETF	151.81	151.81	151.7	151.7	5900.0
2007-10-24 04:00:00	QQQ	ETF	53.62	53.64	53.62	53.64	8000.0
2007-10-24 04:30:00	QQQ	ETF	53.66	53.67	53.62	53.62	30000.0
2007-10-24 05:00:00	QQQ	ETF	53.6	53.65	53.6	53.64	13200.0
2007-10-24 05:30:00	QQQ	ETF	53.63	53.65	53.61	53.65	63356.0
2007-10-24 06:00:00	QQQ	ETF	53.63	53.63	53.61	53.61	12500.0
2007-10-24 06:30:00	QQQ	ETF	53.62	53.62	53.59	53.59	75800.0
2007-10-24 07:00:00	QQQ	ETF	53.58	53.61	53.52	53.56	207739.0
2007-10-24 07:30:00	QQQ	ETF	53.57	53.7	53.52	53.69	513047.0
2007-10-24 08:00:00	QQQ	ETF	53.7	54.18	53.45	53.67	1193841.0
2007-10-24 08:30:00	QQQ	ETF	53.67	53.79	53.61	53.75	1100297.0
2007-10-24 09:00:00	QQQ	ETF	53.75	53.83	53.74	53.75	2197777.0
2007-10-24 09:30:00	QQQ	ETF	53.74	53.94	53.57	53.85	20991486.0
2007-10-24 10:00:00	QQQ	ETF	53.85	53.85	53.51	53.6815	21433043.0
2007-10-24 10:30:00	QQQ	ETF	53.68	53.7	53.17	53.25	23757629.0
2007-10-24 11:00:00	QQQ	ETF	53.26	53.27	52.64	52.9	36364843.0
2007-10-24 11:30:00	QQQ	ETF	52.9	53.11	52.78	52.97	21025181.0
2007-10-24 12:00:00	QQQ	ETF	52.9615	53.24	52.91	53.1	14340393.0
2007-10-24 12:30:00	QQQ	ETF	53.11	53.3	52.95	53.07	19708785.0
2007-10-24 13:00:00	QQQ	ETF	53.08	53.12	52.92	53.04	10620976.0
2007-10-24 13:30:00	QQQ	ETF	53.04	53.04	52.75	52.8	9381054.0

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

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