PREVIEW / etf_30min / 2006-10-31

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-10-31.parquet
  size:    85 KB
  rows:    2,992

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-10-31 04:00:00	SPY	ETF	137.9	138.0	137.9	138.0	900.0
2006-10-31 05:00:00	SPY	ETF	138.12	138.12	138.12	138.12	3000.0
2006-10-31 06:00:00	SPY	ETF	138.08	138.08	138.04	138.04	90000.0
2006-10-31 07:00:00	SPY	ETF	138.04	138.07	137.93	137.99	155200.0
2006-10-31 07:30:00	SPY	ETF	137.99	138.09	137.94	138.09	160900.0
2006-10-31 08:00:00	SPY	ETF	138.04	138.15	137.93	138.14	2053400.0
2006-10-31 08:30:00	SPY	ETF	138.14	138.14	138.07	138.11	268000.0
2006-10-31 09:00:00	SPY	ETF	138.08	138.12	138.02	138.08	131600.0
2006-10-31 09:30:00	SPY	ETF	138.07	138.26	137.84	137.96	6279500.0
2006-10-31 10:00:00	SPY	ETF	137.95	137.98	137.59	137.74	5321100.0
2006-10-31 10:30:00	SPY	ETF	137.74	138.08	137.73	138.06	4083700.0
2006-10-31 11:00:00	SPY	ETF	138.06	138.09	137.86	137.98	1894100.0
2006-10-31 11:30:00	SPY	ETF	137.98	138.01	137.61	137.67	4161000.0
2006-10-31 12:00:00	SPY	ETF	137.66	137.76	137.45	137.57	6616700.0
2006-10-31 12:30:00	SPY	ETF	137.57	137.6	137.32	137.35	3203400.0
2006-10-31 13:00:00	SPY	ETF	137.33	137.45	137.25	137.39	3051500.0
2006-10-31 13:30:00	SPY	ETF	137.38	137.64	137.38	137.55	2946200.0
2006-10-31 14:00:00	SPY	ETF	137.55	137.64	137.37	137.41	2961000.0
2006-10-31 14:30:00	SPY	ETF	137.4	137.68	137.38	137.58	3784000.0
2006-10-31 15:00:00	SPY	ETF	137.57	137.85	137.47	137.8	6633800.0
2006-10-31 15:30:00	SPY	ETF	137.8	138.06	137.68	137.78	9354100.0
2006-10-31 16:00:00	SPY	ETF	137.76	137.91	137.62	137.75	2065600.0
2006-10-31 16:30:00	SPY	ETF	137.81	138.0	137.77	137.79	234200.0
2006-10-31 17:00:00	SPY	ETF	137.81	137.81	137.81	137.81	6400.0
2006-10-31 17:30:00	SPY	ETF	137.82	137.82	137.8	137.8	8200.0
2006-10-31 18:00:00	SPY	ETF	137.81	137.86	137.81	137.86	16500.0
2006-10-31 19:30:00	SPY	ETF	137.87	137.9	137.87	137.9	1200.0
2006-10-31 09:30:00	QQQ	ETF	42.56	42.73	42.56	42.66	19477600.0
2006-10-31 10:00:00	QQQ	ETF	42.65	42.66	42.44	42.53	20746000.0
2006-10-31 10:30:00	QQQ	ETF	42.52	42.75	42.52	42.72	15036800.0
2006-10-31 11:00:00	QQQ	ETF	42.72	42.76	42.61	42.67	7891400.0
2006-10-31 11:30:00	QQQ	ETF	42.66	42.69	42.52	42.55	5315000.0
2006-10-31 12:00:00	QQQ	ETF	42.54	42.6	42.48	42.53	5260900.0
2006-10-31 12:30:00	QQQ	ETF	42.52	42.53	42.31	42.36	10202000.0
2006-10-31 13:00:00	QQQ	ETF	42.35	42.41	42.32	42.36	5744700.0
2006-10-31 13:30:00	QQQ	ETF	42.36	42.5	42.35	42.45	7473500.0
2006-10-31 14:00:00	QQQ	ETF	42.45	42.48	42.34	42.36	4844400.0
2006-10-31 14:30:00	QQQ	ETF	42.36	42.49	42.36	42.45	5410400.0
2006-10-31 15:00:00	QQQ	ETF	42.44	42.59	42.41	42.57	7967900.0
2006-10-31 15:30:00	QQQ	ETF	42.57	42.68	42.51	42.56	13111100.0
2006-10-31 07:30:00	IWM	ETF	76.65	76.65	76.65	76.65	4000.0
2006-10-31 08:00:00	IWM	ETF	76.64	76.72	76.55	76.66	1074900.0
2006-10-31 08:30:00	IWM	ETF	76.66	76.69	76.6	76.69	50300.0
2006-10-31 09:00:00	IWM	ETF	76.68	76.69	76.58	76.58	505700.0
2006-10-31 09:30:00	IWM	ETF	76.6	76.79	76.44	76.55	5251500.0
2006-10-31 10:00:00	IWM	ETF	76.55	76.58	76.22	76.35	4231800.0
2006-10-31 10:30:00	IWM	ETF	76.35	76.62	76.35	76.59	3411200.0
2006-10-31 11:00:00	IWM	ETF	76.6	76.63	76.44	76.52	1806900.0
2006-10-31 11:30:00	IWM	ETF	76.52	76.55	76.18	76.26	1706300.0
2006-10-31 12:00:00	IWM	ETF	76.26	76.32	76.06	76.14	1740000.0

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

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