PREVIEW / etf_30min / 2007-12-31

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-31.parquet
  size:    143 KB
  rows:    5,319

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
2007-12-31 05:30:00	SPY	ETF	147.72	147.72	147.59	147.59	2100.0
2007-12-31 06:00:00	SPY	ETF	147.65	147.67	147.65	147.67	2000.0
2007-12-31 06:30:00	SPY	ETF	147.62	147.63	147.62	147.62	12000.0
2007-12-31 07:00:00	SPY	ETF	147.62	147.65	147.59	147.61	15500.0
2007-12-31 07:30:00	SPY	ETF	147.6	147.7	147.59	147.67	46500.0
2007-12-31 08:00:00	SPY	ETF	147.63	147.75	147.53	147.59	739200.0
2007-12-31 08:30:00	SPY	ETF	147.56	147.6	147.52	147.53	221900.0
2007-12-31 09:00:00	SPY	ETF	147.54	147.54	147.0	147.11	756700.0
2007-12-31 09:30:00	SPY	ETF	147.1	147.18	146.8	146.84	6773643.0
2007-12-31 10:00:00	SPY	ETF	146.84	147.17	146.82	146.95	5619970.0
2007-12-31 10:30:00	SPY	ETF	146.95	146.97	146.59	146.71	6303765.0
2007-12-31 11:00:00	SPY	ETF	146.71	146.74	146.25	146.37	10995078.0
2007-12-31 11:30:00	SPY	ETF	146.37	146.65	146.37	146.438	5307634.0
2007-12-31 12:00:00	SPY	ETF	146.44	146.66	146.34	146.37	4056605.0
2007-12-31 12:30:00	SPY	ETF	146.37	146.75	146.33	146.66	4337197.0
2007-12-31 13:00:00	SPY	ETF	146.65	147.13	146.61	146.97	5254590.0
2007-12-31 13:30:00	SPY	ETF	146.96	147.11	146.91	146.99	3668113.0
2007-12-31 14:00:00	SPY	ETF	146.99	147.2	146.85	146.9499	4030931.0
2007-12-31 14:30:00	SPY	ETF	146.95	147.25	146.91	147.16	3306403.0
2007-12-31 15:00:00	SPY	ETF	147.16	147.33	147.01	147.16	4617925.0
2007-12-31 15:30:00	SPY	ETF	147.15	147.21	146.36	146.42	16356985.0
2007-12-31 16:00:00	SPY	ETF	146.42	146.9484	146.06	146.23	7627600.0
2007-12-31 16:30:00	SPY	ETF	146.23	146.27	146.08	146.1	2127510.0
2007-12-31 17:00:00	SPY	ETF	146.1	146.21	146.09	146.1	1144100.0
2007-12-31 17:30:00	SPY	ETF	146.09	146.12	146.0	146.0	144600.0
2007-12-31 18:00:00	SPY	ETF	146.07	146.19	146.05	146.19	13900.0
2007-12-31 18:30:00	SPY	ETF	146.08	146.2	146.08	146.2	3900.0
2007-12-31 19:00:00	SPY	ETF	146.18	146.18	146.18	146.18	300.0
2007-12-31 19:30:00	SPY	ETF	146.17	146.22	146.16	146.22	5500.0
2007-12-31 07:00:00	QQQ	ETF	51.76	51.76	51.7	51.7	58600.0
2007-12-31 07:30:00	QQQ	ETF	51.72	51.76	51.7	51.74	62000.0
2007-12-31 08:00:00	QQQ	ETF	51.76	51.77	51.67	51.68	1263243.0
2007-12-31 08:30:00	QQQ	ETF	51.69	51.71	51.66	51.69	127913.0
2007-12-31 09:00:00	QQQ	ETF	51.68	51.68	51.51	51.57	885941.0
2007-12-31 09:30:00	QQQ	ETF	51.56	51.64	51.4	51.5299	7984153.0
2007-12-31 10:00:00	QQQ	ETF	51.53	51.68	51.5	51.52	4398450.0
2007-12-31 10:30:00	QQQ	ETF	51.52	51.54	51.4	51.43	4601131.0
2007-12-31 11:00:00	QQQ	ETF	51.43	51.45	51.3	51.39	6182061.0
2007-12-31 11:30:00	QQQ	ETF	51.4	51.46	51.35	51.3601	3350755.0
2007-12-31 12:00:00	QQQ	ETF	51.36	51.43	51.27	51.28	4440547.0
2007-12-31 12:30:00	QQQ	ETF	51.29	51.4	51.28	51.3601	3518442.0
2007-12-31 13:00:00	QQQ	ETF	51.36	51.5	51.34	51.44	5089579.0
2007-12-31 13:30:00	QQQ	ETF	51.4399	51.47	51.39	51.405	2329257.0
2007-12-31 14:00:00	QQQ	ETF	51.401	51.48	51.35	51.37	3096527.0
2007-12-31 14:30:00	QQQ	ETF	51.37	51.55	51.37	51.52	4071434.0
2007-12-31 15:00:00	QQQ	ETF	51.51	51.65	51.47	51.6	4416741.0
2007-12-31 15:30:00	QQQ	ETF	51.6	51.61	51.21	51.22	9458838.0
2007-12-31 16:00:00	QQQ	ETF	51.24	51.31	51.17	51.31	3486908.0
2007-12-31 16:30:00	QQQ	ETF	51.25	51.7896	51.19	51.19	1421762.0
2007-12-31 17:00:00	QQQ	ETF	51.19	51.24	51.19	51.21	11050.0

> showing 50 of 5,319 rows — these rows as CSV

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