PREVIEW / etf_30min / 2008-04-02

all etf 30-min files

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

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-04-02 04:00:00	SPY	ETF	136.15	136.24	136.15	136.24	1800.0
2008-04-02 05:00:00	SPY	ETF	136.23	136.23	136.17	136.17	2200.0
2008-04-02 05:30:00	SPY	ETF	136.02	136.15	136.02	136.15	8000.0
2008-04-02 06:00:00	SPY	ETF	136.19	136.28	136.16	136.28	9000.0
2008-04-02 06:30:00	SPY	ETF	136.37	136.51	136.34	136.48	117100.0
2008-04-02 07:00:00	SPY	ETF	136.5	136.7	136.44	136.54	630600.0
2008-04-02 07:30:00	SPY	ETF	136.56	136.95	136.53	136.93	664400.0
2008-04-02 08:00:00	SPY	ETF	136.92	137.4	136.1	137.21	4758100.0
2008-04-02 08:30:00	SPY	ETF	137.2	137.28	136.96	137.07	1146000.0
2008-04-02 09:00:00	SPY	ETF	137.06	137.1	136.94	137.04	838400.0
2008-04-02 09:30:00	SPY	ETF	137.06	137.1	136.3	136.5	22389806.0
2008-04-02 10:00:00	SPY	ETF	136.49	137.0	136.25	136.93	19103572.0
2008-04-02 10:30:00	SPY	ETF	136.93	137.67	136.93	137.52	22508764.0
2008-04-02 11:00:00	SPY	ETF	137.52	137.61	137.0	137.1	16754650.0
2008-04-02 11:30:00	SPY	ETF	137.11	137.57	137.07	137.51	10957385.0
2008-04-02 12:00:00	SPY	ETF	137.51	137.64	137.16	137.22	9415069.0
2008-04-02 12:30:00	SPY	ETF	137.21	137.5	136.89	137.06	10453241.0
2008-04-02 13:00:00	SPY	ETF	137.07	137.2	136.7	136.94	11359607.0
2008-04-02 13:30:00	SPY	ETF	136.94	137.36	136.69	137.19	9615833.0
2008-04-02 14:00:00	SPY	ETF	137.19	137.51	136.98	137.05	11999154.0
2008-04-02 14:30:00	SPY	ETF	137.05	137.36	136.0	136.46	19365945.0
2008-04-02 15:00:00	SPY	ETF	136.4609	136.58	135.98	136.55	16281573.0
2008-04-02 15:30:00	SPY	ETF	136.55	136.66	136.24	136.65	14528420.0
2008-04-02 16:00:00	SPY	ETF	136.62	137.42	136.58	136.74	2965936.0
2008-04-02 16:30:00	SPY	ETF	136.74	136.76	136.45	136.5	617337.0
2008-04-02 17:00:00	SPY	ETF	136.49	136.59	136.48	136.55	1605900.0
2008-04-02 17:30:00	SPY	ETF	136.53	136.59	136.43	136.53	29300.0
2008-04-02 18:00:00	SPY	ETF	136.53	136.54	136.45	136.53	25300.0
2008-04-02 18:30:00	SPY	ETF	136.54	136.56	136.48	136.48	11300.0
2008-04-02 19:00:00	SPY	ETF	136.47	136.5	136.38	136.5	7300.0
2008-04-02 19:30:00	SPY	ETF	136.47	136.51	136.42	136.48	16200.0
2008-04-02 04:00:00	QQQ	ETF	45.37	45.37	45.37	45.37	4080.0
2008-04-02 04:30:00	QQQ	ETF	45.41	45.47	45.4	45.4	10603.0
2008-04-02 05:30:00	QQQ	ETF	45.37	45.42	45.37	45.42	5400.0
2008-04-02 06:30:00	QQQ	ETF	45.54	45.56	45.53	45.54	16800.0
2008-04-02 07:00:00	QQQ	ETF	45.55	45.66	45.55	45.62	60878.0
2008-04-02 07:30:00	QQQ	ETF	45.64	45.67	45.6	45.65	225528.0
2008-04-02 08:00:00	QQQ	ETF	45.65	45.8	45.64	45.77	1443747.0
2008-04-02 08:30:00	QQQ	ETF	45.75	45.77	45.71	45.72	992324.0
2008-04-02 09:00:00	QQQ	ETF	45.71	45.71	45.64	45.69	746315.0
2008-04-02 09:30:00	QQQ	ETF	45.69	45.7	45.45	45.54	14566366.0
2008-04-02 10:00:00	QQQ	ETF	45.54	45.81	45.45	45.78	11582763.0
2008-04-02 10:30:00	QQQ	ETF	45.79	46.02	45.78	45.92	17136665.0
2008-04-02 11:00:00	QQQ	ETF	45.92	45.94	45.75	45.79	7553312.0
2008-04-02 11:30:00	QQQ	ETF	45.78	45.95	45.7625	45.89	4763629.0
2008-04-02 12:00:00	QQQ	ETF	45.89	45.97	45.76	45.78	4031302.0
2008-04-02 12:30:00	QQQ	ETF	45.78	45.82	45.6101	45.67	5628107.0
2008-04-02 13:00:00	QQQ	ETF	45.68	45.72	45.5	45.64	8618557.0
2008-04-02 13:30:00	QQQ	ETF	45.64	45.76	45.54	45.67	7260057.0
2008-04-02 14:00:00	QQQ	ETF	45.67	45.78	45.51	45.55	5288145.0

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

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