PREVIEW / etf_5min / 2007-04-02

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-04-02.parquet
  size:    284 KB
  rows:    13,522

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
2007-04-02 04:10:00	SPY	ETF	142.04	142.04	142.04	142.04	2200.0
2007-04-02 06:05:00	SPY	ETF	142.05	142.05	142.05	142.05	5000.0
2007-04-02 06:45:00	SPY	ETF	142.03	142.03	142.03	142.03	7500.0
2007-04-02 07:00:00	SPY	ETF	142.02	142.02	141.99	141.99	23700.0
2007-04-02 07:05:00	SPY	ETF	141.99	142.02	141.96	142.01	7700.0
2007-04-02 07:15:00	SPY	ETF	142.0	142.0	142.0	142.0	10000.0
2007-04-02 07:20:00	SPY	ETF	142.0	142.0	142.0	142.0	7500.0
2007-04-02 07:25:00	SPY	ETF	142.02	142.02	142.02	142.02	6500.0
2007-04-02 07:30:00	SPY	ETF	142.03	142.03	142.03	142.03	7900.0
2007-04-02 07:35:00	SPY	ETF	142.02	142.02	142.02	142.02	3300.0
2007-04-02 07:40:00	SPY	ETF	142.05	142.05	142.05	142.05	1000.0
2007-04-02 07:45:00	SPY	ETF	142.05	142.1	142.05	142.1	16700.0
2007-04-02 07:50:00	SPY	ETF	142.15	142.23	142.15	142.18	124300.0
2007-04-02 07:55:00	SPY	ETF	142.15	142.15	142.07	142.11	127600.0
2007-04-02 08:00:00	SPY	ETF	142.2	142.2	142.16	142.16	46200.0
2007-04-02 08:05:00	SPY	ETF	142.18	142.18	142.18	142.18	3000.0
2007-04-02 08:10:00	SPY	ETF	142.17	142.17	142.14	142.14	16700.0
2007-04-02 08:15:00	SPY	ETF	142.11	142.13	142.07	142.09	90900.0
2007-04-02 08:20:00	SPY	ETF	142.13	142.13	142.09	142.12	15100.0
2007-04-02 08:25:00	SPY	ETF	142.1	142.14	142.1	142.13	27100.0
2007-04-02 08:30:00	SPY	ETF	142.13	142.14	142.13	142.14	8100.0
2007-04-02 08:35:00	SPY	ETF	142.13	142.13	142.09	142.09	152800.0
2007-04-02 08:40:00	SPY	ETF	142.08	142.12	142.0	142.11	137400.0
2007-04-02 08:45:00	SPY	ETF	142.12	142.12	142.12	142.12	4200.0
2007-04-02 08:50:00	SPY	ETF	142.12	142.15	142.12	142.15	42600.0
2007-04-02 08:55:00	SPY	ETF	142.12	142.19	142.12	142.18	579500.0
2007-04-02 09:00:00	SPY	ETF	142.18	142.19	142.18	142.19	20200.0
2007-04-02 09:05:00	SPY	ETF	142.19	142.2	142.18	142.19	77400.0
2007-04-02 09:10:00	SPY	ETF	142.2	142.22	142.2	142.21	20300.0
2007-04-02 09:15:00	SPY	ETF	142.22	142.22	142.21	142.22	11700.0
2007-04-02 09:20:00	SPY	ETF	142.0	142.22	142.0	142.19	94100.0
2007-04-02 09:25:00	SPY	ETF	142.16	142.2	142.16	142.16	17400.0
2007-04-02 09:30:00	SPY	ETF	142.16	142.34	142.13	142.2	1405500.0
2007-04-02 09:35:00	SPY	ETF	142.19	142.32	142.14	142.16	1113400.0
2007-04-02 09:40:00	SPY	ETF	142.16	142.27	142.03	142.25	1725600.0
2007-04-02 09:45:00	SPY	ETF	142.26	142.28	142.16	142.18	886700.0
2007-04-02 09:50:00	SPY	ETF	142.17	142.24	142.15	142.2	354100.0
2007-04-02 09:55:00	SPY	ETF	142.2	142.23	142.09	142.13	1312100.0
2007-04-02 10:00:00	SPY	ETF	142.14	142.23	141.14	141.95	5349309.0
2007-04-02 10:05:00	SPY	ETF	141.95	142.15	140.89	141.69	5070982.0
2007-04-02 10:10:00	SPY	ETF	141.69	141.97	141.5	141.66	1871160.0
2007-04-02 10:15:00	SPY	ETF	141.67	141.81	141.48	141.63	2415300.0
2007-04-02 10:20:00	SPY	ETF	141.63	141.73	141.53	141.62	1410620.0
2007-04-02 10:25:00	SPY	ETF	141.61	141.71	141.59	141.68	910393.0
2007-04-02 10:30:00	SPY	ETF	141.68	141.86	141.68	141.74	2901200.0
2007-04-02 10:35:00	SPY	ETF	141.75	141.81	141.7	141.76	638100.0
2007-04-02 10:40:00	SPY	ETF	141.75	141.84	141.67	141.7	881700.0
2007-04-02 10:45:00	SPY	ETF	141.7	141.83	141.64	141.73	831875.0
2007-04-02 10:50:00	SPY	ETF	141.73	141.85	141.67	141.83	669100.0
2007-04-02 10:55:00	SPY	ETF	141.82	142.1	141.82	142.06	2572210.0

> showing 50 of 13,522 rows — these rows as CSV

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