PREVIEW / etf_5min / 2012-06-01

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-06-01.parquet
  size:    1.0 MB
  rows:    42,031

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
2012-06-01 04:00:00	SPY	ETF	131.0	131.0	130.65	130.65	425.0
2012-06-01 04:25:00	SPY	ETF	130.6	130.6	130.6	130.6	100.0
2012-06-01 04:30:00	SPY	ETF	130.4	130.4	130.32	130.32	300.0
2012-06-01 04:40:00	SPY	ETF	130.43	130.43	130.43	130.43	200.0
2012-06-01 04:45:00	SPY	ETF	130.31	130.32	130.3	130.32	800.0
2012-06-01 04:55:00	SPY	ETF	130.3	130.3	130.17	130.17	700.0
2012-06-01 05:00:00	SPY	ETF	130.15	130.15	130.05	130.11	6500.0
2012-06-01 05:05:00	SPY	ETF	130.06	130.06	129.84	129.84	2410.0
2012-06-01 05:10:00	SPY	ETF	129.97	129.97	129.97	129.97	200.0
2012-06-01 05:15:00	SPY	ETF	129.97	130.01	129.92	129.92	3478.0
2012-06-01 05:20:00	SPY	ETF	129.93	129.93	129.93	129.93	600.0
2012-06-01 05:25:00	SPY	ETF	130.06	130.06	130.05	130.05	300.0
2012-06-01 05:30:00	SPY	ETF	130.08	130.08	129.98	129.98	726.0
2012-06-01 05:35:00	SPY	ETF	130.0	130.02	130.0	130.02	1200.0
2012-06-01 05:40:00	SPY	ETF	130.04	130.04	129.97	129.97	8862.0
2012-06-01 05:45:00	SPY	ETF	129.95	129.96	129.92	129.96	6900.0
2012-06-01 05:50:00	SPY	ETF	129.95	129.97	129.87	129.89	2500.0
2012-06-01 05:55:00	SPY	ETF	129.89	129.94	129.87	129.94	2600.0
2012-06-01 06:00:00	SPY	ETF	129.99	129.99	129.94	129.94	9000.0
2012-06-01 06:05:00	SPY	ETF	129.93	129.97	129.92	129.92	2500.0
2012-06-01 06:10:00	SPY	ETF	129.85	129.85	129.79	129.83	5680.0
2012-06-01 06:15:00	SPY	ETF	129.79	129.79	129.75	129.79	6167.0
2012-06-01 06:20:00	SPY	ETF	129.8	129.8	129.77	129.77	5000.0
2012-06-01 06:25:00	SPY	ETF	129.84	129.85	129.8	129.85	2200.0
2012-06-01 06:30:00	SPY	ETF	129.87	129.95	129.84	129.95	56223.0
2012-06-01 06:35:00	SPY	ETF	129.9	129.96	129.9	129.91	3600.0
2012-06-01 06:40:00	SPY	ETF	129.9	130.05	129.9	130.05	55890.0
2012-06-01 06:45:00	SPY	ETF	130.04	130.08	130.01	130.05	7850.0
2012-06-01 06:50:00	SPY	ETF	130.01	130.01	129.95	129.95	8200.0
2012-06-01 06:55:00	SPY	ETF	130.0	130.01	130.0	130.01	1200.0
2012-06-01 07:00:00	SPY	ETF	130.0	130.03	129.92	130.02	14832.0
2012-06-01 07:05:00	SPY	ETF	130.02	130.11	129.98	130.11	158645.0
2012-06-01 07:10:00	SPY	ETF	130.11	130.14	130.08	130.08	44793.0
2012-06-01 07:15:00	SPY	ETF	130.06	130.11	130.03	130.1	11398.0
2012-06-01 07:20:00	SPY	ETF	130.1	130.21	130.06	130.21	30787.0
2012-06-01 07:25:00	SPY	ETF	130.19	130.2	130.14	130.15	16075.0
2012-06-01 07:30:00	SPY	ETF	130.14	130.17	130.02	130.07	68494.0
2012-06-01 07:35:00	SPY	ETF	130.02	130.03	129.93	129.94	65180.0
2012-06-01 07:40:00	SPY	ETF	129.94	130.0	129.91	129.96	35460.0
2012-06-01 07:45:00	SPY	ETF	129.96	130.0	129.94	129.94	47857.0
2012-06-01 07:50:00	SPY	ETF	129.94	130.05	129.94	129.98	210800.0
2012-06-01 07:55:00	SPY	ETF	129.95	130.01	129.94	130.0	31999.0
2012-06-01 08:00:00	SPY	ETF	130.0	130.15	129.9	129.97	142421.0
2012-06-01 08:05:00	SPY	ETF	130.12	130.12	129.86	129.96	126326.0
2012-06-01 08:10:00	SPY	ETF	129.96	130.86	129.85	130.02	238216.0
2012-06-01 08:15:00	SPY	ETF	130.04	130.09	129.99	130.06	95776.0
2012-06-01 08:20:00	SPY	ETF	130.05	130.07	129.97	130.01	192721.0
2012-06-01 08:25:00	SPY	ETF	129.99	130.02	129.75	130.0	1465852.0
2012-06-01 08:30:00	SPY	ETF	129.9	129.9	128.61	129.1	3246126.0
2012-06-01 08:35:00	SPY	ETF	129.09	129.09	128.77	128.92	1640545.0

> showing 50 of 42,031 rows — these rows as CSV

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