PREVIEW / etf_30min / 2007-08-31

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-31.parquet
  size:    122 KB
  rows:    4,574

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-31 04:00:00	SPY	ETF	147.34	147.34	147.3	147.31	3200.0
2007-08-31 06:30:00	SPY	ETF	147.69	147.91	147.63	147.89	62600.0
2007-08-31 07:00:00	SPY	ETF	147.81	147.97	147.65	147.96	1008900.0
2007-08-31 07:30:00	SPY	ETF	147.95	147.98	147.65	147.77	1209400.0
2007-08-31 08:00:00	SPY	ETF	147.77	147.96	147.5	147.65	2975300.0
2007-08-31 08:30:00	SPY	ETF	147.66	147.94	146.65	147.93	2491000.0
2007-08-31 09:00:00	SPY	ETF	147.93	147.97	147.66	147.67	3034406.0
2007-08-31 09:30:00	SPY	ETF	147.65	147.83	147.45	147.69	17087900.0
2007-08-31 10:00:00	SPY	ETF	147.69	148.07	146.94	147.37	28393400.0
2007-08-31 10:30:00	SPY	ETF	147.38	147.7	147.27	147.3	8335200.0
2007-08-31 11:00:00	SPY	ETF	147.3	147.49	146.83	147.13	16043700.0
2007-08-31 11:30:00	SPY	ETF	147.13	147.84	147.07	147.723	8662900.0
2007-08-31 12:00:00	SPY	ETF	147.73	147.99	147.57	147.91	7764400.0
2007-08-31 12:30:00	SPY	ETF	147.92	148.43	147.88	148.14	17837500.0
2007-08-31 13:00:00	SPY	ETF	148.13	148.2	147.94	148.09	5717000.0
2007-08-31 13:30:00	SPY	ETF	148.09	148.1	147.67	147.9	8818300.0
2007-08-31 14:00:00	SPY	ETF	147.89	148.12	147.72	147.83	5929700.0
2007-08-31 14:30:00	SPY	ETF	147.83	148.03	147.72	147.79	6340000.0
2007-08-31 15:00:00	SPY	ETF	147.79	148.24	147.76	148.07	7926300.0
2007-08-31 15:30:00	SPY	ETF	148.06	148.5	147.45	147.47	20983900.0
2007-08-31 16:00:00	SPY	ETF	147.44	148.2714	147.2	147.59	9185800.0
2007-08-31 16:30:00	SPY	ETF	147.59	147.73	147.45	147.72	874900.0
2007-08-31 17:00:00	SPY	ETF	147.63	147.69	147.6	147.65	79800.0
2007-08-31 17:30:00	SPY	ETF	147.6	147.6	147.56	147.56	20500.0
2007-08-31 18:00:00	SPY	ETF	147.59	147.67	147.55	147.55	12400.0
2007-08-31 18:30:00	SPY	ETF	147.55	147.58	147.45	147.58	9100.0
2007-08-31 19:30:00	SPY	ETF	147.57	147.59	147.51	147.51	1500.0
2007-08-31 04:00:00	QQQ	ETF	48.81	48.81	48.81	48.81	200.0
2007-08-31 05:30:00	QQQ	ETF	48.85	48.85	48.85	48.85	100.0
2007-08-31 06:00:00	QQQ	ETF	48.82	48.9	48.82	48.9	500.0
2007-08-31 06:30:00	QQQ	ETF	49.0	49.0	48.93	48.97	122370.0
2007-08-31 07:00:00	QQQ	ETF	48.98	49.01	48.89	49.0	180840.0
2007-08-31 07:30:00	QQQ	ETF	48.99	49.0	48.87	48.9	630794.0
2007-08-31 08:00:00	QQQ	ETF	48.9	48.91	48.8	48.87	992243.0
2007-08-31 08:30:00	QQQ	ETF	48.87	48.96	48.82	48.96	1102766.0
2007-08-31 09:00:00	QQQ	ETF	48.95	48.97	48.86	48.87	2180856.0
2007-08-31 09:30:00	QQQ	ETF	48.86	48.91	48.693	48.81	8503164.0
2007-08-31 10:00:00	QQQ	ETF	48.81	48.9	48.64	48.75	13639070.0
2007-08-31 10:30:00	QQQ	ETF	48.74	48.85	48.7	48.7	4470190.0
2007-08-31 11:00:00	QQQ	ETF	48.7015	48.78	48.61	48.6685	6000075.0
2007-08-31 11:30:00	QQQ	ETF	48.67	48.86	48.66	48.81	5713925.0
2007-08-31 12:00:00	QQQ	ETF	48.81	48.88	48.76	48.87	4140148.0
2007-08-31 12:30:00	QQQ	ETF	48.87	48.96	48.86	48.9	4362096.0
2007-08-31 13:00:00	QQQ	ETF	48.8989	48.92	48.83	48.9	2398604.0
2007-08-31 13:30:00	QQQ	ETF	48.9	48.9	48.78	48.85	3212443.0
2007-08-31 14:00:00	QQQ	ETF	48.851	48.92	48.83	48.87	1679893.0
2007-08-31 14:30:00	QQQ	ETF	48.87	48.93	48.85	48.863	3149754.0
2007-08-31 15:00:00	QQQ	ETF	48.88	49.02	48.87	48.96	5684876.0
2007-08-31 15:30:00	QQQ	ETF	48.97	49.06	48.85	48.87	9892605.0
2007-08-31 16:00:00	QQQ	ETF	48.86	49.042	48.84	48.89	3485482.0

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

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