PREVIEW / etf_30min / 2010-01-05

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-05.parquet
  size:    234 KB
  rows:    8,073

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
2010-01-05 04:30:00	SPY	ETF	113.29	113.29	113.27	113.27	900.0
2010-01-05 05:30:00	SPY	ETF	113.33	113.37	113.33	113.37	15100.0
2010-01-05 06:00:00	SPY	ETF	113.29	113.29	113.22	113.22	1600.0
2010-01-05 06:30:00	SPY	ETF	113.3	113.37	113.28	113.3	9525.0
2010-01-05 07:00:00	SPY	ETF	113.3	113.36	113.29	113.34	18400.0
2010-01-05 07:30:00	SPY	ETF	113.36	113.48	113.36	113.46	78832.0
2010-01-05 08:00:00	SPY	ETF	113.45	113.47	113.25	113.26	549741.0
2010-01-05 08:30:00	SPY	ETF	113.26	113.3598	113.26	113.29	664187.0
2010-01-05 09:00:00	SPY	ETF	113.29	113.34	113.2	113.27	782782.0
2010-01-05 09:30:00	SPY	ETF	113.26	113.36	112.9	112.98	18148008.0
2010-01-05 10:00:00	SPY	ETF	112.985	113.58	112.85	113.5183	11894675.0
2010-01-05 10:30:00	SPY	ETF	113.52	113.68	113.48	113.56	7891203.0
2010-01-05 11:00:00	SPY	ETF	113.57	113.61	113.31	113.32	8616857.0
2010-01-05 11:30:00	SPY	ETF	113.32	113.37	113.24	113.35	5794283.0
2010-01-05 12:00:00	SPY	ETF	113.36	113.5	113.35	113.4	4258037.0
2010-01-05 12:30:00	SPY	ETF	113.41	113.415	113.27	113.35	3318241.0
2010-01-05 13:00:00	SPY	ETF	113.35	113.38	113.15	113.2299	5058000.0
2010-01-05 13:30:00	SPY	ETF	113.2201	113.36	113.16	113.25	4437079.0
2010-01-05 14:00:00	SPY	ETF	113.2599	113.29	113.04	113.18	6785786.0
2010-01-05 14:30:00	SPY	ETF	113.1899	113.37	113.18	113.349	4458168.0
2010-01-05 15:00:00	SPY	ETF	113.35	113.5	113.34	113.465	6288598.0
2010-01-05 15:30:00	SPY	ETF	113.47	113.67	113.46	113.63	13907936.0
2010-01-05 16:00:00	SPY	ETF	113.63	113.72	113.04	113.65	7178375.0
2010-01-05 16:30:00	SPY	ETF	113.64	113.66	113.3032	113.6	1097996.0
2010-01-05 17:00:00	SPY	ETF	113.6	113.62	113.59	113.62	57087.0
2010-01-05 17:30:00	SPY	ETF	113.63	113.64	113.57	113.6	28093.0
2010-01-05 18:00:00	SPY	ETF	113.58	113.61	113.57	113.59	25061.0
2010-01-05 18:30:00	SPY	ETF	113.6	113.6	113.55	113.55	12675.0
2010-01-05 19:00:00	SPY	ETF	113.56	113.56	113.53	113.55	4470.0
2010-01-05 19:30:00	SPY	ETF	113.55	113.6	113.51	113.6	18430.0
2010-01-05 04:00:00	QQQ	ETF	46.36	46.36	46.36	46.36	300.0
2010-01-05 05:30:00	QQQ	ETF	46.41	46.43	46.4	46.4	26000.0
2010-01-05 06:00:00	QQQ	ETF	46.37	46.37	46.36	46.36	1500.0
2010-01-05 06:30:00	QQQ	ETF	46.43	46.44	46.42	46.44	76000.0
2010-01-05 07:00:00	QQQ	ETF	46.44	46.44	46.41	46.42	26923.0
2010-01-05 07:30:00	QQQ	ETF	46.45	46.47	46.44	46.45	218001.0
2010-01-05 08:00:00	QQQ	ETF	46.45	46.5	46.37	46.37	184061.0
2010-01-05 08:30:00	QQQ	ETF	46.38	46.4	46.27	46.37	461760.0
2010-01-05 09:00:00	QQQ	ETF	46.37	46.39	46.35	46.38	394041.0
2010-01-05 09:30:00	QQQ	ETF	46.38	46.44	46.26	46.29	8410379.0
2010-01-05 10:00:00	QQQ	ETF	46.32	46.5	46.26	46.47	6504266.0
2010-01-05 10:30:00	QQQ	ETF	46.46	46.5	46.42	46.47	3826434.0
2010-01-05 11:00:00	QQQ	ETF	46.46	46.49	46.35	46.3605	3795453.0
2010-01-05 11:30:00	QQQ	ETF	46.37	46.38	46.33	46.37	2997295.0
2010-01-05 12:00:00	QQQ	ETF	46.38	46.42	46.36	46.38	1356075.0
2010-01-05 12:30:00	QQQ	ETF	46.38	46.39	46.31	46.36	4190185.0
2010-01-05 13:00:00	QQQ	ETF	46.3599	46.37	46.27	46.305	3035675.0
2010-01-05 13:30:00	QQQ	ETF	46.31	46.35	46.27	46.3	2121495.0
2010-01-05 14:00:00	QQQ	ETF	46.3	46.33	46.16	46.24	7361981.0
2010-01-05 14:30:00	QQQ	ETF	46.24	46.35	46.24	46.34	2243900.0

> showing 50 of 8,073 rows — these rows as CSV

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