PREVIEW / etf_30min / 2007-02-06

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-06.parquet
  size:    99 KB
  rows:    3,469

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-06 07:30:00	SPY	ETF	145.03	145.08	145.0	145.05	14600.0
2007-02-06 08:00:00	SPY	ETF	145.05	145.1	144.98	145.06	163000.0
2007-02-06 08:30:00	SPY	ETF	145.04	145.07	144.98	145.01	591300.0
2007-02-06 09:00:00	SPY	ETF	145.0	145.01	144.93	145.01	62500.0
2007-02-06 09:30:00	SPY	ETF	144.97	145.03	144.78	144.87	6037100.0
2007-02-06 10:00:00	SPY	ETF	144.86	144.92	144.72	144.87	5642400.0
2007-02-06 10:30:00	SPY	ETF	144.86	144.89	144.54	144.56	4456300.0
2007-02-06 11:00:00	SPY	ETF	144.56	144.66	144.49	144.55	4002400.0
2007-02-06 11:30:00	SPY	ETF	144.55	144.62	144.33	144.34	12750500.0
2007-02-06 12:00:00	SPY	ETF	144.33	144.52	144.33	144.47	2234100.0
2007-02-06 12:30:00	SPY	ETF	144.47	144.48	144.36	144.41	1463600.0
2007-02-06 13:00:00	SPY	ETF	144.42	144.69	144.42	144.58	3337000.0
2007-02-06 13:30:00	SPY	ETF	144.57	144.72	144.56	144.67	2143800.0
2007-02-06 14:00:00	SPY	ETF	144.67	144.72	144.53	144.67	2741400.0
2007-02-06 14:30:00	SPY	ETF	144.67	144.83	144.62	144.8028	3500500.0
2007-02-06 15:00:00	SPY	ETF	144.81	144.92	144.77	144.81	2744200.0
2007-02-06 15:30:00	SPY	ETF	144.8	144.85	144.72	144.79	3124700.0
2007-02-06 16:00:00	SPY	ETF	144.79	144.98	144.75	144.93	402000.0
2007-02-06 16:30:00	SPY	ETF	144.87	145.0	144.83	144.98	738900.0
2007-02-06 17:00:00	SPY	ETF	144.99	144.99	144.94	144.96	12600.0
2007-02-06 17:30:00	SPY	ETF	144.96	145.01	144.93	144.93	21400.0
2007-02-06 18:00:00	SPY	ETF	144.98	144.98	144.98	144.98	500.0
2007-02-06 18:30:00	SPY	ETF	144.95	144.97	144.95	144.97	1600.0
2007-02-06 19:00:00	SPY	ETF	144.96	144.96	144.95	144.95	900.0
2007-02-06 19:30:00	SPY	ETF	144.95	144.97	144.95	144.97	600.0
2007-02-06 05:00:00	QQQ	ETF	44.2	44.2	44.2	44.2	400.0
2007-02-06 07:00:00	QQQ	ETF	44.2	44.21	44.2	44.21	1400.0
2007-02-06 07:30:00	QQQ	ETF	44.21	44.23	44.21	44.22	38669.0
2007-02-06 08:00:00	QQQ	ETF	44.22	44.22	44.2	44.21	171508.0
2007-02-06 08:30:00	QQQ	ETF	44.21	44.21	44.17	44.19	189501.0
2007-02-06 09:00:00	QQQ	ETF	44.19	44.23	44.18	44.22	377473.0
2007-02-06 09:30:00	QQQ	ETF	44.22	44.23	44.07	44.11	14569200.0
2007-02-06 10:00:00	QQQ	ETF	44.11	44.12	43.97	44.05	11769300.0
2007-02-06 10:30:00	QQQ	ETF	44.04	44.07	43.71	43.72	12583700.0
2007-02-06 11:00:00	QQQ	ETF	43.72	43.83	43.67	43.78	10605000.0
2007-02-06 11:30:00	QQQ	ETF	43.78	43.81	43.64	43.64	8183500.0
2007-02-06 12:00:00	QQQ	ETF	43.65	43.78	43.64	43.74	4259200.0
2007-02-06 12:30:00	QQQ	ETF	43.74	43.75	43.69	43.73	2533300.0
2007-02-06 13:00:00	QQQ	ETF	43.74	43.89	43.73	43.82	7951600.0
2007-02-06 13:30:00	QQQ	ETF	43.82	43.98	43.81	43.91	9014200.0
2007-02-06 14:00:00	QQQ	ETF	43.91	43.94	43.81	43.9	3932100.0
2007-02-06 14:30:00	QQQ	ETF	43.91	44.04	43.88	44.04	4227500.0
2007-02-06 15:00:00	QQQ	ETF	44.05	44.12	44.04	44.09	5937800.0
2007-02-06 15:30:00	QQQ	ETF	44.08	44.09	44.03	44.06	7579800.0
2007-02-06 16:00:00	QQQ	ETF	44.07	44.1	44.01	44.06	5670583.0
2007-02-06 16:30:00	QQQ	ETF	44.06	44.3	44.06	44.27	2398873.0
2007-02-06 17:00:00	QQQ	ETF	44.27	44.27	44.21	44.22	355372.0
2007-02-06 17:30:00	QQQ	ETF	44.23	44.29	44.23	44.25	109117.0
2007-02-06 18:00:00	QQQ	ETF	44.25	44.25	44.21	44.22	27780.0
2007-02-06 18:30:00	QQQ	ETF	44.23	44.24	44.22	44.24	9290.0

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

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