PREVIEW / etf_1min / 2019-03-22

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-03-22.parquet
  size:    3.5 MB
  rows:    189,308

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
2019-03-22 04:02:00	SPY	ETF	284.73	284.73	284.73	284.73	601.0
2019-03-22 04:03:00	SPY	ETF	284.68	284.72	284.68	284.72	550.0
2019-03-22 04:06:00	SPY	ETF	284.77	284.77	284.77	284.77	100.0
2019-03-22 04:13:00	SPY	ETF	284.86	284.86	284.86	284.86	600.0
2019-03-22 04:16:00	SPY	ETF	284.68	284.72	284.68	284.72	2550.0
2019-03-22 04:19:00	SPY	ETF	284.81	284.81	284.81	284.81	300.0
2019-03-22 04:30:00	SPY	ETF	284.67	284.67	284.5	284.5	4710.0
2019-03-22 04:31:00	SPY	ETF	284.46	284.49	284.35	284.35	766.0
2019-03-22 04:32:00	SPY	ETF	284.25	284.25	283.99	284.07	6702.0
2019-03-22 04:34:00	SPY	ETF	284.21	284.21	284.19	284.19	465.0
2019-03-22 04:35:00	SPY	ETF	284.1	284.1	284.04	284.04	3327.0
2019-03-22 04:36:00	SPY	ETF	284.04	284.04	284.04	284.04	660.0
2019-03-22 04:38:00	SPY	ETF	283.96	283.96	283.96	283.96	502.0
2019-03-22 04:45:00	SPY	ETF	283.84	283.84	283.84	283.84	300.0
2019-03-22 04:46:00	SPY	ETF	283.73	283.73	283.7	283.7	386.0
2019-03-22 04:47:00	SPY	ETF	283.72	283.72	283.69	283.69	655.0
2019-03-22 04:49:00	SPY	ETF	283.6	283.6	283.54	283.54	827.0
2019-03-22 04:50:00	SPY	ETF	283.63	283.63	283.63	283.63	300.0
2019-03-22 04:52:00	SPY	ETF	283.63	283.63	283.5	283.5	607.0
2019-03-22 04:53:00	SPY	ETF	283.48	283.48	283.44	283.45	1788.0
2019-03-22 04:54:00	SPY	ETF	283.42	283.42	283.42	283.42	401.0
2019-03-22 04:56:00	SPY	ETF	283.52	283.52	283.52	283.52	3001.0
2019-03-22 04:59:00	SPY	ETF	283.46	283.46	283.46	283.46	2004.0
2019-03-22 05:00:00	SPY	ETF	283.6	283.6	283.6	283.6	100.0
2019-03-22 05:01:00	SPY	ETF	283.65	283.65	283.65	283.65	1000.0
2019-03-22 05:03:00	SPY	ETF	283.92	283.92	283.92	283.92	100.0
2019-03-22 05:07:00	SPY	ETF	283.77	283.77	283.77	283.77	1000.0
2019-03-22 05:09:00	SPY	ETF	283.69	283.75	283.69	283.75	500.0
2019-03-22 05:13:00	SPY	ETF	283.7	283.76	283.7	283.76	800.0
2019-03-22 05:14:00	SPY	ETF	283.74	283.74	283.74	283.74	600.0
2019-03-22 05:15:00	SPY	ETF	283.74	283.74	283.7	283.7	700.0
2019-03-22 05:18:00	SPY	ETF	283.49	283.52	283.49	283.52	600.0
2019-03-22 05:20:00	SPY	ETF	283.51	283.51	283.51	283.51	300.0
2019-03-22 05:21:00	SPY	ETF	283.42	283.42	283.4	283.4	308.0
2019-03-22 05:22:00	SPY	ETF	283.38	283.38	283.38	283.38	101.0
2019-03-22 05:24:00	SPY	ETF	283.48	283.48	283.48	283.48	100.0
2019-03-22 05:25:00	SPY	ETF	283.44	283.44	283.44	283.44	100.0
2019-03-22 05:30:00	SPY	ETF	283.35	283.35	283.35	283.35	122.0
2019-03-22 05:31:00	SPY	ETF	283.42	283.42	283.42	283.42	500.0
2019-03-22 05:32:00	SPY	ETF	283.47	283.47	283.47	283.47	100.0
2019-03-22 05:33:00	SPY	ETF	283.42	283.42	283.42	283.42	301.0
2019-03-22 05:34:00	SPY	ETF	283.39	283.39	283.39	283.39	100.0
2019-03-22 05:36:00	SPY	ETF	283.57	283.57	283.57	283.57	100.0
2019-03-22 05:37:00	SPY	ETF	283.55	283.55	283.55	283.55	101.0
2019-03-22 05:42:00	SPY	ETF	283.55	283.55	283.55	283.55	130.0
2019-03-22 05:46:00	SPY	ETF	283.52	283.52	283.52	283.52	100.0
2019-03-22 05:47:00	SPY	ETF	283.54	283.54	283.54	283.54	201.0
2019-03-22 05:48:00	SPY	ETF	283.52	283.52	283.52	283.52	5002.0
2019-03-22 05:50:00	SPY	ETF	283.54	283.55	283.54	283.55	7700.0
2019-03-22 05:51:00	SPY	ETF	283.56	283.56	283.56	283.56	169.0

> showing 50 of 189,308 rows — these rows as CSV

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