PREVIEW / etf_30min / 2006-04-07

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-04-07.parquet
  size:    62 KB
  rows:    2,203

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-07 07:00:00	SPY	ETF	130.87	130.87	130.86	130.86	6000.0
2006-04-07 07:30:00	SPY	ETF	130.89	130.89	130.85	130.87	9500.0
2006-04-07 08:00:00	SPY	ETF	130.91	130.97	130.87	130.89	528500.0
2006-04-07 08:30:00	SPY	ETF	130.87	131.56	130.8	131.39	3624900.0
2006-04-07 09:00:00	SPY	ETF	131.4	131.46	130.94	131.07	1041900.0
2006-04-07 09:30:00	SPY	ETF	131.06	131.4	130.85	130.85	12250400.0
2006-04-07 10:00:00	SPY	ETF	130.85	130.95	130.3	130.38	8317200.0
2006-04-07 10:30:00	SPY	ETF	130.39	130.5	130.02	130.19	10325400.0
2006-04-07 11:00:00	SPY	ETF	130.19	130.41	130.07	130.13	3425100.0
2006-04-07 11:30:00	SPY	ETF	130.13	130.17	129.61	129.74	6280200.0
2006-04-07 12:00:00	SPY	ETF	129.73	129.94	129.57	129.87	3477200.0
2006-04-07 12:30:00	SPY	ETF	129.87	129.9	129.65	129.69	2953400.0
2006-04-07 13:00:00	SPY	ETF	129.69	129.92	129.54	129.81	3689100.0
2006-04-07 13:30:00	SPY	ETF	129.82	129.87	129.48	129.62	3977800.0
2006-04-07 14:00:00	SPY	ETF	129.62	130.4	129.58	129.7	2925700.0
2006-04-07 14:30:00	SPY	ETF	129.7	130.09	129.69	129.9	4098300.0
2006-04-07 15:00:00	SPY	ETF	129.91	129.982	129.47	129.49	4635700.0
2006-04-07 15:30:00	SPY	ETF	129.5	129.69	129.35	129.49	6170900.0
2006-04-07 16:00:00	SPY	ETF	129.47	129.59	129.47	129.55	834700.0
2006-04-07 16:30:00	SPY	ETF	129.57	129.58	129.54	129.54	2400.0
2006-04-07 17:00:00	SPY	ETF	129.57	129.665	129.51	129.56	4700.0
2006-04-07 17:30:00	SPY	ETF	129.55	129.55	129.49	129.49	12700.0
2006-04-07 18:00:00	SPY	ETF	129.5	129.5	129.49	129.49	2200.0
2006-04-07 18:30:00	SPY	ETF	129.49	129.49	129.49	129.49	500.0
2006-04-07 19:00:00	SPY	ETF	129.49	129.49	129.47	129.47	4700.0
2006-04-07 19:30:00	SPY	ETF	129.54	129.54	129.54	129.54	700.0
2006-04-07 09:30:00	QQQ	ETF	42.89	43.05	42.83	42.83	22395600.0
2006-04-07 10:00:00	QQQ	ETF	42.83	42.85	42.57	42.6	20070500.0
2006-04-07 10:30:00	QQQ	ETF	42.59	42.82	42.48	42.55	11035800.0
2006-04-07 11:00:00	QQQ	ETF	42.54	42.66	42.51	42.55	6281600.0
2006-04-07 11:30:00	QQQ	ETF	42.55	42.56	42.3	42.38	9782900.0
2006-04-07 12:00:00	QQQ	ETF	42.38	42.49	42.36	42.46	4511900.0
2006-04-07 12:30:00	QQQ	ETF	42.46	42.53	42.41	42.44	4418300.0
2006-04-07 13:00:00	QQQ	ETF	42.44	42.56	42.37	42.52	4701200.0
2006-04-07 13:30:00	QQQ	ETF	42.52	42.54	42.37	42.4	4968700.0
2006-04-07 14:00:00	QQQ	ETF	42.4	42.48	42.38	42.41	2349900.0
2006-04-07 14:30:00	QQQ	ETF	42.41	42.53	42.21	42.48	5058700.0
2006-04-07 15:00:00	QQQ	ETF	42.48	42.49	42.3	42.34	5070300.0
2006-04-07 15:30:00	QQQ	ETF	42.34	42.42	42.3	42.33	6767900.0
2006-04-07 08:00:00	IWM	ETF	76.28	76.3	76.21	76.21	8300.0
2006-04-07 08:30:00	IWM	ETF	76.28	76.98	76.25	76.63	476800.0
2006-04-07 09:00:00	IWM	ETF	76.63	76.63	76.34	76.38	861400.0
2006-04-07 09:30:00	IWM	ETF	76.37	76.69	76.24	76.24	4332500.0
2006-04-07 10:00:00	IWM	ETF	76.23	76.32	75.59	75.64	4485000.0
2006-04-07 10:30:00	IWM	ETF	75.64	75.77	75.41	75.5	3562900.0
2006-04-07 11:00:00	IWM	ETF	75.51	75.6	75.35	75.4	3040700.0
2006-04-07 11:30:00	IWM	ETF	75.4	76.1017	75.09	75.211	4136300.0
2006-04-07 12:00:00	IWM	ETF	75.21	75.23	75.06	75.22	3160000.0
2006-04-07 12:30:00	IWM	ETF	75.21	75.26	74.95	74.96	4118500.0
2006-04-07 13:00:00	IWM	ETF	74.95	76.1016	74.86	75.18	4816200.0

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

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