PREVIEW / etf_1min / 2018-12-18

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-12-18.parquet
  size:    4.0 MB
  rows:    201,693

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-18 04:00:00	SPY	ETF	256.37	256.45	256.37	256.45	422.0
2018-12-18 04:01:00	SPY	ETF	256.47	256.49	256.47	256.49	300.0
2018-12-18 04:02:00	SPY	ETF	256.53	256.53	256.53	256.53	500.0
2018-12-18 04:03:00	SPY	ETF	256.44	256.44	256.14	256.14	3111.0
2018-12-18 04:04:00	SPY	ETF	256.17	256.17	256.16	256.16	1300.0
2018-12-18 04:05:00	SPY	ETF	256.16	256.16	256.16	256.16	279.0
2018-12-18 04:06:00	SPY	ETF	256.05	256.1	256.05	256.06	1346.0
2018-12-18 04:07:00	SPY	ETF	256.0	256.02	255.98	255.98	2454.0
2018-12-18 04:08:00	SPY	ETF	255.99	256.13	255.97	256.13	1349.0
2018-12-18 04:09:00	SPY	ETF	256.12	256.12	256.12	256.12	150.0
2018-12-18 04:12:00	SPY	ETF	256.21	256.26	256.21	256.26	210.0
2018-12-18 04:13:00	SPY	ETF	256.26	256.3	256.26	256.3	200.0
2018-12-18 04:14:00	SPY	ETF	256.36	256.36	256.36	256.36	150.0
2018-12-18 04:15:00	SPY	ETF	256.36	256.36	256.36	256.36	100.0
2018-12-18 04:16:00	SPY	ETF	256.25	256.25	256.25	256.25	200.0
2018-12-18 04:21:00	SPY	ETF	256.01	256.01	256.01	256.01	500.0
2018-12-18 04:22:00	SPY	ETF	256.01	256.01	255.94	255.94	1880.0
2018-12-18 04:23:00	SPY	ETF	255.96	255.96	255.96	255.96	565.0
2018-12-18 04:26:00	SPY	ETF	256.25	256.28	256.12	256.12	3200.0
2018-12-18 04:28:00	SPY	ETF	256.26	256.26	256.26	256.26	170.0
2018-12-18 04:29:00	SPY	ETF	256.15	256.15	256.08	256.08	3000.0
2018-12-18 04:30:00	SPY	ETF	256.06	256.06	256.04	256.04	2010.0
2018-12-18 04:33:00	SPY	ETF	256.12	256.12	256.07	256.07	2000.0
2018-12-18 04:34:00	SPY	ETF	256.04	256.04	256.04	256.04	600.0
2018-12-18 04:36:00	SPY	ETF	256.25	256.25	256.25	256.25	1100.0
2018-12-18 04:38:00	SPY	ETF	256.27	256.32	256.27	256.32	250.0
2018-12-18 04:40:00	SPY	ETF	256.35	256.42	256.35	256.42	260.0
2018-12-18 04:41:00	SPY	ETF	256.42	256.42	256.42	256.42	200.0
2018-12-18 04:42:00	SPY	ETF	256.47	256.47	256.47	256.47	110.0
2018-12-18 04:43:00	SPY	ETF	256.47	256.51	256.47	256.51	2200.0
2018-12-18 04:44:00	SPY	ETF	256.47	256.47	256.47	256.47	800.0
2018-12-18 04:45:00	SPY	ETF	256.56	256.56	256.56	256.56	200.0
2018-12-18 04:46:00	SPY	ETF	256.58	256.58	256.58	256.58	2400.0
2018-12-18 04:47:00	SPY	ETF	256.64	256.69	256.62	256.62	1123.0
2018-12-18 04:48:00	SPY	ETF	256.68	256.73	256.68	256.72	3350.0
2018-12-18 04:49:00	SPY	ETF	256.72	256.72	256.72	256.72	150.0
2018-12-18 04:50:00	SPY	ETF	256.74	256.77	256.74	256.77	350.0
2018-12-18 04:51:00	SPY	ETF	256.77	256.77	256.74	256.77	1100.0
2018-12-18 04:52:00	SPY	ETF	256.74	256.74	256.7	256.7	2863.0
2018-12-18 04:53:00	SPY	ETF	256.67	256.67	256.63	256.63	1785.0
2018-12-18 04:54:00	SPY	ETF	256.67	256.67	256.67	256.67	420.0
2018-12-18 04:55:00	SPY	ETF	256.71	256.74	256.71	256.74	650.0
2018-12-18 04:56:00	SPY	ETF	256.78	256.82	256.78	256.8	2500.0
2018-12-18 04:57:00	SPY	ETF	256.78	256.78	256.78	256.78	1108.0
2018-12-18 04:59:00	SPY	ETF	256.73	256.73	256.73	256.73	500.0
2018-12-18 05:00:00	SPY	ETF	256.7	256.7	256.66	256.66	1100.0
2018-12-18 05:03:00	SPY	ETF	256.64	256.64	256.64	256.64	750.0
2018-12-18 05:04:00	SPY	ETF	256.67	256.67	256.67	256.67	300.0
2018-12-18 05:05:00	SPY	ETF	256.68	256.68	256.64	256.64	1850.0
2018-12-18 05:07:00	SPY	ETF	256.77	256.77	256.77	256.77	1000.0

> showing 50 of 201,693 rows — these rows as CSV

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