PREVIEW / etf_1min / 2018-12-19

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-12-19.parquet
  size:    4.1 MB
  rows:    203,819

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-19 04:00:00	SPY	ETF	255.46	255.58	255.46	255.58	876.0
2018-12-19 04:01:00	SPY	ETF	255.55	255.63	255.53	255.63	1236.0
2018-12-19 04:02:00	SPY	ETF	255.61	255.61	255.61	255.61	154.0
2018-12-19 04:03:00	SPY	ETF	255.63	255.63	255.63	255.63	100.0
2018-12-19 04:08:00	SPY	ETF	255.65	255.65	255.65	255.65	300.0
2018-12-19 04:09:00	SPY	ETF	255.68	255.68	255.68	255.68	3600.0
2018-12-19 04:10:00	SPY	ETF	255.64	255.66	255.64	255.66	1150.0
2018-12-19 04:12:00	SPY	ETF	255.63	255.63	255.63	255.63	3015.0
2018-12-19 04:13:00	SPY	ETF	255.67	255.67	255.67	255.67	5691.0
2018-12-19 04:14:00	SPY	ETF	255.72	255.72	255.72	255.72	100.0
2018-12-19 04:15:00	SPY	ETF	255.73	255.77	255.73	255.77	5600.0
2018-12-19 04:16:00	SPY	ETF	255.77	255.77	255.77	255.77	1000.0
2018-12-19 04:17:00	SPY	ETF	255.82	255.82	255.82	255.82	100.0
2018-12-19 04:19:00	SPY	ETF	255.8	255.8	255.8	255.8	159.0
2018-12-19 04:27:00	SPY	ETF	255.73	255.73	255.73	255.73	1000.0
2018-12-19 04:29:00	SPY	ETF	255.77	255.77	255.76	255.76	600.0
2018-12-19 04:30:00	SPY	ETF	255.7	255.7	255.7	255.7	2000.0
2018-12-19 04:31:00	SPY	ETF	255.69	255.69	255.69	255.69	1000.0
2018-12-19 04:32:00	SPY	ETF	255.67	255.68	255.67	255.68	388.0
2018-12-19 04:34:00	SPY	ETF	255.65	255.65	255.65	255.65	169.0
2018-12-19 04:36:00	SPY	ETF	255.65	255.68	255.62	255.68	4900.0
2018-12-19 04:38:00	SPY	ETF	255.73	255.73	255.73	255.73	169.0
2018-12-19 04:39:00	SPY	ETF	255.76	255.76	255.74	255.76	4800.0
2018-12-19 04:40:00	SPY	ETF	255.79	255.79	255.79	255.79	169.0
2018-12-19 04:41:00	SPY	ETF	255.78	255.78	255.78	255.78	1200.0
2018-12-19 04:42:00	SPY	ETF	255.79	255.8	255.78	255.8	1050.0
2018-12-19 04:43:00	SPY	ETF	255.82	255.96	255.82	255.92	2907.0
2018-12-19 04:44:00	SPY	ETF	255.89	255.89	255.89	255.89	500.0
2018-12-19 04:45:00	SPY	ETF	255.9	255.9	255.9	255.9	100.0
2018-12-19 04:46:00	SPY	ETF	255.88	255.88	255.77	255.83	2238.0
2018-12-19 04:47:00	SPY	ETF	255.81	255.81	255.81	255.81	469.0
2018-12-19 04:49:00	SPY	ETF	255.85	255.94	255.85	255.94	1038.0
2018-12-19 04:50:00	SPY	ETF	255.85	255.85	255.82	255.85	1000.0
2018-12-19 04:51:00	SPY	ETF	255.85	255.85	255.83	255.83	338.0
2018-12-19 04:54:00	SPY	ETF	255.87	255.87	255.87	255.87	100.0
2018-12-19 04:56:00	SPY	ETF	255.95	255.95	255.94	255.94	1069.0
2018-12-19 04:57:00	SPY	ETF	255.94	255.94	255.94	255.94	1500.0
2018-12-19 04:58:00	SPY	ETF	255.94	255.94	255.94	255.94	500.0
2018-12-19 04:59:00	SPY	ETF	255.97	255.97	255.97	255.97	625.0
2018-12-19 05:01:00	SPY	ETF	255.93	256.0	255.93	256.0	1519.0
2018-12-19 05:02:00	SPY	ETF	256.01	256.03	256.0	256.0	4850.0
2018-12-19 05:04:00	SPY	ETF	256.05	256.05	256.05	256.05	150.0
2018-12-19 05:05:00	SPY	ETF	256.05	256.1	256.05	256.1	1469.0
2018-12-19 05:06:00	SPY	ETF	256.1	256.13	256.05	256.05	3438.0
2018-12-19 05:07:00	SPY	ETF	256.12	256.12	256.12	256.12	1000.0
2018-12-19 05:08:00	SPY	ETF	256.1	256.1	256.1	256.1	101.0
2018-12-19 05:09:00	SPY	ETF	256.13	256.13	256.13	256.13	2000.0
2018-12-19 05:10:00	SPY	ETF	256.13	256.2	256.12	256.2	3288.0
2018-12-19 05:12:00	SPY	ETF	256.2	256.2	256.2	256.2	400.0
2018-12-19 05:13:00	SPY	ETF	256.15	256.15	256.15	256.15	7600.0

> showing 50 of 203,819 rows — these rows as CSV

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