PREVIEW / etf_1min / 2014-01-02

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-01-02.parquet
  size:    2.5 MB
  rows:    130,599

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
2014-01-02 04:00:00	SPY	ETF	184.84	184.84	184.74	184.74	450.0
2014-01-02 04:01:00	SPY	ETF	184.34	184.34	184.2	184.2	370.0
2014-01-02 04:02:00	SPY	ETF	184.29	184.29	184.22	184.22	418.0
2014-01-02 04:03:00	SPY	ETF	184.19	184.22	184.19	184.22	6582.0
2014-01-02 04:04:00	SPY	ETF	184.23	184.23	184.21	184.21	4686.0
2014-01-02 04:07:00	SPY	ETF	184.21	184.21	184.2	184.2	800.0
2014-01-02 04:08:00	SPY	ETF	184.2	184.2	184.2	184.2	360.0
2014-01-02 04:18:00	SPY	ETF	183.9	183.9	183.9	183.9	390.0
2014-01-02 04:19:00	SPY	ETF	183.9	183.9	183.9	183.9	735.0
2014-01-02 04:23:00	SPY	ETF	183.9	183.9	183.9	183.9	100.0
2014-01-02 04:24:00	SPY	ETF	183.88	183.89	183.88	183.89	300.0
2014-01-02 04:25:00	SPY	ETF	183.89	183.89	183.89	183.89	100.0
2014-01-02 04:32:00	SPY	ETF	183.99	183.99	183.99	183.99	440.0
2014-01-02 04:33:00	SPY	ETF	184.19	184.19	184.19	184.19	6950.0
2014-01-02 04:39:00	SPY	ETF	184.1	184.1	184.1	184.1	100.0
2014-01-02 04:42:00	SPY	ETF	184.15	184.15	184.15	184.15	200.0
2014-01-02 05:00:00	SPY	ETF	184.0	184.0	183.92	183.92	2500.0
2014-01-02 05:02:00	SPY	ETF	184.19	184.19	184.19	184.19	2500.0
2014-01-02 05:05:00	SPY	ETF	184.25	184.25	184.25	184.25	100.0
2014-01-02 05:06:00	SPY	ETF	184.06	184.06	184.06	184.06	3000.0
2014-01-02 05:10:00	SPY	ETF	184.16	184.17	184.16	184.17	3200.0
2014-01-02 05:11:00	SPY	ETF	184.06	184.06	184.06	184.06	120.0
2014-01-02 05:21:00	SPY	ETF	184.1	184.1	184.1	184.1	200.0
2014-01-02 05:24:00	SPY	ETF	184.2	184.2	184.2	184.2	4410.0
2014-01-02 05:32:00	SPY	ETF	184.2	184.2	184.2	184.2	500.0
2014-01-02 05:34:00	SPY	ETF	184.15	184.15	184.15	184.15	600.0
2014-01-02 05:35:00	SPY	ETF	184.13	184.2	184.11	184.11	6600.0
2014-01-02 05:37:00	SPY	ETF	184.12	184.12	184.12	184.12	2000.0
2014-01-02 05:44:00	SPY	ETF	184.12	184.12	184.12	184.12	2000.0
2014-01-02 05:47:00	SPY	ETF	184.17	184.17	184.17	184.17	2500.0
2014-01-02 05:48:00	SPY	ETF	184.12	184.12	184.11	184.11	10000.0
2014-01-02 05:52:00	SPY	ETF	184.08	184.08	184.01	184.01	25000.0
2014-01-02 05:53:00	SPY	ETF	184.12	184.12	184.12	184.12	4000.0
2014-01-02 05:57:00	SPY	ETF	184.11	184.11	184.1	184.11	6500.0
2014-01-02 05:59:00	SPY	ETF	184.07	184.07	184.01	184.01	10400.0
2014-01-02 06:00:00	SPY	ETF	184.11	184.11	184.06	184.06	300.0
2014-01-02 06:01:00	SPY	ETF	184.01	184.02	184.0	184.02	11253.0
2014-01-02 06:02:00	SPY	ETF	183.92	183.92	183.75	183.75	4300.0
2014-01-02 06:03:00	SPY	ETF	184.0	184.0	184.0	184.0	1110.0
2014-01-02 06:04:00	SPY	ETF	184.0	184.0	184.0	184.0	2600.0
2014-01-02 06:05:00	SPY	ETF	184.03	184.03	184.0	184.0	27100.0
2014-01-02 06:06:00	SPY	ETF	184.0	184.0	184.0	184.0	554.0
2014-01-02 06:07:00	SPY	ETF	184.0	184.0	183.82	183.82	1897.0
2014-01-02 06:08:00	SPY	ETF	183.82	183.89	183.81	183.81	30250.0
2014-01-02 06:09:00	SPY	ETF	183.84	183.84	183.81	183.81	65958.0
2014-01-02 06:10:00	SPY	ETF	183.81	183.81	183.8	183.8	2500.0
2014-01-02 06:11:00	SPY	ETF	183.79	183.79	183.77	183.78	6475.0
2014-01-02 06:12:00	SPY	ETF	183.78	183.8	183.78	183.8	2100.0
2014-01-02 06:13:00	SPY	ETF	183.83	183.85	183.82	183.85	21275.0
2014-01-02 06:14:00	SPY	ETF	183.88	183.91	183.87	183.87	10500.0

> showing 50 of 130,599 rows — these rows as CSV

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