PREVIEW / etf_1min / 2018-10-25

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-10-25.parquet
  size:    3.6 MB
  rows:    185,754

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-10-25 04:00:00	SPY	ETF	267.43	267.58	267.4	267.5	1200.0
2018-10-25 04:01:00	SPY	ETF	267.48	267.65	267.48	267.65	700.0
2018-10-25 04:02:00	SPY	ETF	267.63	267.63	267.63	267.63	211.0
2018-10-25 04:03:00	SPY	ETF	267.66	267.69	267.66	267.69	669.0
2018-10-25 04:04:00	SPY	ETF	267.69	267.69	267.56	267.69	6700.0
2018-10-25 04:05:00	SPY	ETF	267.64	267.65	267.56	267.62	5350.0
2018-10-25 04:06:00	SPY	ETF	267.63	267.7	267.62	267.65	7750.0
2018-10-25 04:07:00	SPY	ETF	267.66	267.67	267.66	267.67	10900.0
2018-10-25 04:08:00	SPY	ETF	267.7	267.7	267.7	267.7	450.0
2018-10-25 04:09:00	SPY	ETF	267.72	267.72	267.72	267.72	394.0
2018-10-25 04:10:00	SPY	ETF	267.73	267.75	267.7	267.7	5100.0
2018-10-25 04:12:00	SPY	ETF	267.6	267.6	267.52	267.52	965.0
2018-10-25 04:13:00	SPY	ETF	267.49	267.49	267.49	267.49	500.0
2018-10-25 04:14:00	SPY	ETF	267.46	267.46	267.46	267.46	300.0
2018-10-25 04:15:00	SPY	ETF	267.47	267.5	267.45	267.5	4300.0
2018-10-25 04:16:00	SPY	ETF	267.44	267.62	267.44	267.62	10101.0
2018-10-25 04:17:00	SPY	ETF	267.65	267.65	267.6	267.6	750.0
2018-10-25 04:18:00	SPY	ETF	267.53	267.53	267.49	267.49	2401.0
2018-10-25 04:19:00	SPY	ETF	267.41	267.42	267.36	267.36	1710.0
2018-10-25 04:20:00	SPY	ETF	267.37	267.46	267.37	267.42	3450.0
2018-10-25 04:21:00	SPY	ETF	267.42	267.42	267.34	267.37	3100.0
2018-10-25 04:22:00	SPY	ETF	267.31	267.32	267.27	267.3	12000.0
2018-10-25 04:23:00	SPY	ETF	267.37	267.37	267.37	267.37	500.0
2018-10-25 04:24:00	SPY	ETF	267.39	267.39	267.39	267.39	2030.0
2018-10-25 04:25:00	SPY	ETF	267.49	267.57	267.44	267.49	3900.0
2018-10-25 04:26:00	SPY	ETF	267.51	267.55	267.49	267.55	800.0
2018-10-25 04:27:00	SPY	ETF	267.51	267.53	267.49	267.5	3808.0
2018-10-25 04:28:00	SPY	ETF	267.54	267.65	267.53	267.65	15200.0
2018-10-25 04:29:00	SPY	ETF	267.59	267.62	267.59	267.62	600.0
2018-10-25 04:30:00	SPY	ETF	267.65	267.65	267.65	267.65	300.0
2018-10-25 04:32:00	SPY	ETF	267.51	267.51	267.5	267.5	1100.0
2018-10-25 04:33:00	SPY	ETF	267.62	267.62	267.56	267.57	824.0
2018-10-25 04:34:00	SPY	ETF	267.57	267.57	267.57	267.57	2500.0
2018-10-25 04:35:00	SPY	ETF	267.51	267.51	267.41	267.41	3500.0
2018-10-25 04:36:00	SPY	ETF	267.32	267.32	267.3	267.3	2500.0
2018-10-25 04:37:00	SPY	ETF	267.3	267.32	267.21	267.21	7120.0
2018-10-25 04:38:00	SPY	ETF	267.2	267.25	267.2	267.24	2850.0
2018-10-25 04:39:00	SPY	ETF	267.29	267.29	267.29	267.29	1050.0
2018-10-25 04:40:00	SPY	ETF	267.32	267.32	267.3	267.3	1600.0
2018-10-25 04:41:00	SPY	ETF	267.35	267.55	267.35	267.52	15000.0
2018-10-25 04:42:00	SPY	ETF	267.52	267.52	267.49	267.49	1400.0
2018-10-25 04:43:00	SPY	ETF	267.55	267.6	267.54	267.6	6000.0
2018-10-25 04:44:00	SPY	ETF	267.64	267.64	267.64	267.64	500.0
2018-10-25 04:45:00	SPY	ETF	267.63	267.69	267.63	267.69	1500.0
2018-10-25 04:46:00	SPY	ETF	267.72	267.75	267.72	267.74	1679.0
2018-10-25 04:47:00	SPY	ETF	267.69	267.69	267.69	267.69	1200.0
2018-10-25 04:48:00	SPY	ETF	267.7	267.7	267.62	267.62	3600.0
2018-10-25 04:50:00	SPY	ETF	267.6	267.6	267.6	267.6	100.0
2018-10-25 04:51:00	SPY	ETF	267.7	267.72	267.7	267.72	400.0
2018-10-25 04:52:00	SPY	ETF	267.61	267.65	267.61	267.65	446.0

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

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