PREVIEW / etf_5min / 2009-07-02

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-02.parquet
  size:    656 KB
  rows:    28,603

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
2009-07-02 04:15:00	SPY	ETF	91.88	91.9	91.87	91.87	418.0
2009-07-02 04:20:00	SPY	ETF	91.89	91.9	91.89	91.9	20000.0
2009-07-02 05:05:00	SPY	ETF	91.86	91.86	91.86	91.86	1000.0
2009-07-02 05:25:00	SPY	ETF	91.99	91.99	91.99	91.99	200.0
2009-07-02 05:55:00	SPY	ETF	91.92	91.92	91.9	91.9	2000.0
2009-07-02 06:00:00	SPY	ETF	91.84	91.84	91.84	91.84	1000.0
2009-07-02 06:05:00	SPY	ETF	91.82	91.82	91.77	91.77	3000.0
2009-07-02 06:10:00	SPY	ETF	91.8	91.8	91.8	91.8	15000.0
2009-07-02 06:15:00	SPY	ETF	91.85	91.85	91.75	91.75	2000.0
2009-07-02 06:20:00	SPY	ETF	91.72	91.72	91.7	91.7	1200.0
2009-07-02 06:25:00	SPY	ETF	91.7	91.7	91.67	91.67	8000.0
2009-07-02 06:30:00	SPY	ETF	91.71	91.72	91.67	91.72	1400.0
2009-07-02 06:35:00	SPY	ETF	91.67	91.7	91.67	91.67	5600.0
2009-07-02 06:40:00	SPY	ETF	91.69	91.69	91.69	91.69	1200.0
2009-07-02 06:45:00	SPY	ETF	91.7	91.7	91.7	91.7	5000.0
2009-07-02 06:50:00	SPY	ETF	91.71	91.72	91.67	91.68	3200.0
2009-07-02 07:00:00	SPY	ETF	91.72	91.78	91.72	91.78	21000.0
2009-07-02 07:05:00	SPY	ETF	91.77	91.77	91.72	91.75	7020.0
2009-07-02 07:10:00	SPY	ETF	91.73	91.76	91.73	91.73	108894.0
2009-07-02 07:15:00	SPY	ETF	91.76	91.78	91.73	91.77	65300.0
2009-07-02 07:20:00	SPY	ETF	91.78	91.78	91.7	91.73	232700.0
2009-07-02 07:25:00	SPY	ETF	91.72	91.77	91.72	91.77	17000.0
2009-07-02 07:30:00	SPY	ETF	91.78	91.78	91.76	91.77	774.0
2009-07-02 07:35:00	SPY	ETF	91.77	91.82	91.77	91.8	143818.0
2009-07-02 07:40:00	SPY	ETF	91.78	91.85	91.78	91.85	45800.0
2009-07-02 07:45:00	SPY	ETF	91.85	91.94	91.85	91.92	99435.0
2009-07-02 07:50:00	SPY	ETF	91.94	91.95	91.92	91.93	100499.0
2009-07-02 07:55:00	SPY	ETF	91.94	92.0	91.93	92.0	23905.0
2009-07-02 08:00:00	SPY	ETF	91.99	91.99	91.72	91.9	283864.0
2009-07-02 08:05:00	SPY	ETF	91.91	91.92	91.86	91.88	516848.0
2009-07-02 08:10:00	SPY	ETF	91.88	91.9	91.86	91.86	77630.0
2009-07-02 08:15:00	SPY	ETF	91.86	91.86	91.73	91.77	270297.0
2009-07-02 08:20:00	SPY	ETF	91.77	91.81	91.73	91.74	237549.0
2009-07-02 08:25:00	SPY	ETF	91.74	91.92	91.74	91.88	626679.0
2009-07-02 08:30:00	SPY	ETF	91.86	91.86	91.26	91.35	5412717.0
2009-07-02 08:35:00	SPY	ETF	91.36	91.37	91.01	91.16	3314186.0
2009-07-02 08:40:00	SPY	ETF	91.16	91.3	91.1	91.23	1757179.0
2009-07-02 08:45:00	SPY	ETF	91.21	91.23	90.96	91.03	965043.0
2009-07-02 08:50:00	SPY	ETF	91.03	91.22	90.99	91.21	1396765.0
2009-07-02 08:55:00	SPY	ETF	91.2	91.23	91.14	91.14	210836.0
2009-07-02 09:00:00	SPY	ETF	91.14	91.14	91.0	91.04	646471.0
2009-07-02 09:05:00	SPY	ETF	91.04	91.09	90.96	91.06	434482.0
2009-07-02 09:10:00	SPY	ETF	91.06	91.08	90.93	91.08	422896.0
2009-07-02 09:15:00	SPY	ETF	91.08	91.09	91.01	91.06	192562.0
2009-07-02 09:20:00	SPY	ETF	91.07	91.16	91.06	91.12	282178.0
2009-07-02 09:25:00	SPY	ETF	91.12	91.15	91.1	91.13	269347.0
2009-07-02 09:30:00	SPY	ETF	91.13	91.16	90.69	90.8	6213561.0
2009-07-02 09:35:00	SPY	ETF	90.8	90.83	90.56	90.61	5299316.0
2009-07-02 09:40:00	SPY	ETF	90.6	90.66	90.5	90.61	6505681.0
2009-07-02 09:45:00	SPY	ETF	90.61	90.7	90.52	90.7	3185799.0

> showing 50 of 28,603 rows — these rows as CSV

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