PREVIEW / etf_30min / 2007-03-09

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-09.parquet
  size:    104 KB
  rows:    3,646

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-09 06:00:00	SPY	ETF	140.63	140.63	140.63	140.63	7500.0
2007-03-09 06:30:00	SPY	ETF	140.58	140.58	140.58	140.58	900.0
2007-03-09 07:00:00	SPY	ETF	140.57	140.64	140.54	140.61	84700.0
2007-03-09 07:30:00	SPY	ETF	140.52	140.59	140.45	140.59	52700.0
2007-03-09 08:00:00	SPY	ETF	140.56	140.63	140.4	140.61	704800.0
2007-03-09 08:30:00	SPY	ETF	140.66	141.64	140.45	141.48	12412600.0
2007-03-09 09:00:00	SPY	ETF	141.51	141.6	140.72	141.32	2053900.0
2007-03-09 09:30:00	SPY	ETF	141.31	141.42	140.76	140.88	13209700.0
2007-03-09 10:00:00	SPY	ETF	140.88	141.35	140.26	140.68	13666900.0
2007-03-09 10:30:00	SPY	ETF	140.67	140.91	140.56	140.78	6567900.0
2007-03-09 11:00:00	SPY	ETF	140.78	140.86	140.6299	140.78	4897600.0
2007-03-09 11:30:00	SPY	ETF	140.78	141.2	140.75	140.83	4153700.0
2007-03-09 12:00:00	SPY	ETF	140.83	141.05	140.82	141.0	3163500.0
2007-03-09 12:30:00	SPY	ETF	140.99	141.02	140.61	140.67	2941000.0
2007-03-09 13:00:00	SPY	ETF	140.67	140.84	140.53	140.71	5092400.0
2007-03-09 13:30:00	SPY	ETF	140.71	140.8	140.32	140.34	5906400.0
2007-03-09 14:00:00	SPY	ETF	140.35	140.5	140.12	140.27	8124100.0
2007-03-09 14:30:00	SPY	ETF	140.27	140.6	140.08	140.45	6103300.0
2007-03-09 15:00:00	SPY	ETF	140.45	140.62	140.35	140.58	6849400.0
2007-03-09 15:30:00	SPY	ETF	140.58	140.88	140.51	140.63	8507500.0
2007-03-09 16:00:00	SPY	ETF	140.62	140.79	140.56	140.6	948000.0
2007-03-09 16:30:00	SPY	ETF	140.69	140.77	140.69	140.77	14600.0
2007-03-09 17:00:00	SPY	ETF	140.77	140.78	140.69	140.72	152100.0
2007-03-09 17:30:00	SPY	ETF	140.72	140.75	140.72	140.75	43000.0
2007-03-09 18:00:00	SPY	ETF	140.72	140.72	140.71	140.71	1000.0
2007-03-09 18:30:00	SPY	ETF	140.72	140.72	140.72	140.72	500.0
2007-03-09 19:00:00	SPY	ETF	140.7	140.7	140.69	140.69	2700.0
2007-03-09 19:30:00	SPY	ETF	140.7	140.7	140.61	140.61	4000.0
2007-03-09 06:30:00	QQQ	ETF	43.06	43.06	43.06	43.06	1000.0
2007-03-09 07:00:00	QQQ	ETF	43.06	43.09	43.02	43.09	44700.0
2007-03-09 07:30:00	QQQ	ETF	43.07	43.07	43.02	43.07	115540.0
2007-03-09 08:00:00	QQQ	ETF	43.07	43.13	43.02	43.09	880856.0
2007-03-09 08:30:00	QQQ	ETF	43.09	43.45	43.08	43.38	7249322.0
2007-03-09 09:00:00	QQQ	ETF	43.37	43.42	43.3	43.33	1374394.0
2007-03-09 09:30:00	QQQ	ETF	43.33	43.34	43.04	43.05	18993400.0
2007-03-09 10:00:00	QQQ	ETF	43.05	43.09	42.88	43.03	18523100.0
2007-03-09 10:30:00	QQQ	ETF	43.03	43.14	42.96	43.08	12029600.0
2007-03-09 11:00:00	QQQ	ETF	43.08	43.11	43.01	43.06	6328100.0
2007-03-09 11:30:00	QQQ	ETF	43.06	43.13	43.02	43.02	4733200.0
2007-03-09 12:00:00	QQQ	ETF	43.02	43.11	43.02	43.09	3447500.0
2007-03-09 12:30:00	QQQ	ETF	43.09	43.1	42.94	42.98	4445400.0
2007-03-09 13:00:00	QQQ	ETF	42.98	43.02	42.9	42.97	4969200.0
2007-03-09 13:30:00	QQQ	ETF	42.97	42.99	42.77	42.78	6068600.0
2007-03-09 14:00:00	QQQ	ETF	42.78	42.81	42.65	42.75	10913000.0
2007-03-09 14:30:00	QQQ	ETF	42.75	42.9	42.69	42.89	8155600.0
2007-03-09 15:00:00	QQQ	ETF	42.9	42.94	42.86	42.92	3993600.0
2007-03-09 15:30:00	QQQ	ETF	42.93	43.02	42.88	42.92	11614600.0
2007-03-09 16:00:00	QQQ	ETF	42.93	43.0	42.91	42.94	2598778.0
2007-03-09 16:30:00	QQQ	ETF	42.96	42.96	42.94	42.94	31750.0
2007-03-09 17:00:00	QQQ	ETF	42.94	42.95	42.94	42.95	1472495.0

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

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