PREVIEW / etf_1min / 2018-10-30

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-10-30.parquet
  size:    3.5 MB
  rows:    186,703

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-10-30 04:00:00	SPY	ETF	265.22	265.22	265.22	265.22	442.0
2018-10-30 04:01:00	SPY	ETF	265.34	265.34	265.34	265.34	130.0
2018-10-30 04:02:00	SPY	ETF	265.31	265.31	265.31	265.31	137.0
2018-10-30 04:04:00	SPY	ETF	265.27	265.28	265.27	265.28	1068.0
2018-10-30 04:05:00	SPY	ETF	265.4	265.4	265.4	265.4	100.0
2018-10-30 04:06:00	SPY	ETF	265.32	265.32	265.32	265.32	175.0
2018-10-30 04:08:00	SPY	ETF	265.34	265.34	265.15	265.15	1200.0
2018-10-30 04:09:00	SPY	ETF	265.21	265.21	265.21	265.21	400.0
2018-10-30 04:11:00	SPY	ETF	265.26	265.26	265.26	265.26	200.0
2018-10-30 04:12:00	SPY	ETF	265.3	265.3	265.16	265.16	3203.0
2018-10-30 04:13:00	SPY	ETF	265.35	265.35	265.35	265.35	100.0
2018-10-30 04:14:00	SPY	ETF	265.2	265.23	265.2	265.23	710.0
2018-10-30 04:15:00	SPY	ETF	265.23	265.25	265.23	265.25	600.0
2018-10-30 04:16:00	SPY	ETF	265.18	265.18	265.16	265.18	600.0
2018-10-30 04:17:00	SPY	ETF	265.16	265.16	265.07	265.07	800.0
2018-10-30 04:18:00	SPY	ETF	265.04	265.08	264.98	265.0	1875.0
2018-10-30 04:20:00	SPY	ETF	265.17	265.19	265.17	265.19	700.0
2018-10-30 04:21:00	SPY	ETF	265.25	265.29	265.24	265.24	547.0
2018-10-30 04:22:00	SPY	ETF	265.29	265.4	265.29	265.38	6475.0
2018-10-30 04:23:00	SPY	ETF	265.42	265.57	265.42	265.57	7930.0
2018-10-30 04:24:00	SPY	ETF	265.49	265.6	265.49	265.6	3800.0
2018-10-30 04:26:00	SPY	ETF	265.73	265.74	265.68	265.74	10103.0
2018-10-30 04:27:00	SPY	ETF	265.75	265.78	265.75	265.78	300.0
2018-10-30 04:28:00	SPY	ETF	265.75	265.75	265.7	265.7	470.0
2018-10-30 04:30:00	SPY	ETF	265.61	265.63	265.61	265.63	600.0
2018-10-30 04:31:00	SPY	ETF	265.6	265.6	265.51	265.52	800.0
2018-10-30 04:32:00	SPY	ETF	265.51	265.51	265.51	265.51	254.0
2018-10-30 04:34:00	SPY	ETF	265.5	265.5	265.5	265.5	500.0
2018-10-30 04:35:00	SPY	ETF	265.41	265.41	265.41	265.41	510.0
2018-10-30 04:36:00	SPY	ETF	265.41	265.41	265.38	265.38	300.0
2018-10-30 04:37:00	SPY	ETF	265.31	265.35	265.3	265.3	1400.0
2018-10-30 04:38:00	SPY	ETF	265.24	265.3	265.24	265.3	470.0
2018-10-30 04:40:00	SPY	ETF	265.35	265.35	265.35	265.35	900.0
2018-10-30 04:41:00	SPY	ETF	265.35	265.35	265.28	265.28	1100.0
2018-10-30 04:43:00	SPY	ETF	265.35	265.38	265.35	265.38	2100.0
2018-10-30 04:45:00	SPY	ETF	265.26	265.26	265.21	265.21	800.0
2018-10-30 04:46:00	SPY	ETF	265.17	265.17	265.13	265.13	400.0
2018-10-30 04:47:00	SPY	ETF	265.1	265.1	265.1	265.1	100.0
2018-10-30 04:50:00	SPY	ETF	265.12	265.12	265.12	265.12	3200.0
2018-10-30 04:51:00	SPY	ETF	265.21	265.21	265.21	265.21	5000.0
2018-10-30 04:58:00	SPY	ETF	265.15	265.18	265.15	265.18	400.0
2018-10-30 05:00:00	SPY	ETF	265.02	265.02	264.92	264.92	600.0
2018-10-30 05:03:00	SPY	ETF	265.02	265.02	265.01	265.01	1500.0
2018-10-30 05:04:00	SPY	ETF	265.0	265.0	265.0	265.0	500.0
2018-10-30 05:08:00	SPY	ETF	264.78	264.78	264.68	264.68	2200.0
2018-10-30 05:11:00	SPY	ETF	264.66	264.66	264.66	264.66	1000.0
2018-10-30 05:12:00	SPY	ETF	264.67	264.67	264.67	264.67	1000.0
2018-10-30 05:13:00	SPY	ETF	264.7	264.7	264.42	264.43	5454.0
2018-10-30 05:14:00	SPY	ETF	264.48	264.48	264.43	264.43	1800.0
2018-10-30 05:15:00	SPY	ETF	264.51	264.51	264.48	264.49	2700.0

> showing 50 of 186,703 rows — these rows as CSV

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