PREVIEW / etf_30min / 2009-05-14

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-14.parquet
  size:    216 KB
  rows:    7,125

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
2009-05-14 04:00:00	SPY	ETF	89.09	89.22	89.07	89.1	3400.0
2009-05-14 04:30:00	SPY	ETF	89.1	89.15	89.1	89.15	370.0
2009-05-14 05:30:00	SPY	ETF	89.0	89.1	89.0	89.01	16400.0
2009-05-14 06:00:00	SPY	ETF	88.94	88.95	88.68	88.74	17633.0
2009-05-14 06:30:00	SPY	ETF	88.6	88.88	88.55	88.71	19204.0
2009-05-14 07:00:00	SPY	ETF	88.68	88.81	88.54	88.6	197748.0
2009-05-14 07:30:00	SPY	ETF	88.61	89.08	88.55	88.95	921052.0
2009-05-14 08:00:00	SPY	ETF	88.95	88.96	88.53	88.66	3667370.0
2009-05-14 08:30:00	SPY	ETF	88.66	89.12	88.34	88.75	5764648.0
2009-05-14 09:00:00	SPY	ETF	88.73	88.96	88.63	88.77	1517193.0
2009-05-14 09:30:00	SPY	ETF	88.72	89.22	88.5	88.75	32767770.0
2009-05-14 10:00:00	SPY	ETF	88.74	89.29	88.74	88.96	24314322.0
2009-05-14 10:30:00	SPY	ETF	88.97	89.34	88.82	89.11	16712356.0
2009-05-14 11:00:00	SPY	ETF	89.11	89.52	89.08	89.45	15131457.0
2009-05-14 11:30:00	SPY	ETF	89.4401	89.5	89.27	89.43	10609801.0
2009-05-14 12:00:00	SPY	ETF	89.43	89.78	89.41	89.64	13304209.0
2009-05-14 12:30:00	SPY	ETF	89.6374	89.85	89.6	89.61	10784330.0
2009-05-14 13:00:00	SPY	ETF	89.6114	89.72	89.33	89.4	8544130.0
2009-05-14 13:30:00	SPY	ETF	89.4	89.68	89.38	89.47	7388462.0
2009-05-14 14:00:00	SPY	ETF	89.47	89.93	89.47	89.82	12336605.0
2009-05-14 14:30:00	SPY	ETF	89.83	90.12	89.78	89.92	30086294.0
2009-05-14 15:00:00	SPY	ETF	89.92	90.01	89.67	89.84	18632467.0
2009-05-14 15:30:00	SPY	ETF	89.84	89.855	89.32	89.44	30980207.0
2009-05-14 16:00:00	SPY	ETF	89.44	89.6	88.6514	89.4	8711229.0
2009-05-14 16:30:00	SPY	ETF	89.42	89.6	89.35	89.45	568014.0
2009-05-14 17:00:00	SPY	ETF	89.44	89.533	89.41	89.42	68300.0
2009-05-14 17:30:00	SPY	ETF	89.44	89.53	89.37	89.44	122611.0
2009-05-14 18:00:00	SPY	ETF	89.44	89.45	89.33	89.42	143876.0
2009-05-14 18:30:00	SPY	ETF	89.43	89.45	89.32	89.42	16025.0
2009-05-14 19:00:00	SPY	ETF	89.44	89.47	89.39	89.4	10600.0
2009-05-14 19:30:00	SPY	ETF	89.4	89.6	89.37	89.55	44307.0
2009-05-14 04:00:00	QQQ	ETF	33.15	33.15	33.15	33.15	100.0
2009-05-14 04:30:00	QQQ	ETF	33.09	33.18	33.09	33.18	1150.0
2009-05-14 05:00:00	QQQ	ETF	33.18	33.18	33.18	33.18	100.0
2009-05-14 07:00:00	QQQ	ETF	33.09	33.09	33.02	33.04	46000.0
2009-05-14 07:30:00	QQQ	ETF	33.05	33.23	33.04	33.23	898735.0
2009-05-14 08:00:00	QQQ	ETF	33.23	33.23	33.05	33.14	1923180.0
2009-05-14 08:30:00	QQQ	ETF	33.15	33.25	32.99	33.14	4198125.0
2009-05-14 09:00:00	QQQ	ETF	33.14	33.23	33.1	33.1	1118500.0
2009-05-14 09:30:00	QQQ	ETF	33.1	33.34	33.08	33.23	17973191.0
2009-05-14 10:00:00	QQQ	ETF	33.23	33.43	33.22	33.28	10753375.0
2009-05-14 10:30:00	QQQ	ETF	33.29	33.41	33.23	33.35	7390081.0
2009-05-14 11:00:00	QQQ	ETF	33.3475	33.49	33.34	33.45	7287614.0
2009-05-14 11:30:00	QQQ	ETF	33.45	33.5	33.4	33.48	3870330.0
2009-05-14 12:00:00	QQQ	ETF	33.48	33.58	33.41	33.52	5083888.0
2009-05-14 12:30:00	QQQ	ETF	33.52	33.6	33.51	33.54	4807380.0
2009-05-14 13:00:00	QQQ	ETF	33.54	33.58	33.44	33.4776	6725012.0
2009-05-14 13:30:00	QQQ	ETF	33.47	33.57	33.46	33.49	4607030.0
2009-05-14 14:00:00	QQQ	ETF	33.4899	33.64	33.4899	33.61	4635364.0
2009-05-14 14:30:00	QQQ	ETF	33.6	33.7	33.59	33.63	10154356.0

> showing 50 of 7,125 rows — these rows as CSV

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