PREVIEW / etf_30min / 2008-02-01

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-01.parquet
  size:    158 KB
  rows:    5,670

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
2008-02-01 05:30:00	SPY	ETF	137.8	137.82	137.8	137.82	17500.0
2008-02-01 06:00:00	SPY	ETF	137.92	138.02	137.92	138.02	500.0
2008-02-01 06:30:00	SPY	ETF	138.02	139.25	138.02	139.17	377400.0
2008-02-01 07:00:00	SPY	ETF	139.29	139.37	138.75	139.11	1426800.0
2008-02-01 07:30:00	SPY	ETF	139.04	139.61	138.86	139.41	2158600.0
2008-02-01 08:00:00	SPY	ETF	139.4	139.45	137.29	139.13	4469400.0
2008-02-01 08:30:00	SPY	ETF	139.15	139.29	137.72	137.84	14212100.0
2008-02-01 09:00:00	SPY	ETF	137.84	137.98	137.44	137.91	3314106.0
2008-02-01 09:30:00	SPY	ETF	137.94	138.71	137.72	138.55	19044128.0
2008-02-01 10:00:00	SPY	ETF	138.55	139.61	138.32	138.57	32845318.0
2008-02-01 10:30:00	SPY	ETF	138.58	138.58	137.52	137.91	24060971.0
2008-02-01 11:00:00	SPY	ETF	137.91	138.44	137.7	138.17	11613501.0
2008-02-01 11:30:00	SPY	ETF	138.2	138.71	138.05	138.54	10457903.0
2008-02-01 12:00:00	SPY	ETF	138.53	138.63	138.07	138.25	8457494.0
2008-02-01 12:30:00	SPY	ETF	138.25	138.3	137.93	138.02	6366702.0
2008-02-01 13:00:00	SPY	ETF	138.03	138.64	138.02	138.53	6502924.0
2008-02-01 13:30:00	SPY	ETF	138.55	138.82	138.33	138.34	8153684.0
2008-02-01 14:00:00	SPY	ETF	138.33	139.31	138.28	138.89	7707787.0
2008-02-01 14:30:00	SPY	ETF	138.9	139.32	138.89	139.18	9976086.0
2008-02-01 15:00:00	SPY	ETF	139.17	139.43	138.85	139.24	13624551.0
2008-02-01 15:30:00	SPY	ETF	139.25	139.51	139.17	139.45	14882009.0
2008-02-01 16:00:00	SPY	ETF	139.47	139.59	138.07	139.48	3967319.0
2008-02-01 16:30:00	SPY	ETF	139.49	139.8	139.49	139.7	758400.0
2008-02-01 17:00:00	SPY	ETF	139.7	139.72	139.6	139.6	22500.0
2008-02-01 17:30:00	SPY	ETF	139.55	139.65	139.5	139.6	5900.0
2008-02-01 18:00:00	SPY	ETF	139.56	139.6	139.49	139.55	329600.0
2008-02-01 18:30:00	SPY	ETF	139.55	139.63	139.54	139.55	8700.0
2008-02-01 19:00:00	SPY	ETF	139.55	139.58	139.5	139.55	4800.0
2008-02-01 19:30:00	SPY	ETF	139.55	139.58	139.55	139.55	1800.0
2008-02-01 06:30:00	QQQ	ETF	45.28	45.99	45.28	45.95	411520.0
2008-02-01 07:00:00	QQQ	ETF	45.95	46.0	45.67	45.82	637707.0
2008-02-01 07:30:00	QQQ	ETF	45.8	46.03	45.76	45.92	926212.0
2008-02-01 08:00:00	QQQ	ETF	45.9	45.91	45.71	45.81	4443304.0
2008-02-01 08:30:00	QQQ	ETF	45.81	45.98	45.4	45.6	5287559.0
2008-02-01 09:00:00	QQQ	ETF	45.6	45.88	45.1	45.52	4536403.0
2008-02-01 09:30:00	QQQ	ETF	45.52	45.62	45.27	45.5	18858793.0
2008-02-01 10:00:00	QQQ	ETF	45.5099	45.88	45.39	45.51	24405894.0
2008-02-01 10:30:00	QQQ	ETF	45.51	45.51	44.88	44.98	23221334.0
2008-02-01 11:00:00	QQQ	ETF	44.97	45.19	44.9	45.1	10267341.0
2008-02-01 11:30:00	QQQ	ETF	45.09	45.3	45.04	45.26	5446468.0
2008-02-01 12:00:00	QQQ	ETF	45.2601	45.27	45.08	45.17	7487428.0
2008-02-01 12:30:00	QQQ	ETF	45.1689	45.19	45.05	45.1	3816634.0
2008-02-01 13:00:00	QQQ	ETF	45.1001	45.38	45.1	45.36	7156628.0
2008-02-01 13:30:00	QQQ	ETF	45.36	45.45	45.28	45.2801	5979019.0
2008-02-01 14:00:00	QQQ	ETF	45.29	45.55	45.24	45.51	8159120.0
2008-02-01 14:30:00	QQQ	ETF	45.52	45.71	45.5	45.65	8099939.0
2008-02-01 15:00:00	QQQ	ETF	45.6485	45.73	45.5	45.641	8049589.0
2008-02-01 15:30:00	QQQ	ETF	45.64	45.76	45.55	45.6	9991241.0
2008-02-01 16:00:00	QQQ	ETF	45.6	45.77	45.5278	45.54	4007228.0
2008-02-01 16:30:00	QQQ	ETF	45.54	45.65	45.53	45.65	1166440.0

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

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