PREVIEW / etf_30min / 2006-04-17

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-04-17.parquet
  size:    63 KB
  rows:    2,224

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
2006-04-17 06:00:00	SPY	ETF	128.98	128.98	128.96	128.98	2000.0
2006-04-17 06:30:00	SPY	ETF	128.98	128.98	128.98	128.98	500.0
2006-04-17 07:30:00	SPY	ETF	128.83	128.83	128.75	128.75	50100.0
2006-04-17 08:00:00	SPY	ETF	128.81	128.98	128.74	128.94	100800.0
2006-04-17 08:30:00	SPY	ETF	128.9	128.97	128.71	128.93	135700.0
2006-04-17 09:00:00	SPY	ETF	128.94	128.97	128.81	128.81	244900.0
2006-04-17 09:30:00	SPY	ETF	128.79	129.16	128.79	129.0	4635600.0
2006-04-17 10:00:00	SPY	ETF	129.01	129.25	129.0	129.13	6286800.0
2006-04-17 10:30:00	SPY	ETF	129.14	129.18	128.99	129.07	2025400.0
2006-04-17 11:00:00	SPY	ETF	129.08	129.15	128.9	129.042	3166500.0
2006-04-17 11:30:00	SPY	ETF	129.04	129.12	129.02	129.07	758200.0
2006-04-17 12:00:00	SPY	ETF	129.07	129.09	128.81	128.82	4177100.0
2006-04-17 12:30:00	SPY	ETF	128.82	128.88	128.53	128.64	5520100.0
2006-04-17 13:00:00	SPY	ETF	128.64	128.69	128.44	128.57	3993600.0
2006-04-17 13:30:00	SPY	ETF	128.57	128.64	128.12	128.24	7908700.0
2006-04-17 14:00:00	SPY	ETF	128.24	128.28	128.02	128.18	6768500.0
2006-04-17 14:30:00	SPY	ETF	128.16	129.31	128.13	128.14	5687600.0
2006-04-17 15:00:00	SPY	ETF	128.14	128.46	128.14	128.37	3740200.0
2006-04-17 15:30:00	SPY	ETF	128.37	128.55	128.35	128.52	4326000.0
2006-04-17 16:00:00	SPY	ETF	128.51	128.69	128.5	128.67	387600.0
2006-04-17 16:30:00	SPY	ETF	128.65	129.06	128.56	128.65	312100.0
2006-04-17 17:00:00	SPY	ETF	128.64	128.7	128.58	128.62	8700.0
2006-04-17 17:30:00	SPY	ETF	128.6	128.6	128.6	128.6	1000.0
2006-04-17 18:00:00	SPY	ETF	128.65	128.65	128.64	128.64	1900.0
2006-04-17 18:30:00	SPY	ETF	128.65	128.65	128.65	128.65	200.0
2006-04-17 19:00:00	SPY	ETF	128.65	128.66	128.65	128.66	2400.0
2006-04-17 19:30:00	SPY	ETF	128.64	128.64	128.63	128.63	200.0
2006-04-17 09:30:00	QQQ	ETF	42.04	42.15	42.04	42.1	6266300.0
2006-04-17 10:00:00	QQQ	ETF	42.08	42.21	42.08	42.16	5743100.0
2006-04-17 10:30:00	QQQ	ETF	42.16	42.18	42.09	42.14	4184300.0
2006-04-17 11:00:00	QQQ	ETF	42.14	42.15	42.0	42.04	4134600.0
2006-04-17 11:30:00	QQQ	ETF	42.04	42.1	42.04	42.08	2618100.0
2006-04-17 12:00:00	QQQ	ETF	42.08	42.09	41.95	41.96	3583600.0
2006-04-17 12:30:00	QQQ	ETF	41.95	41.96	41.8	41.84	6510100.0
2006-04-17 13:00:00	QQQ	ETF	41.84	41.85	41.67	41.72	6610200.0
2006-04-17 13:30:00	QQQ	ETF	41.72	41.73	41.39	41.46	24034800.0
2006-04-17 14:00:00	QQQ	ETF	41.46	41.51	41.44	41.49	8934600.0
2006-04-17 14:30:00	QQQ	ETF	41.49	41.56	41.47	41.48	4567300.0
2006-04-17 15:00:00	QQQ	ETF	41.48	41.61	41.47	41.59	4199700.0
2006-04-17 15:30:00	QQQ	ETF	41.59	41.68	41.58	41.66	9706600.0
2006-04-17 08:00:00	IWM	ETF	74.66	74.71	74.66	74.7	34300.0
2006-04-17 08:30:00	IWM	ETF	74.24	74.61	74.24	74.61	605000.0
2006-04-17 09:00:00	IWM	ETF	74.62	74.65	74.6	74.62	540500.0
2006-04-17 09:30:00	IWM	ETF	74.63	74.85	74.55	74.65	3152200.0
2006-04-17 10:00:00	IWM	ETF	74.65	74.93	74.49	74.8	1436000.0
2006-04-17 10:30:00	IWM	ETF	74.79	74.84	74.68	74.8	1336100.0
2006-04-17 11:00:00	IWM	ETF	74.82	74.89	74.62	74.711	1212100.0
2006-04-17 11:30:00	IWM	ETF	74.71	74.83	74.71	74.75	539000.0
2006-04-17 12:00:00	IWM	ETF	74.74	74.79	74.63	74.6401	1154700.0
2006-04-17 12:30:00	IWM	ETF	74.64	74.64	74.34	74.39	3462700.0

> showing 50 of 2,224 rows — these rows as CSV

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