PREVIEW / etf_30min / 2006-05-01

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-05-01.parquet
  size:    62 KB
  rows:    2,237

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-05-01 06:30:00	SPY	ETF	131.36	131.36	131.36	131.36	5000.0
2006-05-01 07:00:00	SPY	ETF	131.36	131.39	131.36	131.39	4200.0
2006-05-01 07:30:00	SPY	ETF	131.37	131.37	131.37	131.37	1000.0
2006-05-01 08:00:00	SPY	ETF	131.38	131.47	131.31	131.32	612500.0
2006-05-01 08:30:00	SPY	ETF	131.33	131.37	131.27	131.35	417200.0
2006-05-01 09:00:00	SPY	ETF	131.36	131.46	131.32	131.43	228900.0
2006-05-01 09:30:00	SPY	ETF	131.47	131.78	131.45	131.62	5793600.0
2006-05-01 10:00:00	SPY	ETF	131.61	131.8	131.38	131.44	7091900.0
2006-05-01 10:30:00	SPY	ETF	131.44	131.49	131.24	131.43	4509800.0
2006-05-01 11:00:00	SPY	ETF	131.4	131.53	131.22	131.38	2236100.0
2006-05-01 11:30:00	SPY	ETF	131.37	131.53	131.29	131.37	1980700.0
2006-05-01 12:00:00	SPY	ETF	131.37	131.46	131.23	131.27	2450300.0
2006-05-01 12:30:00	SPY	ETF	131.28	131.44	131.18	131.4	2403000.0
2006-05-01 13:00:00	SPY	ETF	131.39	131.48	131.32	131.42	1874500.0
2006-05-01 13:30:00	SPY	ETF	131.42	131.55	131.39	131.49	1925300.0
2006-05-01 14:00:00	SPY	ETF	131.49	131.52	131.38	131.45	1365500.0
2006-05-01 14:30:00	SPY	ETF	131.46	131.52	131.42	131.49	3480900.0
2006-05-01 15:00:00	SPY	ETF	131.48	131.57	130.7	130.92	10747300.0
2006-05-01 15:30:00	SPY	ETF	130.92	131.23	130.32	130.57	13657800.0
2006-05-01 16:00:00	SPY	ETF	130.54	130.637	130.3	130.41	1104700.0
2006-05-01 16:30:00	SPY	ETF	130.42	130.53	130.39	130.51	246900.0
2006-05-01 17:00:00	SPY	ETF	130.5	130.5	130.48	130.5	16400.0
2006-05-01 17:30:00	SPY	ETF	130.5	130.55	130.5	130.55	6300.0
2006-05-01 18:00:00	SPY	ETF	130.5	130.55	130.0	130.0	16300.0
2006-05-01 18:30:00	SPY	ETF	130.54	130.54	130.54	130.54	100.0
2006-05-01 19:00:00	SPY	ETF	130.52	130.56	130.5	130.56	12500.0
2006-05-01 19:30:00	SPY	ETF	130.55	130.55	130.51	130.51	1900.0
2006-05-01 09:30:00	QQQ	ETF	41.93	42.05	41.91	41.96	8636700.0
2006-05-01 10:00:00	QQQ	ETF	41.96	42.0	41.87	41.9	5589800.0
2006-05-01 10:30:00	QQQ	ETF	41.89	41.97	41.83	41.94	3696400.0
2006-05-01 11:00:00	QQQ	ETF	41.94	41.98	41.83	41.92	2698500.0
2006-05-01 11:30:00	QQQ	ETF	41.92	41.97	41.89	41.92	1472100.0
2006-05-01 12:00:00	QQQ	ETF	41.92	41.93	41.8	41.82	4515300.0
2006-05-01 12:30:00	QQQ	ETF	41.83	41.88	41.78	41.86	3089000.0
2006-05-01 13:00:00	QQQ	ETF	41.86	41.9	41.84	41.89	1588700.0
2006-05-01 13:30:00	QQQ	ETF	41.89	41.91	41.84	41.88	1553900.0
2006-05-01 14:00:00	QQQ	ETF	41.87	41.89	41.82	41.84	1073700.0
2006-05-01 14:30:00	QQQ	ETF	41.84	41.89	41.83	41.86	1346900.0
2006-05-01 15:00:00	QQQ	ETF	41.86	42.3	41.6	41.64	12644600.0
2006-05-01 15:30:00	QQQ	ETF	41.64	41.65	41.31	41.43	35346100.0
2006-05-01 06:30:00	IWM	ETF	75.18	75.18	75.18	75.18	100.0
2006-05-01 07:30:00	IWM	ETF	76.09	76.1	76.09	76.1	1200.0
2006-05-01 08:00:00	IWM	ETF	76.1	76.2	76.09	76.17	55000.0
2006-05-01 08:30:00	IWM	ETF	76.17	76.17	76.1	76.16	48300.0
2006-05-01 09:00:00	IWM	ETF	76.16	76.31	76.16	76.29	36800.0
2006-05-01 09:30:00	IWM	ETF	76.29	76.64	76.26	76.4	3134400.0
2006-05-01 10:00:00	IWM	ETF	76.41	76.54	76.1	76.17	3784100.0
2006-05-01 10:30:00	IWM	ETF	76.17	76.28	75.98	76.1	3421300.0
2006-05-01 11:00:00	IWM	ETF	76.1	76.16	75.87	76.0	3905900.0
2006-05-01 11:30:00	IWM	ETF	76.0	76.14	75.9	76.02	1456300.0

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

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