PREVIEW / etf_1min / 2018-12-28

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-12-28.parquet
  size:    4.4 MB
  rows:    222,185

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-12-28 04:00:00	SPY	ETF	248.9	248.9	248.9	248.9	494.0
2018-12-28 04:02:00	SPY	ETF	248.68	248.75	248.68	248.71	2600.0
2018-12-28 04:03:00	SPY	ETF	248.77	248.78	248.7	248.78	7138.0
2018-12-28 04:06:00	SPY	ETF	248.7	248.7	248.58	248.58	1680.0
2018-12-28 04:08:00	SPY	ETF	248.67	248.67	248.67	248.67	200.0
2018-12-28 04:09:00	SPY	ETF	248.74	248.78	248.74	248.78	837.0
2018-12-28 04:10:00	SPY	ETF	248.74	248.74	248.74	248.74	200.0
2018-12-28 04:12:00	SPY	ETF	248.74	248.85	248.74	248.85	1992.0
2018-12-28 04:13:00	SPY	ETF	248.88	248.95	248.88	248.9	1600.0
2018-12-28 04:14:00	SPY	ETF	248.88	248.88	248.82	248.82	914.0
2018-12-28 04:15:00	SPY	ETF	248.78	248.78	248.78	248.78	169.0
2018-12-28 04:16:00	SPY	ETF	248.76	248.76	248.66	248.66	2018.0
2018-12-28 04:17:00	SPY	ETF	248.67	248.67	248.67	248.67	994.0
2018-12-28 04:18:00	SPY	ETF	248.7	248.7	248.7	248.7	204.0
2018-12-28 04:19:00	SPY	ETF	248.79	248.79	248.77	248.77	725.0
2018-12-28 04:20:00	SPY	ETF	248.83	248.83	248.74	248.74	850.0
2018-12-28 04:21:00	SPY	ETF	248.74	248.74	248.7	248.7	338.0
2018-12-28 04:22:00	SPY	ETF	248.67	248.67	248.67	248.67	131.0
2018-12-28 04:23:00	SPY	ETF	248.75	248.75	248.75	248.75	100.0
2018-12-28 04:25:00	SPY	ETF	248.78	248.78	248.7	248.7	507.0
2018-12-28 04:26:00	SPY	ETF	248.66	248.66	248.66	248.66	169.0
2018-12-28 04:27:00	SPY	ETF	248.68	248.68	248.68	248.68	100.0
2018-12-28 04:28:00	SPY	ETF	248.78	248.78	248.77	248.77	600.0
2018-12-28 04:29:00	SPY	ETF	248.8	248.8	248.77	248.77	2469.0
2018-12-28 04:31:00	SPY	ETF	248.82	248.82	248.82	248.82	169.0
2018-12-28 04:32:00	SPY	ETF	248.8	248.8	248.79	248.8	919.0
2018-12-28 04:33:00	SPY	ETF	248.82	248.82	248.82	248.82	169.0
2018-12-28 04:34:00	SPY	ETF	248.84	248.84	248.84	248.84	193.0
2018-12-28 04:35:00	SPY	ETF	248.86	248.89	248.84	248.84	2648.0
2018-12-28 04:36:00	SPY	ETF	248.82	248.82	248.71	248.71	1742.0
2018-12-28 04:38:00	SPY	ETF	248.84	248.9	248.84	248.9	707.0
2018-12-28 04:39:00	SPY	ETF	248.92	248.98	248.92	248.97	1629.0
2018-12-28 04:40:00	SPY	ETF	248.99	248.99	248.99	248.99	564.0
2018-12-28 04:41:00	SPY	ETF	248.94	248.94	248.94	248.94	169.0
2018-12-28 04:42:00	SPY	ETF	248.93	248.93	248.85	248.85	497.0
2018-12-28 04:43:00	SPY	ETF	248.83	248.83	248.82	248.82	2038.0
2018-12-28 04:44:00	SPY	ETF	248.8	248.8	248.8	248.8	269.0
2018-12-28 04:45:00	SPY	ETF	248.79	248.79	248.66	248.66	3765.0
2018-12-28 04:47:00	SPY	ETF	248.82	248.82	248.81	248.81	569.0
2018-12-28 04:48:00	SPY	ETF	248.84	248.89	248.84	248.89	1142.0
2018-12-28 04:50:00	SPY	ETF	248.94	248.99	248.94	248.99	2442.0
2018-12-28 04:51:00	SPY	ETF	249.0	249.0	249.0	249.0	210.0
2018-12-28 04:54:00	SPY	ETF	249.04	249.07	249.04	249.07	438.0
2018-12-28 04:55:00	SPY	ETF	249.1	249.1	249.1	249.1	659.0
2018-12-28 04:56:00	SPY	ETF	249.12	249.12	249.12	249.12	100.0
2018-12-28 04:57:00	SPY	ETF	249.2	249.2	249.2	249.2	385.0
2018-12-28 04:58:00	SPY	ETF	249.2	249.28	249.2	249.28	713.0
2018-12-28 05:00:00	SPY	ETF	249.25	249.32	249.25	249.32	600.0
2018-12-28 05:01:00	SPY	ETF	249.31	249.32	249.31	249.32	369.0
2018-12-28 05:02:00	SPY	ETF	249.36	249.42	249.36	249.42	801.0

> showing 50 of 222,185 rows — these rows as CSV

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