PREVIEW / etf_30min / 2006-08-15

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-15.parquet
  size:    77 KB
  rows:    2,753

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-15 06:30:00	SPY	ETF	127.28	127.28	127.28	127.28	5000.0
2006-08-15 07:00:00	SPY	ETF	127.26	127.26	127.23	127.23	10400.0
2006-08-15 07:30:00	SPY	ETF	127.27	127.35	127.27	127.35	1200.0
2006-08-15 08:00:00	SPY	ETF	127.39	127.46	127.19	127.38	194800.0
2006-08-15 08:30:00	SPY	ETF	127.36	128.38	127.36	128.21	5677700.0
2006-08-15 09:00:00	SPY	ETF	128.21	128.3	128.18	128.22	1039900.0
2006-08-15 09:30:00	SPY	ETF	128.21	128.34	127.91	128.03	8687700.0
2006-08-15 10:00:00	SPY	ETF	128.03	128.22	127.9	128.07	4835100.0
2006-08-15 10:30:00	SPY	ETF	128.07	128.51	128.03	128.34	8714100.0
2006-08-15 11:00:00	SPY	ETF	128.34	128.51	128.32	128.379	5085700.0
2006-08-15 11:30:00	SPY	ETF	128.379	128.48	128.22	128.32	3092500.0
2006-08-15 12:00:00	SPY	ETF	128.32	128.47	128.27	128.35	1872200.0
2006-08-15 12:30:00	SPY	ETF	128.36	128.5	128.34	128.47	1829100.0
2006-08-15 13:00:00	SPY	ETF	128.47	128.47	128.14	128.25	3440000.0
2006-08-15 13:30:00	SPY	ETF	128.25	128.44	128.18	128.3	1445000.0
2006-08-15 14:00:00	SPY	ETF	128.3	128.57	128.18	128.47	3107300.0
2006-08-15 14:30:00	SPY	ETF	128.48	128.7	128.45	128.67	4669200.0
2006-08-15 15:00:00	SPY	ETF	128.67	128.79	128.58	128.75	4129700.0
2006-08-15 15:30:00	SPY	ETF	128.75	128.87	128.65	128.71	7047100.0
2006-08-15 16:00:00	SPY	ETF	128.71	128.7781	128.59	128.7	1480900.0
2006-08-15 16:30:00	SPY	ETF	128.7	128.7	128.6	128.62	181700.0
2006-08-15 17:00:00	SPY	ETF	128.63	128.65	128.63	128.65	5800.0
2006-08-15 17:30:00	SPY	ETF	128.65	128.65	128.65	128.65	500.0
2006-08-15 18:00:00	SPY	ETF	128.65	128.67	128.61	128.61	5300.0
2006-08-15 18:30:00	SPY	ETF	128.62	128.63	128.62	128.63	6000.0
2006-08-15 19:00:00	SPY	ETF	128.61	128.63	128.61	128.61	400.0
2006-08-15 19:30:00	SPY	ETF	128.6	128.6	128.58	128.59	10700.0
2006-08-15 09:30:00	QQQ	ETF	37.23	37.29	37.09	37.15	19964400.0
2006-08-15 10:00:00	QQQ	ETF	37.14	37.25	37.09	37.18	7987100.0
2006-08-15 10:30:00	QQQ	ETF	37.18	37.44	37.17	37.42	13180200.0
2006-08-15 11:00:00	QQQ	ETF	37.42	37.5	37.41	37.45	8672300.0
2006-08-15 11:30:00	QQQ	ETF	37.45	37.54	37.39	37.42	7823300.0
2006-08-15 12:00:00	QQQ	ETF	37.43	37.49	37.41	37.41	5046100.0
2006-08-15 12:30:00	QQQ	ETF	37.42	37.5	37.41	37.49	2655700.0
2006-08-15 13:00:00	QQQ	ETF	37.48	37.49	37.36	37.41	5701500.0
2006-08-15 13:30:00	QQQ	ETF	37.41	37.5	37.39	37.45	3763000.0
2006-08-15 14:00:00	QQQ	ETF	37.46	37.6	37.4	37.55	7988700.0
2006-08-15 14:30:00	QQQ	ETF	37.56	37.69	37.55	37.67	10218900.0
2006-08-15 15:00:00	QQQ	ETF	37.67	37.74	37.64	37.72	8273000.0
2006-08-15 15:30:00	QQQ	ETF	37.73	37.75	37.65	37.7	14697500.0
2006-08-15 07:30:00	IWM	ETF	68.1	68.1	68.1	68.1	100.0
2006-08-15 08:00:00	IWM	ETF	67.87	68.13	67.87	68.13	175000.0
2006-08-15 08:30:00	IWM	ETF	68.15	69.06	68.14	69.0	3229400.0
2006-08-15 09:00:00	IWM	ETF	69.02	69.13	68.97	69.01	1314700.0
2006-08-15 09:30:00	IWM	ETF	69.0	69.15	68.73	68.81	7555000.0
2006-08-15 10:00:00	IWM	ETF	68.81	68.98	68.69	68.76	3033200.0
2006-08-15 10:30:00	IWM	ETF	68.76	69.08	68.76	69.05	3700800.0
2006-08-15 11:00:00	IWM	ETF	69.06	69.2	69.04	69.13	3834300.0
2006-08-15 11:30:00	IWM	ETF	69.13	69.17	68.95	68.95	2336700.0
2006-08-15 12:00:00	IWM	ETF	68.96	69.08	68.93	69.0	2162600.0

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

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