PREVIEW / etf_30min / 2007-12-03

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-03.parquet
  size:    137 KB
  rows:    5,139

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-03 04:00:00	SPY	ETF	148.18	148.2	148.08	148.08	4500.0
2007-12-03 05:00:00	SPY	ETF	148.2	148.2	148.2	148.2	200.0
2007-12-03 05:30:00	SPY	ETF	148.28	148.28	148.28	148.28	100.0
2007-12-03 06:00:00	SPY	ETF	148.35	148.58	148.35	148.58	10000.0
2007-12-03 06:30:00	SPY	ETF	148.51	148.52	148.51	148.51	10000.0
2007-12-03 07:00:00	SPY	ETF	148.31	148.64	148.29	148.57	366800.0
2007-12-03 07:30:00	SPY	ETF	148.6	148.63	148.4	148.56	501200.0
2007-12-03 08:00:00	SPY	ETF	148.4	148.71	148.37	148.54	1151500.0
2007-12-03 08:30:00	SPY	ETF	148.54	148.59	148.38	148.47	548400.0
2007-12-03 09:00:00	SPY	ETF	148.48	148.66	148.02	148.21	770400.0
2007-12-03 09:30:00	SPY	ETF	148.19	148.32	147.58	147.83	22074125.0
2007-12-03 10:00:00	SPY	ETF	147.83	148.12	147.39	147.62	12017228.0
2007-12-03 10:30:00	SPY	ETF	147.61	148.24	147.59	148.02	10087893.0
2007-12-03 11:00:00	SPY	ETF	148.01	148.13	147.66	148.03	6006838.0
2007-12-03 11:30:00	SPY	ETF	148.03	148.29	147.9	148.04	5692401.0
2007-12-03 12:00:00	SPY	ETF	148.05	148.31	147.9	148.29	5025067.0
2007-12-03 12:30:00	SPY	ETF	148.29	148.45	148.07	148.1301	4813755.0
2007-12-03 13:00:00	SPY	ETF	148.14	148.15	147.71	147.79	4745801.0
2007-12-03 13:30:00	SPY	ETF	147.79	147.79	147.41	147.49	16171222.0
2007-12-03 14:00:00	SPY	ETF	147.5	147.8	147.48	147.56	5393198.0
2007-12-03 14:30:00	SPY	ETF	147.56	147.82	147.39	147.76	8798699.0
2007-12-03 15:00:00	SPY	ETF	147.75	147.91	147.29	147.78	15420643.0
2007-12-03 15:30:00	SPY	ETF	147.78	147.92	147.35	147.55	14682201.0
2007-12-03 16:00:00	SPY	ETF	147.52	148.3	147.4	147.63	1102800.0
2007-12-03 16:30:00	SPY	ETF	147.63	147.68	147.49	147.55	962200.0
2007-12-03 17:00:00	SPY	ETF	147.52	147.57	147.47	147.53	179700.0
2007-12-03 17:30:00	SPY	ETF	147.58	147.89	147.54	147.59	65200.0
2007-12-03 18:00:00	SPY	ETF	147.58	147.59	147.55	147.55	14200.0
2007-12-03 18:30:00	SPY	ETF	147.58	147.58	147.46	147.46	4400.0
2007-12-03 19:00:00	SPY	ETF	147.68	147.68	147.47	147.51	487400.0
2007-12-03 19:30:00	SPY	ETF	147.47	147.47	147.34	147.37	13400.0
2007-12-03 04:30:00	QQQ	ETF	51.32	51.32	51.32	51.32	100.0
2007-12-03 05:00:00	QQQ	ETF	51.37	51.37	51.37	51.37	8731.0
2007-12-03 06:30:00	QQQ	ETF	51.43	51.43	51.4	51.42	16500.0
2007-12-03 07:00:00	QQQ	ETF	51.38	51.63	51.38	51.57	235091.0
2007-12-03 07:30:00	QQQ	ETF	51.58	51.58	51.48	51.5	330365.0
2007-12-03 08:00:00	QQQ	ETF	51.5	51.57	51.42	51.44	1132149.0
2007-12-03 08:30:00	QQQ	ETF	51.41	51.44	51.34	51.36	291950.0
2007-12-03 09:00:00	QQQ	ETF	51.35	51.39	51.09	51.14	1392629.0
2007-12-03 09:30:00	QQQ	ETF	51.14	51.38	51.06	51.27	11660902.0
2007-12-03 10:00:00	QQQ	ETF	51.2799	51.33	51.08	51.2	10819949.0
2007-12-03 10:30:00	QQQ	ETF	51.2	51.49	51.19	51.4301	11735638.0
2007-12-03 11:00:00	QQQ	ETF	51.44	51.48	51.27	51.44	4621473.0
2007-12-03 11:30:00	QQQ	ETF	51.44	51.53	51.41	51.4501	3846115.0
2007-12-03 12:00:00	QQQ	ETF	51.46	51.53	51.4	51.49	2902444.0
2007-12-03 12:30:00	QQQ	ETF	51.49	51.53	51.37	51.38	3595414.0
2007-12-03 13:00:00	QQQ	ETF	51.38	51.38	51.2	51.23	4292489.0
2007-12-03 13:30:00	QQQ	ETF	51.23	51.23	51.07	51.12	9905395.0
2007-12-03 14:00:00	QQQ	ETF	51.1199	51.25	51.08	51.08	7236423.0
2007-12-03 14:30:00	QQQ	ETF	51.09	51.15	50.97	51.1001	10046183.0

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

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