PREVIEW / etf_30min / 2007-09-14

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-14.parquet
  size:    119 KB
  rows:    4,472

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-09-14 05:00:00	SPY	ETF	148.3	148.3	148.3	148.3	1000.0
2007-09-14 05:30:00	SPY	ETF	148.16	148.19	148.13	148.14	400.0
2007-09-14 06:00:00	SPY	ETF	148.14	148.28	148.14	148.2	5100.0
2007-09-14 06:30:00	SPY	ETF	148.16	148.2	147.79	147.91	108300.0
2007-09-14 07:00:00	SPY	ETF	147.91	148.05	147.81	148.03	391100.0
2007-09-14 07:30:00	SPY	ETF	148.01	148.35	147.91	148.25	629000.0
2007-09-14 08:00:00	SPY	ETF	148.11	148.26	148.04	148.25	873700.0
2007-09-14 08:30:00	SPY	ETF	148.19	148.19	147.68	147.88	3329100.0
2007-09-14 09:00:00	SPY	ETF	147.89	148.03	147.77	147.96	822800.0
2007-09-14 09:30:00	SPY	ETF	147.96	148.24	147.74	148.07	13964441.0
2007-09-14 10:00:00	SPY	ETF	148.08	148.71	148.07	148.56	14342200.0
2007-09-14 10:30:00	SPY	ETF	148.55	148.85	148.36	148.55	10158100.0
2007-09-14 11:00:00	SPY	ETF	148.56	148.71	148.3	148.48	6710100.0
2007-09-14 11:30:00	SPY	ETF	148.48	148.87	148.42	148.725	4156800.0
2007-09-14 12:00:00	SPY	ETF	148.73	148.96	148.62	148.71	4469000.0
2007-09-14 12:30:00	SPY	ETF	148.71	148.79	148.5	148.57	3458000.0
2007-09-14 13:00:00	SPY	ETF	148.57	149.03	148.47	148.98	8067000.0
2007-09-14 13:30:00	SPY	ETF	148.98	149.06	148.74	149.03	6071300.0
2007-09-14 14:00:00	SPY	ETF	149.03	149.09	148.7	148.77	8544900.0
2007-09-14 14:30:00	SPY	ETF	148.77	148.86	148.36	148.56	8105500.0
2007-09-14 15:00:00	SPY	ETF	148.56	148.88	148.51	148.77	4440800.0
2007-09-14 15:30:00	SPY	ETF	148.77	149.06	148.7	148.92	14275600.0
2007-09-14 16:00:00	SPY	ETF	148.9	149.04	148.2775	148.82	3802600.0
2007-09-14 16:30:00	SPY	ETF	148.82	148.94	148.8	148.91	1685000.0
2007-09-14 17:00:00	SPY	ETF	148.91	148.94	148.9	148.9	25100.0
2007-09-14 17:30:00	SPY	ETF	148.9	148.9	148.88	148.9	116300.0
2007-09-14 18:00:00	SPY	ETF	148.91	148.91	148.9	148.91	1600.0
2007-09-14 18:30:00	SPY	ETF	148.88	148.88	148.82	148.82	5300.0
2007-09-14 19:00:00	SPY	ETF	148.9	148.93	148.9	148.93	1500.0
2007-09-14 19:30:00	SPY	ETF	148.93	148.97	148.93	148.93	2800.0
2007-09-14 05:30:00	QQQ	ETF	48.85	48.85	48.85	48.85	300.0
2007-09-14 06:00:00	QQQ	ETF	48.83	48.83	48.83	48.83	1200.0
2007-09-14 06:30:00	QQQ	ETF	48.79	48.79	48.75	48.75	600.0
2007-09-14 07:00:00	QQQ	ETF	48.73	48.78	48.71	48.75	222016.0
2007-09-14 07:30:00	QQQ	ETF	48.76	48.88	48.76	48.85	428583.0
2007-09-14 08:00:00	QQQ	ETF	48.86	48.88	48.79	48.84	728554.0
2007-09-14 08:30:00	QQQ	ETF	48.83	48.88	48.73	48.77	2003517.0
2007-09-14 09:00:00	QQQ	ETF	48.78	48.84	48.74	48.8	509371.0
2007-09-14 09:30:00	QQQ	ETF	48.8	49.0	48.73	48.962	13071413.0
2007-09-14 10:00:00	QQQ	ETF	48.97	49.18	48.965	49.13	8403472.0
2007-09-14 10:30:00	QQQ	ETF	49.13	49.24	49.09	49.149	7439791.0
2007-09-14 11:00:00	QQQ	ETF	49.15	49.25	49.06	49.11	4418063.0
2007-09-14 11:30:00	QQQ	ETF	49.11	49.26	49.07	49.2095	3814144.0
2007-09-14 12:00:00	QQQ	ETF	49.201	49.27	49.13	49.159	3189468.0
2007-09-14 12:30:00	QQQ	ETF	49.1599	49.18	49.08	49.112	2873451.0
2007-09-14 13:00:00	QQQ	ETF	49.11	49.26	49.07	49.24	4161481.0
2007-09-14 13:30:00	QQQ	ETF	49.24	49.28	49.15	49.28	4687412.0
2007-09-14 14:00:00	QQQ	ETF	49.28	49.31	49.2	49.23	3634892.0
2007-09-14 14:30:00	QQQ	ETF	49.23	49.26	49.11	49.15	3642052.0
2007-09-14 15:00:00	QQQ	ETF	49.14	49.21	49.11	49.18	3094226.0

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

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