PREVIEW / etf_30min / 2008-09-02

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-02.parquet
  size:    177 KB
  rows:    6,102

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-09-02 04:00:00	SPY	ETF	128.8	129.6	128.6	129.6	500.0
2008-09-02 05:30:00	SPY	ETF	129.55	129.55	129.55	129.55	5100.0
2008-09-02 06:00:00	SPY	ETF	129.65	129.65	129.63	129.63	25100.0
2008-09-02 06:30:00	SPY	ETF	129.63	129.65	129.51	129.57	327600.0
2008-09-02 07:00:00	SPY	ETF	129.51	129.7	129.5	129.61	565850.0
2008-09-02 07:30:00	SPY	ETF	129.61	129.73	129.5	129.71	530175.0
2008-09-02 08:00:00	SPY	ETF	129.71	129.96	128.57	129.88	4634595.0
2008-09-02 08:30:00	SPY	ETF	129.88	129.93	129.8	129.85	458461.0
2008-09-02 09:00:00	SPY	ETF	129.85	130.1	128.9	130.06	3443746.0
2008-09-02 09:30:00	SPY	ETF	130.06	130.71	130.01	130.32	28061249.0
2008-09-02 10:00:00	SPY	ETF	130.32	130.58	129.94	130.07	24889355.0
2008-09-02 10:30:00	SPY	ETF	130.07	130.09	129.49	129.799	17543960.0
2008-09-02 11:00:00	SPY	ETF	129.79	129.9126	129.58	129.8099	7743895.0
2008-09-02 11:30:00	SPY	ETF	129.8	130.04	129.63	129.66	9083694.0
2008-09-02 12:00:00	SPY	ETF	129.66	130.2	129.07	129.1295	11240396.0
2008-09-02 12:30:00	SPY	ETF	129.13	129.15	128.81	128.98	15254455.0
2008-09-02 13:00:00	SPY	ETF	128.98	129.17	128.91	129.11	8414239.0
2008-09-02 13:30:00	SPY	ETF	129.12	129.28	128.3	128.38	18970260.0
2008-09-02 14:00:00	SPY	ETF	128.39	128.52	128.0	128.1286	23786699.0
2008-09-02 14:30:00	SPY	ETF	128.12	128.34	127.56	127.69	18486116.0
2008-09-02 15:00:00	SPY	ETF	127.69	128.04	127.52	127.96	19906317.0
2008-09-02 15:30:00	SPY	ETF	127.96	128.15	127.75	128.09	25814544.0
2008-09-02 16:00:00	SPY	ETF	128.1386	128.4988	127.97	127.99	4567170.0
2008-09-02 16:30:00	SPY	ETF	128.0	128.623	127.95	128.623	2089834.0
2008-09-02 17:00:00	SPY	ETF	128.0	128.0912	127.98	128.0	43300.0
2008-09-02 17:30:00	SPY	ETF	127.98	127.98	127.93	127.95	3709.0
2008-09-02 18:00:00	SPY	ETF	127.98	127.99	127.9	127.93	27967.0
2008-09-02 18:30:00	SPY	ETF	127.95	127.95	127.89	127.89	25650.0
2008-09-02 19:00:00	SPY	ETF	127.87	127.87	127.84	127.84	5675.0
2008-09-02 19:30:00	SPY	ETF	127.92	128.02	127.92	128.02	60025.0
2008-09-02 04:00:00	QQQ	ETF	45.9	46.2	45.9	46.2	300.0
2008-09-02 04:30:00	QQQ	ETF	46.25	46.4	46.25	46.4	1000.0
2008-09-02 05:00:00	QQQ	ETF	46.45	46.5	46.45	46.5	590.0
2008-09-02 06:00:00	QQQ	ETF	46.49	46.56	46.49	46.56	1810.0
2008-09-02 06:30:00	QQQ	ETF	46.54	46.7	46.27	46.7	4000.0
2008-09-02 07:00:00	QQQ	ETF	46.56	46.63	45.65	46.61	128034.0
2008-09-02 07:30:00	QQQ	ETF	46.6	46.6	46.54	46.6	314798.0
2008-09-02 08:00:00	QQQ	ETF	46.59	46.84	46.12	46.83	988621.0
2008-09-02 08:30:00	QQQ	ETF	46.82	46.83	46.64	46.72	453026.0
2008-09-02 09:00:00	QQQ	ETF	46.72	46.91	46.72	46.86	1900177.0
2008-09-02 09:30:00	QQQ	ETF	46.86	47.08	46.72	46.93	26249363.0
2008-09-02 10:00:00	QQQ	ETF	46.93	47.005	46.68	46.75	15294022.0
2008-09-02 10:30:00	QQQ	ETF	46.75	46.79	46.51	46.61	9656933.0
2008-09-02 11:00:00	QQQ	ETF	46.61	46.66	46.53	46.59	5387556.0
2008-09-02 11:30:00	QQQ	ETF	46.59	46.68	46.48	46.5099	4304292.0
2008-09-02 12:00:00	QQQ	ETF	46.5085	46.54	46.26	46.29	5322538.0
2008-09-02 12:30:00	QQQ	ETF	46.28	46.31	46.13	46.2299	9582709.0
2008-09-02 13:00:00	QQQ	ETF	46.22	46.28	46.14	46.2	4212156.0
2008-09-02 13:30:00	QQQ	ETF	46.21	46.27	45.59	45.65	25878392.0
2008-09-02 14:00:00	QQQ	ETF	45.65	45.76	45.49	45.56	14092980.0

> showing 50 of 6,102 rows — these rows as CSV

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