PREVIEW / etf_30min / 2007-03-02

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-02.parquet
  size:    108 KB
  rows:    3,640

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-03-02 04:30:00	SPY	ETF	140.67	140.67	140.55	140.55	29600.0
2007-03-02 05:00:00	SPY	ETF	140.79	140.83	140.74	140.83	29900.0
2007-03-02 05:30:00	SPY	ETF	140.68	140.68	140.65	140.65	14900.0
2007-03-02 06:00:00	SPY	ETF	140.63	140.63	140.53	140.58	26800.0
2007-03-02 06:30:00	SPY	ETF	140.65	140.65	140.09	140.16	36300.0
2007-03-02 07:00:00	SPY	ETF	140.16	140.17	139.8	140.02	683500.0
2007-03-02 07:30:00	SPY	ETF	140.09	140.41	140.07	140.17	831600.0
2007-03-02 08:00:00	SPY	ETF	140.16	140.4	139.48	139.67	7138200.0
2007-03-02 08:30:00	SPY	ETF	139.7	140.6	139.55	139.9	2039700.0
2007-03-02 09:00:00	SPY	ETF	139.87	140.15	139.87	140.04	1481600.0
2007-03-02 09:30:00	SPY	ETF	140.05	140.45	139.84	140.08	13674100.0
2007-03-02 10:00:00	SPY	ETF	140.07	140.48	139.84	140.08	9533900.0
2007-03-02 10:30:00	SPY	ETF	140.06	140.58	139.98	140.42	8823600.0
2007-03-02 11:00:00	SPY	ETF	140.42	140.66	140.23	140.42	5918000.0
2007-03-02 11:30:00	SPY	ETF	140.42	140.43	140.0	140.11	6280600.0
2007-03-02 12:00:00	SPY	ETF	140.11	140.26	139.67	139.67	11152700.0
2007-03-02 12:30:00	SPY	ETF	139.67	139.84	139.37	139.8	16386000.0
2007-03-02 13:00:00	SPY	ETF	139.8	139.84	139.01	139.2	10462100.0
2007-03-02 13:30:00	SPY	ETF	139.2	139.52	138.96	139.33	13935900.0
2007-03-02 14:00:00	SPY	ETF	139.33	139.35	138.9	139.16	6458700.0
2007-03-02 14:30:00	SPY	ETF	139.16	140.32	139.11	139.38	10244900.0
2007-03-02 15:00:00	SPY	ETF	139.38	139.72	139.36	139.58	6508000.0
2007-03-02 15:30:00	SPY	ETF	139.58	139.62	138.93	138.98	14700300.0
2007-03-02 16:00:00	SPY	ETF	138.97	140.606	138.66	138.75	4837000.0
2007-03-02 16:30:00	SPY	ETF	138.79	140.596	138.75	138.86	6573300.0
2007-03-02 17:00:00	SPY	ETF	138.86	138.91	138.86	138.86	76200.0
2007-03-02 17:30:00	SPY	ETF	138.87	138.88	138.85	138.85	176000.0
2007-03-02 18:00:00	SPY	ETF	138.85	138.95	138.85	138.95	17200.0
2007-03-02 18:30:00	SPY	ETF	138.95	138.95	138.86	138.9	6600.0
2007-03-02 19:00:00	SPY	ETF	138.9	138.9	138.87	138.9	1600.0
2007-03-02 19:30:00	SPY	ETF	138.9	138.95	138.87	138.87	7400.0
2007-03-02 20:00:00	SPY	ETF	138.87	138.87	138.87	138.87	100.0
2007-03-02 04:30:00	QQQ	ETF	43.02	43.02	43.02	43.02	200.0
2007-03-02 06:30:00	QQQ	ETF	43.01	43.01	42.93	42.93	12000.0
2007-03-02 07:00:00	QQQ	ETF	42.89	42.93	42.77	42.86	208157.0
2007-03-02 07:30:00	QQQ	ETF	42.92	42.96	42.84	42.86	197347.0
2007-03-02 08:00:00	QQQ	ETF	42.89	42.89	42.56	42.62	5189352.0
2007-03-02 08:30:00	QQQ	ETF	42.62	42.79	42.62	42.77	2462323.0
2007-03-02 09:00:00	QQQ	ETF	42.77	42.87	42.75	42.79	1655033.0
2007-03-02 09:30:00	QQQ	ETF	42.78	43.11	42.78	42.95	19283200.0
2007-03-02 10:00:00	QQQ	ETF	42.94	43.06	42.86	42.91	14472600.0
2007-03-02 10:30:00	QQQ	ETF	42.91	43.14	42.87	43.05	17865500.0
2007-03-02 11:00:00	QQQ	ETF	43.06	43.12	42.98	43.05	8504200.0
2007-03-02 11:30:00	QQQ	ETF	43.04	43.05	42.86	42.94	6506600.0
2007-03-02 12:00:00	QQQ	ETF	42.94	43.0	42.67	42.68	16531300.0
2007-03-02 12:30:00	QQQ	ETF	42.68	42.81	42.6	42.75	14757700.0
2007-03-02 13:00:00	QQQ	ETF	42.75	42.78	42.53	42.58	11052200.0
2007-03-02 13:30:00	QQQ	ETF	42.58	42.66	42.51	42.61	13600900.0
2007-03-02 14:00:00	QQQ	ETF	42.6	42.62	42.52	42.6	9538800.0
2007-03-02 14:30:00	QQQ	ETF	42.6	42.82	42.59	42.68	11349400.0

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

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