PREVIEW / etf_30min / 2008-01-02

all etf 30-min files

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

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-01-02 06:00:00	SPY	ETF	146.89	147.05	146.85	147.0	5100.0
2008-01-02 06:30:00	SPY	ETF	147.0	147.13	147.0	147.13	25900.0
2008-01-02 07:00:00	SPY	ETF	147.14	147.15	146.89	146.94	126900.0
2008-01-02 07:30:00	SPY	ETF	146.91	146.99	146.76	146.8	436800.0
2008-01-02 08:00:00	SPY	ETF	146.8	146.96	146.21	146.68	492700.0
2008-01-02 08:30:00	SPY	ETF	146.68	146.85	146.21	146.85	463100.0
2008-01-02 09:00:00	SPY	ETF	146.86	146.92	146.21	146.54	654944.0
2008-01-02 09:30:00	SPY	ETF	146.53	146.99	146.52	146.72	11843913.0
2008-01-02 10:00:00	SPY	ETF	146.72	146.72	145.5	145.8	25531820.0
2008-01-02 10:30:00	SPY	ETF	145.79	145.83	145.44	145.49	7891363.0
2008-01-02 11:00:00	SPY	ETF	145.49	145.64	144.92	145.13	13074542.0
2008-01-02 11:30:00	SPY	ETF	145.13	145.79	144.64	145.06	13185672.0
2008-01-02 12:00:00	SPY	ETF	145.06	145.06	144.33	144.41	9667805.0
2008-01-02 12:30:00	SPY	ETF	144.41	144.7	144.35	144.6	7755409.0
2008-01-02 13:00:00	SPY	ETF	144.6	144.71	144.16	144.39	8158433.0
2008-01-02 13:30:00	SPY	ETF	144.4	144.83	144.3	144.67	8463630.0
2008-01-02 14:00:00	SPY	ETF	144.67	145.58	144.61	145.11	27054031.0
2008-01-02 14:30:00	SPY	ETF	145.11	145.75	144.42	144.45	10260193.0
2008-01-02 15:00:00	SPY	ETF	144.45	144.46	143.88	144.23	14914525.0
2008-01-02 15:30:00	SPY	ETF	144.22	144.7	144.16	144.55	14725670.0
2008-01-02 16:00:00	SPY	ETF	144.57	146.6246	144.48	144.88	14806300.0
2008-01-02 16:30:00	SPY	ETF	144.88	146.6246	144.85	144.97	4187200.0
2008-01-02 17:00:00	SPY	ETF	144.97	145.06	144.97	145.05	223100.0
2008-01-02 17:30:00	SPY	ETF	145.09	145.1	145.05	145.1	1100.0
2008-01-02 18:00:00	SPY	ETF	145.05	145.18	145.03	145.14	26700.0
2008-01-02 18:30:00	SPY	ETF	145.16	145.19	145.01	145.07	6700.0
2008-01-02 19:00:00	SPY	ETF	145.06	145.1	145.01	145.1	2000.0
2008-01-02 19:30:00	SPY	ETF	145.09	145.2	145.07	145.18	9800.0
2008-01-02 06:30:00	QQQ	ETF	51.52	51.52	51.51	51.52	12500.0
2008-01-02 07:00:00	QQQ	ETF	51.53	51.53	51.44	51.47	105450.0
2008-01-02 07:30:00	QQQ	ETF	51.44	51.45	51.39	51.4	35787.0
2008-01-02 08:00:00	QQQ	ETF	51.4	51.44	51.24	51.38	358850.0
2008-01-02 08:30:00	QQQ	ETF	51.38	51.42	51.35	51.35	178940.0
2008-01-02 09:00:00	QQQ	ETF	51.34	51.37	51.22	51.26	779158.0
2008-01-02 09:30:00	QQQ	ETF	51.27	51.47	51.26	51.38	7863532.0
2008-01-02 10:00:00	QQQ	ETF	51.39	51.39	51.06	51.23	19099435.0
2008-01-02 10:30:00	QQQ	ETF	51.23	51.24	50.92	50.93	8507569.0
2008-01-02 11:00:00	QQQ	ETF	50.93	51.04	50.6	50.64	9798760.0
2008-01-02 11:30:00	QQQ	ETF	50.64	50.65	50.27	50.4701	14324582.0
2008-01-02 12:00:00	QQQ	ETF	50.47	50.48	50.13	50.17	13290147.0
2008-01-02 12:30:00	QQQ	ETF	50.16	50.36	50.16	50.31	5814990.0
2008-01-02 13:00:00	QQQ	ETF	50.31	50.37	50.13	50.22	8525902.0
2008-01-02 13:30:00	QQQ	ETF	50.229	50.45	50.19	50.36	7968877.0
2008-01-02 14:00:00	QQQ	ETF	50.37	50.8	50.35	50.61	19794966.0
2008-01-02 14:30:00	QQQ	ETF	50.61	50.65	50.25	50.27	12264660.0
2008-01-02 15:00:00	QQQ	ETF	50.27	50.33	50.16	50.229	11270157.0
2008-01-02 15:30:00	QQQ	ETF	50.22	50.45	50.19	50.41	11045954.0
2008-01-02 16:00:00	QQQ	ETF	50.41	50.51	50.37	50.47	2356276.0
2008-01-02 16:30:00	QQQ	ETF	50.46	50.53	50.41	50.5	372824.0
2008-01-02 17:00:00	QQQ	ETF	50.5	50.55	50.5	50.55	14290.0

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

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