PREVIEW / etf_5min / 2008-07-31

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-07-31.parquet
  size:    502 KB
  rows:    23,816

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-07-31 04:15:00	SPY	ETF	128.25	128.25	128.25	128.25	200.0
2008-07-31 04:35:00	SPY	ETF	128.26	128.26	128.26	128.26	7383.0
2008-07-31 05:10:00	SPY	ETF	128.29	128.29	128.29	128.29	7500.0
2008-07-31 05:20:00	SPY	ETF	128.29	128.29	128.29	128.29	100.0
2008-07-31 05:55:00	SPY	ETF	128.26	128.3	128.26	128.3	15000.0
2008-07-31 06:25:00	SPY	ETF	128.37	128.49	128.37	128.49	10300.0
2008-07-31 06:50:00	SPY	ETF	128.58	128.58	128.58	128.58	1000.0
2008-07-31 06:55:00	SPY	ETF	128.55	128.55	128.55	128.55	1000.0
2008-07-31 07:00:00	SPY	ETF	128.47	128.6	128.47	128.6	32800.0
2008-07-31 07:05:00	SPY	ETF	128.63	128.63	128.63	128.63	200.0
2008-07-31 07:10:00	SPY	ETF	128.65	128.7	128.65	128.7	75500.0
2008-07-31 07:15:00	SPY	ETF	128.69	128.8	128.69	128.8	422548.0
2008-07-31 07:20:00	SPY	ETF	128.81	128.83	128.75	128.75	151200.0
2008-07-31 07:25:00	SPY	ETF	128.76	128.78	128.76	128.76	10105.0
2008-07-31 07:30:00	SPY	ETF	128.75	128.75	128.75	128.75	1000.0
2008-07-31 07:35:00	SPY	ETF	128.75	128.8	128.71	128.8	210905.0
2008-07-31 07:40:00	SPY	ETF	128.79	128.83	128.75	128.78	172852.0
2008-07-31 07:45:00	SPY	ETF	128.79	128.81	128.75	128.77	38749.0
2008-07-31 07:50:00	SPY	ETF	128.81	128.83	128.79	128.83	23000.0
2008-07-31 07:55:00	SPY	ETF	128.83	128.88	128.8	128.83	74637.0
2008-07-31 08:00:00	SPY	ETF	128.85	128.94	128.65	128.9	114132.0
2008-07-31 08:05:00	SPY	ETF	128.91	128.95	128.82	128.9	76199.0
2008-07-31 08:10:00	SPY	ETF	128.91	128.93	128.8	128.8	172509.0
2008-07-31 08:15:00	SPY	ETF	128.8	128.91	128.77	128.88	274618.0
2008-07-31 08:20:00	SPY	ETF	128.89	129.03	128.85	128.96	435822.0
2008-07-31 08:25:00	SPY	ETF	128.97	129.08	128.67	128.94	265637.0
2008-07-31 08:30:00	SPY	ETF	128.98	128.98	127.83	127.97	6075494.0
2008-07-31 08:35:00	SPY	ETF	127.98	127.98	127.62	127.71	2045129.0
2008-07-31 08:40:00	SPY	ETF	127.71	127.8	127.66	127.77	911370.0
2008-07-31 08:45:00	SPY	ETF	127.77	127.87	127.74	127.84	797327.0
2008-07-31 08:50:00	SPY	ETF	127.83	127.83	127.71	127.83	830710.0
2008-07-31 08:55:00	SPY	ETF	127.82	127.84	127.56	127.58	1184558.0
2008-07-31 09:00:00	SPY	ETF	127.58	127.66	127.47	127.5	1157356.0
2008-07-31 09:05:00	SPY	ETF	127.49	127.51	127.24	127.29	1041258.0
2008-07-31 09:10:00	SPY	ETF	127.29	127.37	127.25	127.32	758560.0
2008-07-31 09:15:00	SPY	ETF	127.32	127.44	127.31	127.44	528748.0
2008-07-31 09:20:00	SPY	ETF	127.43	127.46	127.33	127.36	632196.0
2008-07-31 09:25:00	SPY	ETF	127.37	127.42	127.34	127.37	393954.0
2008-07-31 09:30:00	SPY	ETF	127.4	127.56	127.24	127.5375	4300488.0
2008-07-31 09:35:00	SPY	ETF	127.53	127.68	127.4	127.67	5215348.0
2008-07-31 09:40:00	SPY	ETF	127.67	127.85	127.57	127.84	9353659.0
2008-07-31 09:45:00	SPY	ETF	127.84	127.97	127.6	127.84	6701481.0
2008-07-31 09:50:00	SPY	ETF	127.85	128.26	127.84	128.21	9190958.0
2008-07-31 09:55:00	SPY	ETF	128.21	128.4787	127.88	128.05	7071911.0
2008-07-31 10:00:00	SPY	ETF	128.05	128.09	127.81	127.85	5071726.0
2008-07-31 10:05:00	SPY	ETF	127.86	128.16	127.74	127.85	6616606.0
2008-07-31 10:10:00	SPY	ETF	127.85	128.12	127.76	128.11	5720769.0
2008-07-31 10:15:00	SPY	ETF	128.11	128.23	127.94	128.05	4304832.0
2008-07-31 10:20:00	SPY	ETF	128.04	128.53	127.98	128.3	6123904.0
2008-07-31 10:25:00	SPY	ETF	128.3	128.52	128.15	128.38	3952107.0

> showing 50 of 23,816 rows — these rows as CSV

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