PREVIEW / etf_30min / 2007-01-16

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-16.parquet
  size:    96 KB
  rows:    3,418

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-01-16 06:00:00	SPY	ETF	143.37	143.37	143.35	143.35	20000.0
2007-01-16 06:30:00	SPY	ETF	143.28	143.29	143.28	143.29	2500.0
2007-01-16 07:00:00	SPY	ETF	143.28	143.35	143.28	143.29	12200.0
2007-01-16 07:30:00	SPY	ETF	143.31	143.31	143.31	143.31	2500.0
2007-01-16 08:00:00	SPY	ETF	143.31	143.35	143.27	143.27	71900.0
2007-01-16 08:30:00	SPY	ETF	143.26	143.26	143.13	143.18	344400.0
2007-01-16 09:00:00	SPY	ETF	143.19	143.25	143.04	143.06	277800.0
2007-01-16 09:30:00	SPY	ETF	143.07	143.44	142.97	143.23	5770600.0
2007-01-16 10:00:00	SPY	ETF	143.22	143.23	142.85	143.01	4458700.0
2007-01-16 10:30:00	SPY	ETF	143.01	143.08	142.78	142.82	3382700.0
2007-01-16 11:00:00	SPY	ETF	142.8	143.01	142.8	142.89	4167600.0
2007-01-16 11:30:00	SPY	ETF	142.88	143.09	142.88	142.97	3989800.0
2007-01-16 12:00:00	SPY	ETF	142.97	143.06	142.95	143.05	1418200.0
2007-01-16 12:30:00	SPY	ETF	143.05	143.18	142.79	142.87	2676800.0
2007-01-16 13:00:00	SPY	ETF	142.87	142.93	142.78	142.86	1759400.0
2007-01-16 13:30:00	SPY	ETF	142.86	142.9	142.73	142.85	1759200.0
2007-01-16 14:00:00	SPY	ETF	142.86	143.01	142.8	142.89	1457100.0
2007-01-16 14:30:00	SPY	ETF	142.9	143.08	142.89	142.98	1923800.0
2007-01-16 15:00:00	SPY	ETF	142.99	143.05	142.9	142.97	3250300.0
2007-01-16 15:30:00	SPY	ETF	142.96	143.19	142.9	143.03	4139000.0
2007-01-16 16:00:00	SPY	ETF	143.03	143.07	142.95	142.96	881700.0
2007-01-16 16:30:00	SPY	ETF	142.96	142.96	142.86	142.91	97800.0
2007-01-16 17:00:00	SPY	ETF	142.9	142.91	142.89	142.9	155600.0
2007-01-16 17:30:00	SPY	ETF	142.89	142.9	142.89	142.89	1100.0
2007-01-16 18:00:00	SPY	ETF	142.9	142.9	142.83	142.85	116300.0
2007-01-16 18:30:00	SPY	ETF	142.89	142.89	142.85	142.85	300.0
2007-01-16 19:30:00	SPY	ETF	142.85	142.85	142.83	142.83	1600.0
2007-01-16 06:30:00	QQQ	ETF	45.43	45.43	45.43	45.43	27200.0
2007-01-16 07:00:00	QQQ	ETF	45.43	45.43	45.42	45.42	88300.0
2007-01-16 07:30:00	QQQ	ETF	45.43	45.47	45.43	45.43	332314.0
2007-01-16 08:00:00	QQQ	ETF	45.45	45.46	45.42	45.43	818997.0
2007-01-16 08:30:00	QQQ	ETF	45.42	45.42	45.33	45.37	596985.0
2007-01-16 09:00:00	QQQ	ETF	45.37	45.39	45.31	45.33	1759338.0
2007-01-16 09:30:00	QQQ	ETF	45.33	45.4	45.26	45.36	11142400.0
2007-01-16 10:00:00	QQQ	ETF	45.35	45.38	45.18	45.27	10470800.0
2007-01-16 10:30:00	QQQ	ETF	45.26	45.34	45.13	45.15	7099000.0
2007-01-16 11:00:00	QQQ	ETF	45.16	45.24	45.14	45.22	7036200.0
2007-01-16 11:30:00	QQQ	ETF	45.22	45.32	45.22	45.28	4538100.0
2007-01-16 12:00:00	QQQ	ETF	45.27	45.34	45.26	45.34	4674300.0
2007-01-16 12:30:00	QQQ	ETF	45.33	45.39	45.19	45.23	5999800.0
2007-01-16 13:00:00	QQQ	ETF	45.22	45.26	45.19	45.22	3236500.0
2007-01-16 13:30:00	QQQ	ETF	45.22	45.24	45.13	45.19	4333000.0
2007-01-16 14:00:00	QQQ	ETF	45.19	45.28	45.15	45.21	4488900.0
2007-01-16 14:30:00	QQQ	ETF	45.21	45.33	45.21	45.25	5533200.0
2007-01-16 15:00:00	QQQ	ETF	45.25	45.29	45.18	45.22	3437300.0
2007-01-16 15:30:00	QQQ	ETF	45.22	45.28	45.18	45.27	6166100.0
2007-01-16 16:00:00	QQQ	ETF	45.28	45.35	45.21	45.22	6186015.0
2007-01-16 16:30:00	QQQ	ETF	45.22	45.23	45.17	45.18	573761.0
2007-01-16 17:00:00	QQQ	ETF	45.18	45.18	45.13	45.13	541132.0
2007-01-16 17:30:00	QQQ	ETF	45.13	45.16	45.08	45.1	135720.0

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

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