PREVIEW / etf_30min / 2007-04-18

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-18.parquet
  size:    105 KB
  rows:    3,709

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-04-18 06:30:00	SPY	ETF	146.9	147.02	146.9	147.02	5200.0
2007-04-18 07:00:00	SPY	ETF	146.98	147.01	146.8	146.8	11000.0
2007-04-18 07:30:00	SPY	ETF	146.86	146.86	146.74	146.81	34600.0
2007-04-18 08:00:00	SPY	ETF	146.81	146.97	146.58	146.63	1345300.0
2007-04-18 08:30:00	SPY	ETF	146.63	146.69	146.52	146.68	1407500.0
2007-04-18 09:00:00	SPY	ETF	146.67	146.72	146.6	146.6	555300.0
2007-04-18 09:30:00	SPY	ETF	146.6	146.89	146.57	146.86	11594155.0
2007-04-18 10:00:00	SPY	ETF	146.87	147.1	146.58	146.99	12274064.0
2007-04-18 10:30:00	SPY	ETF	146.99	147.15	146.88	147.02	7587593.0
2007-04-18 11:00:00	SPY	ETF	147.02	147.31	147.0	147.19	7704768.0
2007-04-18 11:30:00	SPY	ETF	147.18	147.24	147.12	147.12	2208593.0
2007-04-18 12:00:00	SPY	ETF	147.12	147.22	147.07	147.22	1761898.0
2007-04-18 12:30:00	SPY	ETF	147.22	147.235	146.97	147.02	4689049.0
2007-04-18 13:00:00	SPY	ETF	147.01	147.18	147.0	147.15	4563835.0
2007-04-18 13:30:00	SPY	ETF	147.15	147.29	147.04	147.21	3997357.0
2007-04-18 14:00:00	SPY	ETF	147.2	147.39	147.19	147.32	3307700.0
2007-04-18 14:30:00	SPY	ETF	147.32	147.37	147.23	147.33	4137023.0
2007-04-18 15:00:00	SPY	ETF	147.33	147.7	147.31	147.59	6735084.0
2007-04-18 15:30:00	SPY	ETF	147.59	147.6	147.14	147.15	9183444.0
2007-04-18 16:00:00	SPY	ETF	147.14	147.36	147.11	147.29	1594900.0
2007-04-18 16:30:00	SPY	ETF	147.3	147.3	147.08	147.16	1896200.0
2007-04-18 17:00:00	SPY	ETF	147.16	147.21	147.14	147.165	131200.0
2007-04-18 17:30:00	SPY	ETF	147.17	147.26	147.17	147.26	5900.0
2007-04-18 18:00:00	SPY	ETF	147.22	147.22	147.2	147.2	600.0
2007-04-18 18:30:00	SPY	ETF	147.19	147.19	147.14	147.19	7400.0
2007-04-18 19:00:00	SPY	ETF	147.17	147.17	147.17	147.17	300.0
2007-04-18 19:30:00	SPY	ETF	147.12	147.12	147.1	147.1	400.0
2007-04-18 06:30:00	QQQ	ETF	45.06	45.1	45.06	45.1	5800.0
2007-04-18 07:00:00	QQQ	ETF	45.07	45.11	44.97	44.98	475200.0
2007-04-18 07:30:00	QQQ	ETF	44.99	45.01	44.97	44.99	232639.0
2007-04-18 08:00:00	QQQ	ETF	44.99	45.0	44.92	44.93	1103915.0
2007-04-18 08:30:00	QQQ	ETF	44.93	44.94	44.89	44.93	498791.0
2007-04-18 09:00:00	QQQ	ETF	44.93	44.95	44.91	44.93	1332118.0
2007-04-18 09:30:00	QQQ	ETF	44.93	45.02	44.89	44.96	10525900.0
2007-04-18 10:00:00	QQQ	ETF	44.96	45.06	44.83	44.97	13244900.0
2007-04-18 10:30:00	QQQ	ETF	44.98	45.05	44.94	45.03	7029300.0
2007-04-18 11:00:00	QQQ	ETF	45.02	45.12	45.02	45.05	4541800.0
2007-04-18 11:30:00	QQQ	ETF	45.06	45.09	45.03	45.07	2298200.0
2007-04-18 12:00:00	QQQ	ETF	45.07	45.08	45.03	45.06	1730000.0
2007-04-18 12:30:00	QQQ	ETF	45.06	45.07	44.96	44.99	3424900.0
2007-04-18 13:00:00	QQQ	ETF	45.0	45.04	44.99	45.01	3395600.0
2007-04-18 13:30:00	QQQ	ETF	45.01	45.08	44.99	45.05	2696700.0
2007-04-18 14:00:00	QQQ	ETF	45.06	45.13	45.06	45.09	3024700.0
2007-04-18 14:30:00	QQQ	ETF	45.1	45.11	45.05	45.1	2883500.0
2007-04-18 15:00:00	QQQ	ETF	45.11	45.23	45.09	45.21	5964900.0
2007-04-18 15:30:00	QQQ	ETF	45.21	45.23	45.01	45.01	9352900.0
2007-04-18 16:00:00	QQQ	ETF	45.01	45.16	45.0	45.12	2567931.0
2007-04-18 16:30:00	QQQ	ETF	45.12	45.12	45.05	45.07	2192242.0
2007-04-18 17:00:00	QQQ	ETF	45.07	45.09	45.06	45.08	2765373.0
2007-04-18 17:30:00	QQQ	ETF	45.09	45.15	45.06	45.15	266150.0

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

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