PREVIEW / etf_30min / 2007-08-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-27.parquet
  size:    120 KB
  rows:    4,570

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-08-27 04:00:00	SPY	ETF	147.85	147.85	147.85	147.85	100.0
2007-08-27 06:30:00	SPY	ETF	147.86	147.86	147.86	147.86	3100.0
2007-08-27 07:00:00	SPY	ETF	147.9	148.01	147.83	147.96	122200.0
2007-08-27 07:30:00	SPY	ETF	147.96	148.1	147.92	148.01	86900.0
2007-08-27 08:00:00	SPY	ETF	148.06	148.06	147.81	147.88	629300.0
2007-08-27 08:30:00	SPY	ETF	147.88	147.95	147.8	147.89	561000.0
2007-08-27 09:00:00	SPY	ETF	147.89	147.94	147.84	147.86	527000.0
2007-08-27 09:30:00	SPY	ETF	147.85	147.93	147.46	147.72	11248827.0
2007-08-27 10:00:00	SPY	ETF	147.71	147.9	147.32	147.44	13934333.0
2007-08-27 10:30:00	SPY	ETF	147.45	147.5	147.22	147.39	5457242.0
2007-08-27 11:00:00	SPY	ETF	147.39	147.42	146.97	147.19	6739521.0
2007-08-27 11:30:00	SPY	ETF	147.19	147.36	147.04	147.27	5086760.0
2007-08-27 12:00:00	SPY	ETF	147.27	147.43	147.08	147.33	4093980.0
2007-08-27 12:30:00	SPY	ETF	147.34	147.51	147.22	147.28	4296577.0
2007-08-27 13:00:00	SPY	ETF	147.2795	148.33	147.26	147.48	5703845.0
2007-08-27 13:30:00	SPY	ETF	147.48	147.49	147.1	147.24	4190675.0
2007-08-27 14:00:00	SPY	ETF	147.25	147.51	147.19	147.5	5557105.0
2007-08-27 14:30:00	SPY	ETF	147.5	147.78	147.27	147.35	7424146.0
2007-08-27 15:00:00	SPY	ETF	147.34	147.5	147.13	147.26	6472980.0
2007-08-27 15:30:00	SPY	ETF	147.26	147.48	146.81	146.91	13794256.0
2007-08-27 16:00:00	SPY	ETF	146.98	147.08	146.73	146.88	5294700.0
2007-08-27 16:30:00	SPY	ETF	146.83	148.207	146.82	146.91	7473100.0
2007-08-27 17:00:00	SPY	ETF	146.93	146.95	146.9	146.93	26700.0
2007-08-27 17:30:00	SPY	ETF	146.9	146.93	146.85	146.85	8900.0
2007-08-27 18:00:00	SPY	ETF	146.89	146.95	146.88	146.92	79000.0
2007-08-27 18:30:00	SPY	ETF	146.9	146.9	146.75	146.75	11000.0
2007-08-27 19:00:00	SPY	ETF	146.81	146.83	146.79	146.83	20500.0
2007-08-27 19:30:00	SPY	ETF	146.79	146.8	146.76	146.76	600.0
2007-08-27 07:00:00	QQQ	ETF	48.13	48.13	48.13	48.13	199.0
2007-08-27 07:30:00	QQQ	ETF	48.16	48.18	48.16	48.18	25100.0
2007-08-27 08:00:00	QQQ	ETF	48.17	48.17	48.12	48.14	95095.0
2007-08-27 08:30:00	QQQ	ETF	48.14	48.15	48.11	48.11	205825.0
2007-08-27 09:00:00	QQQ	ETF	48.12	48.13	48.05	48.06	444548.0
2007-08-27 09:30:00	QQQ	ETF	48.05	48.17	48.0	48.14	9444847.0
2007-08-27 10:00:00	QQQ	ETF	48.14	48.2	47.96	48.05	6345772.0
2007-08-27 10:30:00	QQQ	ETF	48.0585	48.07	47.97	48.03	2505725.0
2007-08-27 11:00:00	QQQ	ETF	48.03	48.03	47.84	47.93	4669142.0
2007-08-27 11:30:00	QQQ	ETF	47.93	47.97	47.85	47.92	2485696.0
2007-08-27 12:00:00	QQQ	ETF	47.926	48.0	47.85	47.941	3551462.0
2007-08-27 12:30:00	QQQ	ETF	47.94	48.09	47.92	48.03	4447264.0
2007-08-27 13:00:00	QQQ	ETF	48.04	48.17	48.03	48.0805	3259267.0
2007-08-27 13:30:00	QQQ	ETF	48.09	48.1	47.98	48.0272	1884208.0
2007-08-27 14:00:00	QQQ	ETF	48.03	48.14	48.01	48.13	4136616.0
2007-08-27 14:30:00	QQQ	ETF	48.14	48.2	48.04	48.06	4250333.0
2007-08-27 15:00:00	QQQ	ETF	48.06	48.08	47.96	48.02	4218828.0
2007-08-27 15:30:00	QQQ	ETF	48.02	48.1	47.88	47.88	6845789.0
2007-08-27 16:00:00	QQQ	ETF	47.9	47.9	47.76	47.88	3844791.0
2007-08-27 16:30:00	QQQ	ETF	47.87	47.87	47.79	47.81	196031.0
2007-08-27 17:00:00	QQQ	ETF	47.81	47.86	47.81	47.86	79499.0
2007-08-27 17:30:00	QQQ	ETF	47.85	47.88	47.82	47.88	13500.0

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

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