PREVIEW / etf_30min / 2007-05-03

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-03.parquet
  size:    107 KB
  rows:    3,879

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-05-03 04:30:00	SPY	ETF	149.47	149.47	149.47	149.47	900.0
2007-05-03 06:00:00	SPY	ETF	149.37	149.37	149.37	149.37	12500.0
2007-05-03 06:30:00	SPY	ETF	149.46	149.48	149.46	149.48	36000.0
2007-05-03 07:00:00	SPY	ETF	149.52	149.55	149.49	149.51	36200.0
2007-05-03 07:30:00	SPY	ETF	149.55	149.75	149.55	149.64	171500.0
2007-05-03 08:00:00	SPY	ETF	149.66	149.68	149.56	149.67	1326400.0
2007-05-03 08:30:00	SPY	ETF	149.7	150.25	149.67	150.18	5496900.0
2007-05-03 09:00:00	SPY	ETF	150.18	150.2	149.38	149.95	1501400.0
2007-05-03 09:30:00	SPY	ETF	149.97	150.05	149.73	149.95	8823038.0
2007-05-03 10:00:00	SPY	ETF	149.96	150.24	149.05	149.96	11418022.0
2007-05-03 10:30:00	SPY	ETF	149.96	150.37	149.85	150.34	10470931.0
2007-05-03 11:00:00	SPY	ETF	150.34	150.37	150.15	150.271	6124444.0
2007-05-03 11:30:00	SPY	ETF	150.27	150.29	150.09	150.24	4641154.0
2007-05-03 12:00:00	SPY	ETF	150.25	150.31	149.93	149.94	3905429.0
2007-05-03 12:30:00	SPY	ETF	149.93	150.16	149.92	150.12	2749416.0
2007-05-03 13:00:00	SPY	ETF	150.13	150.22	149.96	150.04	2718428.0
2007-05-03 13:30:00	SPY	ETF	150.05	150.26	149.99	150.16	3772429.0
2007-05-03 14:00:00	SPY	ETF	150.17	150.29	150.12	150.26	3548389.0
2007-05-03 14:30:00	SPY	ETF	150.27	150.35	149.647	150.35	4827806.0
2007-05-03 15:00:00	SPY	ETF	150.35	150.4	150.27	150.32	4452097.0
2007-05-03 15:30:00	SPY	ETF	150.33	150.38	150.14	150.26	8370261.0
2007-05-03 16:00:00	SPY	ETF	150.26	150.38	150.25	150.32	1044400.0
2007-05-03 16:30:00	SPY	ETF	150.3	150.3	150.19	150.23	242900.0
2007-05-03 17:00:00	SPY	ETF	150.24	150.29	150.24	150.28	134400.0
2007-05-03 17:30:00	SPY	ETF	150.23	150.23	150.22	150.22	638700.0
2007-05-03 18:30:00	SPY	ETF	150.24	150.27	150.22	150.27	1200.0
2007-05-03 19:00:00	SPY	ETF	150.28	150.28	150.26	150.28	17900.0
2007-05-03 19:30:00	SPY	ETF	150.25	150.28	150.24	150.24	3000.0
2007-05-03 04:00:00	QQQ	ETF	46.43	46.43	46.43	46.43	14000.0
2007-05-03 07:00:00	QQQ	ETF	46.46	46.49	46.44	46.47	202250.0
2007-05-03 07:30:00	QQQ	ETF	46.48	46.54	46.48	46.48	262366.0
2007-05-03 08:00:00	QQQ	ETF	46.48	46.5	46.43	46.45	537364.0
2007-05-03 08:30:00	QQQ	ETF	46.45	46.64	46.45	46.62	2023545.0
2007-05-03 09:00:00	QQQ	ETF	46.61	46.62	46.51	46.52	776866.0
2007-05-03 09:30:00	QQQ	ETF	46.53	46.55	46.43	46.53	13999742.0
2007-05-03 10:00:00	QQQ	ETF	46.53	46.61	46.48	46.55	22700837.0
2007-05-03 10:30:00	QQQ	ETF	46.55	46.71	46.52	46.7	10378975.0
2007-05-03 11:00:00	QQQ	ETF	46.7	46.72	46.64	46.66	7513631.0
2007-05-03 11:30:00	QQQ	ETF	46.67	46.67	46.57	46.628	3015578.0
2007-05-03 12:00:00	QQQ	ETF	46.63	46.64	46.53	46.54	4255781.0
2007-05-03 12:30:00	QQQ	ETF	46.53	46.6	46.53	46.6	1695319.0
2007-05-03 13:00:00	QQQ	ETF	46.59	46.62	46.51	46.532	5689972.0
2007-05-03 13:30:00	QQQ	ETF	46.54	46.61	46.51	46.57	3046873.0
2007-05-03 14:00:00	QQQ	ETF	46.58	46.63	46.56	46.6	2252095.0
2007-05-03 14:30:00	QQQ	ETF	46.6	46.64	46.55	46.63	1926667.0
2007-05-03 15:00:00	QQQ	ETF	46.6388	46.66	46.62	46.6205	2475117.0
2007-05-03 15:30:00	QQQ	ETF	46.62	46.64	46.53	46.6	9588018.0
2007-05-03 16:00:00	QQQ	ETF	46.6	46.63	46.58	46.61	1130103.0
2007-05-03 16:30:00	QQQ	ETF	46.61	46.62	46.56	46.57	3263360.0
2007-05-03 17:00:00	QQQ	ETF	46.57	46.6	46.55	46.59	304438.0

> showing 50 of 3,879 rows — these rows as CSV

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