PREVIEW / etf_30min / 2007-06-28

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-28.parquet
  size:    114 KB
  rows:    4,306

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-06-28 06:00:00	SPY	ETF	150.58	150.6	150.54	150.54	17500.0
2007-06-28 06:30:00	SPY	ETF	150.48	150.48	150.48	150.48	10000.0
2007-06-28 07:00:00	SPY	ETF	150.57	150.57	150.3	150.3	10800.0
2007-06-28 07:30:00	SPY	ETF	150.29	150.4	150.21	150.38	323400.0
2007-06-28 08:00:00	SPY	ETF	150.5	150.58	150.29	150.53	2452600.0
2007-06-28 08:30:00	SPY	ETF	150.49	150.49	150.19	150.24	1439300.0
2007-06-28 09:00:00	SPY	ETF	150.25	150.44	150.22	150.38	1650000.0
2007-06-28 09:30:00	SPY	ETF	150.38	150.58	150.31	150.54	11210601.0
2007-06-28 10:00:00	SPY	ETF	150.53	150.75	150.35	150.5	8744623.0
2007-06-28 10:30:00	SPY	ETF	150.5	150.57	150.36	150.45	8535223.0
2007-06-28 11:00:00	SPY	ETF	150.45	150.56	150.34	150.48	7534388.0
2007-06-28 11:30:00	SPY	ETF	150.49	150.84	150.46	150.8	7585890.0
2007-06-28 12:00:00	SPY	ETF	150.81	150.94	150.78	150.82	4904450.0
2007-06-28 12:30:00	SPY	ETF	150.83	151.11	150.82	150.9	2582600.0
2007-06-28 13:00:00	SPY	ETF	150.91	150.91	150.74	150.9	2996141.0
2007-06-28 13:30:00	SPY	ETF	150.9	151.18	149.67	151.05	7036802.0
2007-06-28 14:00:00	SPY	ETF	151.04	151.41	150.44	150.96	29306286.0
2007-06-28 14:30:00	SPY	ETF	150.97	151.22	150.32	150.89	25818933.0
2007-06-28 15:00:00	SPY	ETF	150.89	151.03	150.54	150.89	9978514.0
2007-06-28 15:30:00	SPY	ETF	150.89	151.11	150.4	150.4	16421057.0
2007-06-28 16:00:00	SPY	ETF	150.43	150.59	150.31	150.37	4371900.0
2007-06-28 16:30:00	SPY	ETF	150.39	150.46	150.37	150.45	151100.0
2007-06-28 17:00:00	SPY	ETF	150.41	150.42	150.38	150.42	5200.0
2007-06-28 17:30:00	SPY	ETF	150.39	150.42	150.39	150.42	300.0
2007-06-28 18:00:00	SPY	ETF	150.41	150.41	150.37	150.37	591200.0
2007-06-28 18:30:00	SPY	ETF	150.4	150.4	150.4	150.4	700.0
2007-06-28 19:00:00	SPY	ETF	150.39	150.4	150.39	150.4	900.0
2007-06-28 19:30:00	SPY	ETF	150.39	150.4	150.38	150.38	2400.0
2007-06-28 04:00:00	QQQ	ETF	47.57	47.57	47.57	47.57	49950.0
2007-06-28 04:30:00	QQQ	ETF	47.54	47.61	47.54	47.61	3100.0
2007-06-28 05:00:00	QQQ	ETF	47.63	47.63	47.63	47.63	100.0
2007-06-28 06:30:00	QQQ	ETF	47.56	47.56	47.56	47.56	500.0
2007-06-28 07:00:00	QQQ	ETF	47.6	47.6	47.47	47.48	35648.0
2007-06-28 07:30:00	QQQ	ETF	47.49	47.52	47.47	47.52	158648.0
2007-06-28 08:00:00	QQQ	ETF	47.51	47.63	47.51	47.59	1155557.0
2007-06-28 08:30:00	QQQ	ETF	47.57	47.59	47.51	47.52	1574324.0
2007-06-28 09:00:00	QQQ	ETF	47.52	47.55	47.46	47.51	1957478.0
2007-06-28 09:30:00	QQQ	ETF	47.52	47.6	47.47	47.5901	12513290.0
2007-06-28 10:00:00	QQQ	ETF	47.61	47.67	47.56	47.61	11464215.0
2007-06-28 10:30:00	QQQ	ETF	47.61	47.63	47.56	47.58	5103998.0
2007-06-28 11:00:00	QQQ	ETF	47.57	47.58	47.51	47.56	3839641.0
2007-06-28 11:30:00	QQQ	ETF	47.55	47.66	47.55	47.65	3353515.0
2007-06-28 12:00:00	QQQ	ETF	47.65	47.7	47.64	47.66	4813271.0
2007-06-28 12:30:00	QQQ	ETF	47.66	47.69	47.63	47.63	1806779.0
2007-06-28 13:00:00	QQQ	ETF	47.635	47.635	47.59	47.63	2291180.0
2007-06-28 13:30:00	QQQ	ETF	47.63	47.71	47.62	47.6795	2614664.0
2007-06-28 14:00:00	QQQ	ETF	47.67	47.85	47.57	47.67	16763495.0
2007-06-28 14:30:00	QQQ	ETF	47.68	47.75	47.51	47.68	17217000.0
2007-06-28 15:00:00	QQQ	ETF	47.68	47.7	47.54	47.65	7343517.0
2007-06-28 15:30:00	QQQ	ETF	47.65	47.71	47.5	47.5	13235750.0

> showing 50 of 4,306 rows — these rows as CSV

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