PREVIEW / etf_5min / 2008-07-02

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-07-02.parquet
  size:    540 KB
  rows:    23,944

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-02 04:45:00	SPY	ETF	128.67	128.67	128.67	128.67	1000.0
2008-07-02 05:30:00	SPY	ETF	128.73	128.73	128.73	128.73	100.0
2008-07-02 05:35:00	SPY	ETF	128.71	128.71	128.71	128.71	2000.0
2008-07-02 05:45:00	SPY	ETF	128.75	128.75	128.75	128.75	100.0
2008-07-02 05:55:00	SPY	ETF	129.0	129.0	129.0	129.0	100.0
2008-07-02 06:00:00	SPY	ETF	129.04	129.21	129.04	129.12	5000.0
2008-07-02 06:05:00	SPY	ETF	129.16	129.16	129.16	129.16	5000.0
2008-07-02 06:15:00	SPY	ETF	129.2	129.2	129.15	129.15	30500.0
2008-07-02 06:20:00	SPY	ETF	129.17	129.21	129.17	129.17	28900.0
2008-07-02 06:25:00	SPY	ETF	129.16	129.16	129.0	129.0	79100.0
2008-07-02 06:30:00	SPY	ETF	129.0	129.01	128.84	128.84	19000.0
2008-07-02 06:35:00	SPY	ETF	128.88	128.99	128.88	128.98	16000.0
2008-07-02 06:40:00	SPY	ETF	128.93	128.98	128.93	128.95	36000.0
2008-07-02 06:45:00	SPY	ETF	128.95	128.96	128.93	128.96	28900.0
2008-07-02 06:50:00	SPY	ETF	128.94	129.2	128.94	129.2	28500.0
2008-07-02 06:55:00	SPY	ETF	129.19	129.19	129.14	129.14	18100.0
2008-07-02 07:00:00	SPY	ETF	129.11	129.2	129.1	129.2	33000.0
2008-07-02 07:05:00	SPY	ETF	129.18	129.2	129.15	129.15	36600.0
2008-07-02 07:10:00	SPY	ETF	129.1	129.16	129.1	129.16	76600.0
2008-07-02 07:15:00	SPY	ETF	129.16	129.2	129.1	129.19	134200.0
2008-07-02 07:20:00	SPY	ETF	129.19	129.25	129.17	129.23	221650.0
2008-07-02 07:25:00	SPY	ETF	129.23	129.27	129.22	129.25	143000.0
2008-07-02 07:30:00	SPY	ETF	129.25	129.26	129.2	129.25	39540.0
2008-07-02 07:35:00	SPY	ETF	129.25	129.25	129.2	129.22	104959.0
2008-07-02 07:40:00	SPY	ETF	129.2	129.28	129.2	129.25	66176.0
2008-07-02 07:45:00	SPY	ETF	129.26	129.26	129.17	129.18	159700.0
2008-07-02 07:50:00	SPY	ETF	129.17	129.27	129.17	129.23	178000.0
2008-07-02 07:55:00	SPY	ETF	129.23	129.23	129.15	129.16	27900.0
2008-07-02 08:00:00	SPY	ETF	129.16	129.25	129.1	129.14	377774.0
2008-07-02 08:05:00	SPY	ETF	129.14	129.14	129.07	129.07	58104.0
2008-07-02 08:10:00	SPY	ETF	129.08	129.13	129.04	129.13	108248.0
2008-07-02 08:15:00	SPY	ETF	129.19	129.28	128.7	128.79	1704588.0
2008-07-02 08:20:00	SPY	ETF	128.79	128.99	128.78	128.97	887308.0
2008-07-02 08:25:00	SPY	ETF	128.99	129.01	128.92	129.0	193448.0
2008-07-02 08:30:00	SPY	ETF	128.96	129.01	128.84	128.88	402040.0
2008-07-02 08:35:00	SPY	ETF	128.85	128.89	128.73	128.89	280145.0
2008-07-02 08:40:00	SPY	ETF	128.89	128.95	128.84	128.95	207577.0
2008-07-02 08:45:00	SPY	ETF	128.95	128.98	127.98	128.95	151384.0
2008-07-02 08:50:00	SPY	ETF	128.96	128.98	128.83	128.83	166974.0
2008-07-02 08:55:00	SPY	ETF	128.8	128.83	128.63	128.65	666249.0
2008-07-02 09:00:00	SPY	ETF	128.66	128.85	128.63	128.76	605003.0
2008-07-02 09:05:00	SPY	ETF	128.76	128.81	128.71	128.79	613531.0
2008-07-02 09:10:00	SPY	ETF	128.79	128.85	128.72	128.81	169105.0
2008-07-02 09:15:00	SPY	ETF	128.81	128.86	128.78	128.81	129702.0
2008-07-02 09:20:00	SPY	ETF	128.8	128.82	128.74	128.75	150843.0
2008-07-02 09:25:00	SPY	ETF	128.75	128.91	128.75	128.79	917134.0
2008-07-02 09:30:00	SPY	ETF	128.79	129.0	128.78	128.93	3534806.0
2008-07-02 09:35:00	SPY	ETF	128.93	129.0	128.87	128.98	4656661.0
2008-07-02 09:40:00	SPY	ETF	128.98	129.07	128.79	128.8	2874109.0
2008-07-02 09:45:00	SPY	ETF	128.8	129.08	128.79	128.88	2835136.0

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

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