PREVIEW / etf_1min / 2018-06-27

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-06-27.parquet
  size:    3.2 MB
  rows:    166,793

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
2018-06-27 04:00:00	SPY	ETF	270.0	270.0	270.0	270.0	300.0
2018-06-27 04:02:00	SPY	ETF	270.11	270.19	270.11	270.19	2400.0
2018-06-27 04:03:00	SPY	ETF	270.15	270.18	270.09	270.12	15011.0
2018-06-27 04:04:00	SPY	ETF	270.18	270.18	270.09	270.1	1350.0
2018-06-27 04:05:00	SPY	ETF	270.1	270.1	270.02	270.04	2200.0
2018-06-27 04:06:00	SPY	ETF	270.12	270.22	270.12	270.22	2600.0
2018-06-27 04:07:00	SPY	ETF	270.22	270.26	270.21	270.24	3010.0
2018-06-27 04:08:00	SPY	ETF	270.24	270.31	270.24	270.27	3225.0
2018-06-27 04:09:00	SPY	ETF	270.24	270.24	270.24	270.24	1950.0
2018-06-27 04:10:00	SPY	ETF	270.11	270.11	270.11	270.11	2300.0
2018-06-27 04:11:00	SPY	ETF	270.19	270.23	270.16	270.21	4600.0
2018-06-27 04:12:00	SPY	ETF	270.24	270.24	270.24	270.24	100.0
2018-06-27 04:13:00	SPY	ETF	270.23	270.26	270.23	270.26	850.0
2018-06-27 04:15:00	SPY	ETF	270.3	270.3	270.3	270.3	100.0
2018-06-27 04:16:00	SPY	ETF	270.31	270.39	270.29	270.36	2600.0
2018-06-27 04:17:00	SPY	ETF	270.4	270.4	270.39	270.39	2000.0
2018-06-27 04:19:00	SPY	ETF	270.37	270.37	270.37	270.37	100.0
2018-06-27 04:20:00	SPY	ETF	270.32	270.32	270.3	270.3	1800.0
2018-06-27 04:21:00	SPY	ETF	270.29	270.29	270.28	270.28	1200.0
2018-06-27 04:24:00	SPY	ETF	270.3	270.3	270.28	270.28	400.0
2018-06-27 04:27:00	SPY	ETF	270.28	270.28	270.24	270.24	500.0
2018-06-27 04:28:00	SPY	ETF	270.13	270.13	270.08	270.08	2500.0
2018-06-27 04:29:00	SPY	ETF	270.03	270.06	270.01	270.03	8100.0
2018-06-27 04:30:00	SPY	ETF	269.97	269.98	269.97	269.98	250.0
2018-06-27 04:31:00	SPY	ETF	270.03	270.04	269.97	269.97	3500.0
2018-06-27 04:34:00	SPY	ETF	269.97	269.97	269.86	269.86	2000.0
2018-06-27 04:35:00	SPY	ETF	269.87	269.87	269.87	269.87	900.0
2018-06-27 04:36:00	SPY	ETF	269.88	269.92	269.88	269.91	4800.0
2018-06-27 04:37:00	SPY	ETF	269.91	269.91	269.91	269.91	550.0
2018-06-27 04:39:00	SPY	ETF	270.03	270.03	270.03	270.03	400.0
2018-06-27 04:40:00	SPY	ETF	270.03	270.03	269.93	269.93	2900.0
2018-06-27 04:41:00	SPY	ETF	269.86	269.86	269.86	269.86	400.0
2018-06-27 04:43:00	SPY	ETF	269.88	270.01	269.88	270.0	1850.0
2018-06-27 04:44:00	SPY	ETF	270.08	270.08	270.08	270.08	100.0
2018-06-27 04:49:00	SPY	ETF	269.96	269.96	269.8	269.81	6500.0
2018-06-27 04:50:00	SPY	ETF	269.77	269.77	269.77	269.77	100.0
2018-06-27 04:51:00	SPY	ETF	269.79	269.79	269.76	269.76	300.0
2018-06-27 04:52:00	SPY	ETF	269.74	269.74	269.74	269.74	670.0
2018-06-27 04:53:00	SPY	ETF	269.76	269.76	269.76	269.76	100.0
2018-06-27 04:54:00	SPY	ETF	269.71	269.71	269.68	269.68	2210.0
2018-06-27 04:56:00	SPY	ETF	269.84	269.84	269.84	269.84	900.0
2018-06-27 04:57:00	SPY	ETF	269.82	269.84	269.82	269.84	1000.0
2018-06-27 04:58:00	SPY	ETF	269.75	269.75	269.75	269.75	150.0
2018-06-27 05:00:00	SPY	ETF	269.76	269.81	269.76	269.81	200.0
2018-06-27 05:01:00	SPY	ETF	269.76	269.76	269.76	269.76	800.0
2018-06-27 05:03:00	SPY	ETF	269.93	269.93	269.93	269.93	100.0
2018-06-27 05:04:00	SPY	ETF	269.93	269.93	269.93	269.93	500.0
2018-06-27 05:05:00	SPY	ETF	269.88	269.94	269.88	269.91	2400.0
2018-06-27 05:06:00	SPY	ETF	269.89	269.96	269.89	269.96	2200.0
2018-06-27 05:07:00	SPY	ETF	269.99	269.99	269.99	269.99	150.0

> showing 50 of 166,793 rows — these rows as CSV

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