PREVIEW / etf_30min / 2007-08-20

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-20.parquet
  size:    130 KB
  rows:    4,746

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-08-20 05:30:00	SPY	ETF	145.0	145.0	144.88	144.88	1000.0
2007-08-20 06:00:00	SPY	ETF	144.9	144.95	144.8	144.95	16300.0
2007-08-20 06:30:00	SPY	ETF	145.13	145.37	145.13	145.37	33000.0
2007-08-20 07:00:00	SPY	ETF	145.27	145.33	144.9	145.1	184600.0
2007-08-20 07:30:00	SPY	ETF	145.14	145.2	145.0	145.18	189100.0
2007-08-20 08:00:00	SPY	ETF	145.2	145.38	144.98	145.19	1096100.0
2007-08-20 08:30:00	SPY	ETF	145.19	145.27	144.99	145.15	653700.0
2007-08-20 09:00:00	SPY	ETF	145.18	145.3	144.5	145.13	897900.0
2007-08-20 09:30:00	SPY	ETF	145.17	145.36	144.36	144.71	20622149.0
2007-08-20 10:00:00	SPY	ETF	144.71	145.1	144.49	144.63	13695028.0
2007-08-20 10:30:00	SPY	ETF	144.66	144.96	144.32	144.88	11121118.0
2007-08-20 11:00:00	SPY	ETF	144.89	144.9	144.4	144.56	8675055.0
2007-08-20 11:30:00	SPY	ETF	144.56	144.73	143.93	143.99	11790065.0
2007-08-20 12:00:00	SPY	ETF	143.97	144.17	143.54	143.9	16569129.0
2007-08-20 12:30:00	SPY	ETF	143.9	144.03	143.46	143.49	14432264.0
2007-08-20 13:00:00	SPY	ETF	143.49	143.86	143.29	143.5	10508271.0
2007-08-20 13:30:00	SPY	ETF	143.49	144.05	143.29	143.6	12509223.0
2007-08-20 14:00:00	SPY	ETF	143.6	143.92	143.32	143.89	9175419.0
2007-08-20 14:30:00	SPY	ETF	143.88	144.48	143.74	144.46	13628831.0
2007-08-20 15:00:00	SPY	ETF	144.46	145.47	144.42	145.21	16289390.0
2007-08-20 15:30:00	SPY	ETF	145.17	145.18	144.51	144.75	15968794.0
2007-08-20 16:00:00	SPY	ETF	144.74	144.8243	144.4206	144.66	2760300.0
2007-08-20 16:30:00	SPY	ETF	144.66	144.66	144.35	144.5	3999000.0
2007-08-20 17:00:00	SPY	ETF	144.55	144.55	144.44	144.44	57100.0
2007-08-20 17:30:00	SPY	ETF	144.44	144.5	144.44	144.5	1300.0
2007-08-20 18:00:00	SPY	ETF	144.52	144.66	144.52	144.66	151900.0
2007-08-20 18:30:00	SPY	ETF	144.61	144.71	144.61	144.63	2300.0
2007-08-20 19:00:00	SPY	ETF	144.63	144.64	144.46	144.51	13700.0
2007-08-20 19:30:00	SPY	ETF	144.64	144.64	144.45	144.49	226000.0
2007-08-20 04:00:00	QQQ	ETF	46.52	46.52	46.52	46.52	500.0
2007-08-20 04:30:00	QQQ	ETF	46.53	46.53	46.53	46.53	200.0
2007-08-20 05:00:00	QQQ	ETF	46.55	46.55	46.55	46.55	100.0
2007-08-20 06:30:00	QQQ	ETF	46.5	46.52	46.5	46.5	21000.0
2007-08-20 07:00:00	QQQ	ETF	46.5	46.5	46.31	46.38	389191.0
2007-08-20 07:30:00	QQQ	ETF	46.38	46.43	46.36	46.42	55200.0
2007-08-20 08:00:00	QQQ	ETF	46.42	46.51	46.4	46.46	1591135.0
2007-08-20 08:30:00	QQQ	ETF	46.46	46.5	46.39	46.47	876270.0
2007-08-20 09:00:00	QQQ	ETF	46.48	46.51	46.25	46.48	784387.0
2007-08-20 09:30:00	QQQ	ETF	46.49	46.53	46.31	46.46	14328413.0
2007-08-20 10:00:00	QQQ	ETF	46.47	46.64	46.42	46.54	10123576.0
2007-08-20 10:30:00	QQQ	ETF	46.54	46.55	46.43	46.53	5753673.0
2007-08-20 11:00:00	QQQ	ETF	46.53	46.54	46.4	46.48	5342810.0
2007-08-20 11:30:00	QQQ	ETF	46.47	46.54	46.33	46.35	6792138.0
2007-08-20 12:00:00	QQQ	ETF	46.34	46.4	46.19	46.32	10093182.0
2007-08-20 12:30:00	QQQ	ETF	46.32	46.38	46.18	46.2	7221211.0
2007-08-20 13:00:00	QQQ	ETF	46.21	46.26	46.08	46.16	8640606.0
2007-08-20 13:30:00	QQQ	ETF	46.15	46.38	46.12	46.21	11281819.0
2007-08-20 14:00:00	QQQ	ETF	46.2095	46.35	46.11	46.33	6999969.0
2007-08-20 14:30:00	QQQ	ETF	46.33	46.51	46.3	46.5	8377614.0
2007-08-20 15:00:00	QQQ	ETF	46.5	46.72	46.49	46.64	12933415.0

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

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