PREVIEW / etf_30min / 2006-08-18

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-18.parquet
  size:    76 KB
  rows:    2,685

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-08-18 06:30:00	SPY	ETF	129.81	129.81	129.81	129.81	25000.0
2006-08-18 07:00:00	SPY	ETF	129.92	129.93	129.92	129.93	49800.0
2006-08-18 07:30:00	SPY	ETF	129.93	129.96	129.88	129.88	13100.0
2006-08-18 08:00:00	SPY	ETF	129.85	129.96	129.85	129.88	180600.0
2006-08-18 08:30:00	SPY	ETF	129.88	130.0	129.86	130.0	125200.0
2006-08-18 09:00:00	SPY	ETF	130.0	130.2	129.85	130.19	794700.0
2006-08-18 09:30:00	SPY	ETF	130.19	130.22	129.68	129.74	10921400.0
2006-08-18 10:00:00	SPY	ETF	129.74	129.86	129.61	129.7	7204800.0
2006-08-18 10:30:00	SPY	ETF	129.7	129.95	129.59	129.8	5479200.0
2006-08-18 11:00:00	SPY	ETF	129.8	130.03	129.8	129.86	2343000.0
2006-08-18 11:30:00	SPY	ETF	129.86	129.95	129.71	129.91	1996800.0
2006-08-18 12:00:00	SPY	ETF	129.93	130.09	129.85	130.03	2800100.0
2006-08-18 12:30:00	SPY	ETF	130.02	130.08	129.96	130.04	1412800.0
2006-08-18 13:00:00	SPY	ETF	130.05	130.29	130.02	130.06	3328500.0
2006-08-18 13:30:00	SPY	ETF	130.05	130.29	130.05	130.1	2946900.0
2006-08-18 14:00:00	SPY	ETF	130.11	130.27	130.08	130.25	1906000.0
2006-08-18 14:30:00	SPY	ETF	130.25	130.36	130.2	130.2	3548100.0
2006-08-18 15:00:00	SPY	ETF	130.21	130.39	130.13	130.39	3609300.0
2006-08-18 15:30:00	SPY	ETF	130.39	130.48	130.33	130.46	4813200.0
2006-08-18 16:00:00	SPY	ETF	130.46	130.68	130.44	130.66	1737300.0
2006-08-18 16:30:00	SPY	ETF	130.65	130.67	130.6	130.62	197600.0
2006-08-18 17:00:00	SPY	ETF	130.61	130.61	130.51	130.57	182000.0
2006-08-18 17:30:00	SPY	ETF	130.57	130.57	130.57	130.57	500.0
2006-08-18 18:30:00	SPY	ETF	130.56	130.56	130.56	130.56	100.0
2006-08-18 19:00:00	SPY	ETF	130.63	130.64	130.63	130.64	1000.0
2006-08-18 19:30:00	SPY	ETF	130.65	130.65	130.65	130.65	500.0
2006-08-18 09:30:00	QQQ	ETF	38.65	38.67	38.28	38.33	19865400.0
2006-08-18 10:00:00	QQQ	ETF	38.33	38.45	38.32	38.39	15147900.0
2006-08-18 10:30:00	QQQ	ETF	38.39	38.87	38.38	38.45	7499600.0
2006-08-18 11:00:00	QQQ	ETF	38.45	38.55	38.45	38.48	3601100.0
2006-08-18 11:30:00	QQQ	ETF	38.48	38.53	38.43	38.51	4416700.0
2006-08-18 12:00:00	QQQ	ETF	38.51	38.59	38.47	38.57	3031800.0
2006-08-18 12:30:00	QQQ	ETF	38.58	38.6	38.51	38.56	2885300.0
2006-08-18 13:00:00	QQQ	ETF	38.56	38.67	38.54	38.58	3444700.0
2006-08-18 13:30:00	QQQ	ETF	38.59	38.68	38.56	38.56	3504300.0
2006-08-18 14:00:00	QQQ	ETF	38.56	38.65	38.55	38.62	3792100.0
2006-08-18 14:30:00	QQQ	ETF	38.64	38.72	38.64	38.65	4129900.0
2006-08-18 15:00:00	QQQ	ETF	38.65	38.8	38.65	38.8	5807300.0
2006-08-18 15:30:00	QQQ	ETF	38.8	38.83	38.63	38.79	9670500.0
2006-08-18 07:30:00	IWM	ETF	70.6	70.6	70.6	70.6	500.0
2006-08-18 08:00:00	IWM	ETF	70.5	70.55	70.5	70.55	5400.0
2006-08-18 08:30:00	IWM	ETF	70.56	70.63	70.56	70.58	80900.0
2006-08-18 09:00:00	IWM	ETF	70.66	70.82	70.63	70.81	354600.0
2006-08-18 09:30:00	IWM	ETF	70.8	70.92	70.04	70.05	6611100.0
2006-08-18 10:00:00	IWM	ETF	70.07	70.18	70.01	70.04	5434000.0
2006-08-18 10:30:00	IWM	ETF	70.05	70.3	70.03	70.19	2632500.0
2006-08-18 11:00:00	IWM	ETF	70.19	70.4	70.19	70.3	3281600.0
2006-08-18 11:30:00	IWM	ETF	70.31	70.42	70.22	70.39	1749600.0
2006-08-18 12:00:00	IWM	ETF	70.39	70.46	70.34	70.45	2564400.0
2006-08-18 12:30:00	IWM	ETF	70.45	70.5	70.34	70.38	757000.0

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

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