PREVIEW / etf_30min / 2008-06-02

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-02.parquet
  size:    167 KB
  rows:    5,763

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-06-02 04:00:00	SPY	ETF	139.71	139.71	139.5	139.51	20550.0
2008-06-02 04:30:00	SPY	ETF	139.51	139.51	139.42	139.42	900.0
2008-06-02 06:00:00	SPY	ETF	139.7	139.72	139.65	139.65	18500.0
2008-06-02 06:30:00	SPY	ETF	139.67	139.68	139.58	139.61	26095.0
2008-06-02 07:00:00	SPY	ETF	139.61	139.71	139.52	139.7	205600.0
2008-06-02 07:30:00	SPY	ETF	139.72	139.72	139.6	139.7	184600.0
2008-06-02 08:00:00	SPY	ETF	139.69	139.76	139.39	139.62	1164401.0
2008-06-02 08:30:00	SPY	ETF	139.61	140.35	139.59	139.68	637837.0
2008-06-02 09:00:00	SPY	ETF	139.68	139.82	139.66	139.82	422792.0
2008-06-02 09:30:00	SPY	ETF	139.83	139.86	139.18	139.27	15885365.0
2008-06-02 10:00:00	SPY	ETF	139.28	139.66	138.8	138.9	18333979.0
2008-06-02 10:30:00	SPY	ETF	138.905	139.08	138.7	138.98	10792883.0
2008-06-02 11:00:00	SPY	ETF	138.98	139.09	138.79	138.88	10369991.0
2008-06-02 11:30:00	SPY	ETF	138.87	139.01	138.65	138.96	10488590.0
2008-06-02 12:00:00	SPY	ETF	138.97	139.03	138.82	138.83	4977480.0
2008-06-02 12:30:00	SPY	ETF	138.83	138.87	138.0	138.1	23882475.0
2008-06-02 13:00:00	SPY	ETF	138.1	138.37	138.03	138.33	12817654.0
2008-06-02 13:30:00	SPY	ETF	138.33	138.465	138.18	138.46	9140444.0
2008-06-02 14:00:00	SPY	ETF	138.46	138.61	138.31	138.54	11632371.0
2008-06-02 14:30:00	SPY	ETF	138.54	138.59	138.35	138.37	9025609.0
2008-06-02 15:00:00	SPY	ETF	138.37	138.76	138.23	138.65	15918527.0
2008-06-02 15:30:00	SPY	ETF	138.66	139.03	138.6	138.83	17370564.0
2008-06-02 16:00:00	SPY	ETF	138.829	138.95	138.75	138.95	5724747.0
2008-06-02 16:30:00	SPY	ETF	138.9	138.9	138.84	138.86	148676.0
2008-06-02 17:00:00	SPY	ETF	138.86	138.87	138.86	138.87	137200.0
2008-06-02 17:30:00	SPY	ETF	138.87	138.89	138.83	138.89	32279.0
2008-06-02 18:00:00	SPY	ETF	138.86	138.86	138.82	138.85	13206.0
2008-06-02 18:30:00	SPY	ETF	138.85	138.85	138.81	138.81	1260.0
2008-06-02 19:00:00	SPY	ETF	138.83	138.83	138.78	138.82	10375.0
2008-06-02 19:30:00	SPY	ETF	138.81	138.85	138.79	138.85	5983.0
2008-06-02 05:30:00	QQQ	ETF	49.82	49.82	49.82	49.82	200.0
2008-06-02 06:30:00	QQQ	ETF	49.84	49.84	49.82	49.82	700.0
2008-06-02 07:00:00	QQQ	ETF	49.82	49.9	49.82	49.9	60200.0
2008-06-02 07:30:00	QQQ	ETF	49.86	49.89	49.84	49.89	183849.0
2008-06-02 08:00:00	QQQ	ETF	49.88	49.91	49.84	49.86	221889.0
2008-06-02 08:30:00	QQQ	ETF	49.85	50.01	49.85	49.88	146594.0
2008-06-02 09:00:00	QQQ	ETF	49.88	49.92	49.86	49.91	590801.0
2008-06-02 09:30:00	QQQ	ETF	49.92	49.92	49.64	49.72	13389907.0
2008-06-02 10:00:00	QQQ	ETF	49.72	49.77	49.41	49.49	23356440.0
2008-06-02 10:30:00	QQQ	ETF	49.48	49.56	49.41	49.45	6718860.0
2008-06-02 11:00:00	QQQ	ETF	49.45	49.47	49.27	49.3	8483611.0
2008-06-02 11:30:00	QQQ	ETF	49.31	49.39	49.24	49.38	7679053.0
2008-06-02 12:00:00	QQQ	ETF	49.37	49.4	49.34	49.3499	4071480.0
2008-06-02 12:30:00	QQQ	ETF	49.35	49.35	49.0	49.0	13413960.0
2008-06-02 13:00:00	QQQ	ETF	49.0	49.13	48.96	49.07	7878349.0
2008-06-02 13:30:00	QQQ	ETF	49.07	49.17	49.03	49.17	4321505.0
2008-06-02 14:00:00	QQQ	ETF	49.17	49.21	49.08	49.15	7621195.0
2008-06-02 14:30:00	QQQ	ETF	49.16	49.22	49.11	49.12	4916920.0
2008-06-02 15:00:00	QQQ	ETF	49.12	49.28	49.01	49.22	11036469.0
2008-06-02 15:30:00	QQQ	ETF	49.23	49.41	49.21	49.4	14456648.0

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

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