PREVIEW / etf_1min / 2018-01-30

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-01-30.parquet
  size:    3.6 MB
  rows:    185,859

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-01-30 04:00:00	SPY	ETF	283.68	283.68	283.68	283.68	1682.0
2018-01-30 04:01:00	SPY	ETF	283.56	283.56	283.56	283.56	139.0
2018-01-30 04:02:00	SPY	ETF	283.51	283.51	283.31	283.31	1158.0
2018-01-30 04:03:00	SPY	ETF	283.41	283.41	283.41	283.41	250.0
2018-01-30 04:16:00	SPY	ETF	283.78	283.78	283.76	283.76	1100.0
2018-01-30 04:28:00	SPY	ETF	283.73	283.73	283.73	283.73	400.0
2018-01-30 04:32:00	SPY	ETF	283.75	283.75	283.75	283.75	900.0
2018-01-30 04:33:00	SPY	ETF	283.73	283.73	283.73	283.73	300.0
2018-01-30 04:34:00	SPY	ETF	283.6	283.6	283.58	283.58	2804.0
2018-01-30 04:38:00	SPY	ETF	283.73	283.73	283.73	283.73	350.0
2018-01-30 04:40:00	SPY	ETF	283.75	283.75	283.75	283.75	1000.0
2018-01-30 04:41:00	SPY	ETF	283.74	283.74	283.74	283.74	450.0
2018-01-30 04:42:00	SPY	ETF	283.74	283.74	283.71	283.71	300.0
2018-01-30 04:46:00	SPY	ETF	283.71	283.71	283.71	283.71	300.0
2018-01-30 04:48:00	SPY	ETF	283.71	283.74	283.71	283.73	2406.0
2018-01-30 04:49:00	SPY	ETF	283.71	283.71	283.71	283.71	300.0
2018-01-30 04:52:00	SPY	ETF	283.79	283.79	283.79	283.79	300.0
2018-01-30 04:53:00	SPY	ETF	283.81	283.84	283.81	283.84	1035.0
2018-01-30 04:55:00	SPY	ETF	283.8	283.8	283.8	283.8	200.0
2018-01-30 04:56:00	SPY	ETF	283.76	283.79	283.76	283.79	700.0
2018-01-30 05:00:00	SPY	ETF	283.89	283.89	283.89	283.89	500.0
2018-01-30 05:01:00	SPY	ETF	283.89	283.89	283.85	283.85	800.0
2018-01-30 05:02:00	SPY	ETF	283.89	283.89	283.89	283.89	600.0
2018-01-30 05:03:00	SPY	ETF	283.89	283.89	283.89	283.89	400.0
2018-01-30 05:04:00	SPY	ETF	283.89	283.89	283.89	283.89	300.0
2018-01-30 05:05:00	SPY	ETF	283.85	283.85	283.85	283.85	300.0
2018-01-30 05:08:00	SPY	ETF	283.86	283.86	283.84	283.84	1100.0
2018-01-30 05:11:00	SPY	ETF	283.72	283.72	283.72	283.72	100.0
2018-01-30 05:12:00	SPY	ETF	283.68	283.68	283.68	283.68	100.0
2018-01-30 05:14:00	SPY	ETF	283.6	283.64	283.6	283.64	600.0
2018-01-30 05:15:00	SPY	ETF	283.62	283.64	283.59	283.59	40699.0
2018-01-30 05:16:00	SPY	ETF	283.57	283.6	283.55	283.55	37901.0
2018-01-30 05:17:00	SPY	ETF	283.55	283.55	283.54	283.54	6000.0
2018-01-30 05:18:00	SPY	ETF	283.54	283.66	283.54	283.66	20800.0
2018-01-30 05:19:00	SPY	ETF	283.7	283.71	283.7	283.71	2500.0
2018-01-30 05:21:00	SPY	ETF	283.76	283.76	283.71	283.71	900.0
2018-01-30 05:22:00	SPY	ETF	283.71	283.71	283.68	283.68	800.0
2018-01-30 05:25:00	SPY	ETF	283.59	283.59	283.59	283.59	350.0
2018-01-30 05:26:00	SPY	ETF	283.59	283.59	283.59	283.59	200.0
2018-01-30 05:29:00	SPY	ETF	283.52	283.52	283.52	283.52	3000.0
2018-01-30 05:30:00	SPY	ETF	283.51	283.51	283.51	283.51	300.0
2018-01-30 05:31:00	SPY	ETF	283.51	283.51	283.51	283.51	205.0
2018-01-30 05:32:00	SPY	ETF	283.45	283.45	283.45	283.45	201.0
2018-01-30 05:33:00	SPY	ETF	283.49	283.49	283.49	283.49	300.0
2018-01-30 05:37:00	SPY	ETF	283.51	283.51	283.51	283.51	300.0
2018-01-30 05:41:00	SPY	ETF	283.47	283.47	283.47	283.47	300.0
2018-01-30 05:46:00	SPY	ETF	283.5	283.5	283.5	283.5	100.0
2018-01-30 05:48:00	SPY	ETF	283.5	283.5	283.5	283.5	600.0
2018-01-30 05:49:00	SPY	ETF	283.52	283.52	283.52	283.52	300.0
2018-01-30 05:50:00	SPY	ETF	283.55	283.55	283.55	283.55	900.0

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

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