PREVIEW / etf_30min / 2008-02-04

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-04.parquet
  size:    150 KB
  rows:    5,566

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-04 04:30:00	SPY	ETF	139.41	139.41	139.34	139.34	9600.0
2008-02-04 05:00:00	SPY	ETF	139.17	139.17	139.17	139.17	1000.0
2008-02-04 05:30:00	SPY	ETF	139.25	139.37	139.25	139.37	9100.0
2008-02-04 06:00:00	SPY	ETF	139.34	139.34	139.34	139.34	7500.0
2008-02-04 06:30:00	SPY	ETF	139.58	139.86	139.58	139.78	10000.0
2008-02-04 07:00:00	SPY	ETF	139.73	139.81	139.43	139.43	97200.0
2008-02-04 07:30:00	SPY	ETF	139.43	139.5	139.33	139.4	63400.0
2008-02-04 08:00:00	SPY	ETF	139.39	139.5	139.1	139.3	901000.0
2008-02-04 08:30:00	SPY	ETF	139.25	139.41	139.19	139.35	366600.0
2008-02-04 09:00:00	SPY	ETF	139.35	139.58	139.18	139.18	834340.0
2008-02-04 09:30:00	SPY	ETF	139.21	139.3	138.43	138.65	18184284.0
2008-02-04 10:00:00	SPY	ETF	138.65	138.71	138.21	138.59	11670533.0
2008-02-04 10:30:00	SPY	ETF	138.58	138.8	138.1	138.6	10236995.0
2008-02-04 11:00:00	SPY	ETF	138.6	138.9	138.46	138.81	8252919.0
2008-02-04 11:30:00	SPY	ETF	138.81	138.94	138.55	138.63	6302850.0
2008-02-04 12:00:00	SPY	ETF	138.63	138.67	138.21	138.3	5244724.0
2008-02-04 12:30:00	SPY	ETF	138.3	138.6	138.3	138.51	3922310.0
2008-02-04 13:00:00	SPY	ETF	138.51	138.8	138.05	138.21	7674186.0
2008-02-04 13:30:00	SPY	ETF	138.21	138.58	138.2	138.5301	4720627.0
2008-02-04 14:00:00	SPY	ETF	138.53	138.55	138.24	138.41	3784227.0
2008-02-04 14:30:00	SPY	ETF	138.41	138.41	137.91	138.22	10804018.0
2008-02-04 15:00:00	SPY	ETF	138.22	138.53	138.15	138.42	7997302.0
2008-02-04 15:30:00	SPY	ETF	138.41	138.46	137.88	138.0	11249839.0
2008-02-04 16:00:00	SPY	ETF	138.032	138.2012	137.64	137.79	3558800.0
2008-02-04 16:30:00	SPY	ETF	137.72	137.73	137.6	137.6	768000.0
2008-02-04 17:00:00	SPY	ETF	137.82	137.82	137.57	137.69	1847400.0
2008-02-04 17:30:00	SPY	ETF	137.67	137.7	137.65	137.68	19500.0
2008-02-04 18:00:00	SPY	ETF	137.64	137.84	137.64	137.84	30700.0
2008-02-04 18:30:00	SPY	ETF	137.81	137.81	137.72	137.77	26400.0
2008-02-04 19:00:00	SPY	ETF	137.7	137.7	137.59	137.65	37800.0
2008-02-04 19:30:00	SPY	ETF	137.62	137.62	137.58	137.61	1700.0
2008-02-04 06:30:00	QQQ	ETF	45.78	45.82	45.78	45.82	300.0
2008-02-04 07:00:00	QQQ	ETF	45.8	45.8	45.68	45.68	34382.0
2008-02-04 07:30:00	QQQ	ETF	45.68	45.74	45.63	45.65	58468.0
2008-02-04 08:00:00	QQQ	ETF	45.66	45.69	45.58	45.64	253327.0
2008-02-04 08:30:00	QQQ	ETF	45.61	45.67	45.61	45.64	336140.0
2008-02-04 09:00:00	QQQ	ETF	45.65	45.67	45.57	45.58	429904.0
2008-02-04 09:30:00	QQQ	ETF	45.58	45.61	45.38	45.5	14819392.0
2008-02-04 10:00:00	QQQ	ETF	45.5	45.53	45.32	45.36	6648279.0
2008-02-04 10:30:00	QQQ	ETF	45.3699	45.39	45.1899	45.35	9015213.0
2008-02-04 11:00:00	QQQ	ETF	45.35	45.44	45.27	45.35	7254622.0
2008-02-04 11:30:00	QQQ	ETF	45.35	45.46	45.24	45.26	5523845.0
2008-02-04 12:00:00	QQQ	ETF	45.26	45.27	45.07	45.13	4932056.0
2008-02-04 12:30:00	QQQ	ETF	45.13	45.21	45.09	45.1699	4354949.0
2008-02-04 13:00:00	QQQ	ETF	45.17	45.18	45.0	45.02	4928395.0
2008-02-04 13:30:00	QQQ	ETF	45.02	45.19	45.02	45.17	5876660.0
2008-02-04 14:00:00	QQQ	ETF	45.16	45.17	45.05	45.11	3802790.0
2008-02-04 14:30:00	QQQ	ETF	45.11	45.13	44.94	45.081	9289972.0
2008-02-04 15:00:00	QQQ	ETF	45.08	45.16	45.05	45.15	8071256.0
2008-02-04 15:30:00	QQQ	ETF	45.15	45.15	44.95	44.97	6133155.0

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

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