PREVIEW / etf_1min / 2018-04-06

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-04-06.parquet
  size:    3.1 MB
  rows:    159,220

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-04-06 04:00:00	SPY	ETF	263.23	263.23	263.23	263.23	529.0
2018-04-06 04:02:00	SPY	ETF	263.44	263.53	263.44	263.53	1306.0
2018-04-06 04:03:00	SPY	ETF	263.56	263.56	263.52	263.52	800.0
2018-04-06 04:04:00	SPY	ETF	263.45	263.45	263.45	263.45	235.0
2018-04-06 04:05:00	SPY	ETF	263.49	263.53	263.49	263.53	1341.0
2018-04-06 04:06:00	SPY	ETF	263.53	263.53	263.46	263.46	1900.0
2018-04-06 04:07:00	SPY	ETF	263.4	263.44	263.4	263.44	500.0
2018-04-06 04:09:00	SPY	ETF	263.34	263.34	263.34	263.34	100.0
2018-04-06 04:11:00	SPY	ETF	263.43	263.43	263.43	263.43	100.0
2018-04-06 04:12:00	SPY	ETF	263.5	263.5	263.5	263.5	135.0
2018-04-06 04:14:00	SPY	ETF	263.47	263.47	263.47	263.47	300.0
2018-04-06 04:20:00	SPY	ETF	263.35	263.35	263.35	263.35	510.0
2018-04-06 04:21:00	SPY	ETF	263.4	263.4	263.4	263.4	400.0
2018-04-06 04:22:00	SPY	ETF	263.44	263.44	263.44	263.44	200.0
2018-04-06 04:23:00	SPY	ETF	263.41	263.41	263.4	263.4	500.0
2018-04-06 04:24:00	SPY	ETF	263.46	263.46	263.46	263.46	210.0
2018-04-06 04:25:00	SPY	ETF	263.41	263.41	263.4	263.4	200.0
2018-04-06 04:28:00	SPY	ETF	263.49	263.59	263.49	263.59	1169.0
2018-04-06 04:29:00	SPY	ETF	263.69	263.69	263.69	263.69	340.0
2018-04-06 04:30:00	SPY	ETF	263.64	263.64	263.64	263.64	241.0
2018-04-06 04:31:00	SPY	ETF	263.67	263.67	263.67	263.67	300.0
2018-04-06 04:32:00	SPY	ETF	263.59	263.59	263.59	263.59	300.0
2018-04-06 04:33:00	SPY	ETF	263.59	263.59	263.59	263.59	100.0
2018-04-06 04:35:00	SPY	ETF	263.58	263.58	263.58	263.58	591.0
2018-04-06 04:37:00	SPY	ETF	263.53	263.54	263.53	263.54	4000.0
2018-04-06 04:38:00	SPY	ETF	263.5	263.51	263.5	263.51	4100.0
2018-04-06 04:39:00	SPY	ETF	263.61	263.61	263.61	263.61	1400.0
2018-04-06 04:45:00	SPY	ETF	263.67	263.67	263.67	263.67	541.0
2018-04-06 04:48:00	SPY	ETF	263.7	263.7	263.7	263.7	651.0
2018-04-06 04:49:00	SPY	ETF	263.7	263.7	263.7	263.7	2000.0
2018-04-06 04:52:00	SPY	ETF	263.71	263.71	263.71	263.71	500.0
2018-04-06 04:55:00	SPY	ETF	263.63	263.63	263.63	263.63	141.0
2018-04-06 05:00:00	SPY	ETF	263.65	263.65	263.65	263.65	241.0
2018-04-06 05:05:00	SPY	ETF	263.51	263.51	263.48	263.48	1541.0
2018-04-06 05:06:00	SPY	ETF	263.4	263.4	263.4	263.4	400.0
2018-04-06 05:07:00	SPY	ETF	263.39	263.41	263.39	263.41	1030.0
2018-04-06 05:10:00	SPY	ETF	263.53	263.53	263.53	263.53	641.0
2018-04-06 05:11:00	SPY	ETF	263.53	263.53	263.53	263.53	1235.0
2018-04-06 05:13:00	SPY	ETF	263.55	263.55	263.55	263.55	500.0
2018-04-06 05:14:00	SPY	ETF	263.56	263.6	263.56	263.6	700.0
2018-04-06 05:17:00	SPY	ETF	263.63	263.63	263.63	263.63	3000.0
2018-04-06 05:19:00	SPY	ETF	263.68	263.68	263.68	263.68	325.0
2018-04-06 05:21:00	SPY	ETF	263.83	263.83	263.83	263.83	300.0
2018-04-06 05:22:00	SPY	ETF	263.8	263.86	263.8	263.86	1061.0
2018-04-06 05:23:00	SPY	ETF	263.83	263.83	263.83	263.83	800.0
2018-04-06 05:24:00	SPY	ETF	263.78	263.79	263.78	263.78	1800.0
2018-04-06 05:25:00	SPY	ETF	263.78	263.78	263.78	263.78	341.0
2018-04-06 05:26:00	SPY	ETF	263.76	263.76	263.76	263.76	700.0
2018-04-06 05:27:00	SPY	ETF	263.73	263.76	263.73	263.76	1400.0
2018-04-06 05:28:00	SPY	ETF	263.76	263.78	263.76	263.78	600.0

> showing 50 of 159,220 rows — these rows as CSV

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