PREVIEW / etf_1min / 2020-03-27

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-27.parquet
  size:    4.7 MB
  rows:    245,656

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
2020-03-27 04:00:00	SPY	ETF	257.11	258.0	256.63	256.98	25498.0
2020-03-27 04:01:00	SPY	ETF	256.84	257.58	256.84	257.58	12952.0
2020-03-27 04:02:00	SPY	ETF	257.2	257.32	256.91	257.01	15546.0
2020-03-27 04:03:00	SPY	ETF	256.99	256.99	256.7	256.7	17710.0
2020-03-27 04:04:00	SPY	ETF	257.05	257.67	257.05	257.67	6004.0
2020-03-27 04:05:00	SPY	ETF	257.7	257.9	257.7	257.74	5334.0
2020-03-27 04:06:00	SPY	ETF	257.77	257.98	257.51	257.98	4417.0
2020-03-27 04:07:00	SPY	ETF	258.27	258.39	257.8	258.17	5637.0
2020-03-27 04:08:00	SPY	ETF	258.2	258.29	257.9	257.9	16550.0
2020-03-27 04:09:00	SPY	ETF	258.0	258.0	257.92	257.92	850.0
2020-03-27 04:10:00	SPY	ETF	257.94	257.95	257.58	257.85	5821.0
2020-03-27 04:11:00	SPY	ETF	257.8	257.8	257.52	257.8	3432.0
2020-03-27 04:12:00	SPY	ETF	257.52	257.53	257.45	257.52	2240.0
2020-03-27 04:13:00	SPY	ETF	257.97	258.23	257.92	258.23	4568.0
2020-03-27 04:14:00	SPY	ETF	258.34	258.34	258.0	258.0	570.0
2020-03-27 04:15:00	SPY	ETF	258.17	258.25	258.17	258.25	839.0
2020-03-27 04:16:00	SPY	ETF	257.93	257.93	257.46	257.58	4123.0
2020-03-27 04:17:00	SPY	ETF	257.45	257.45	257.03	257.03	10848.0
2020-03-27 04:18:00	SPY	ETF	257.02	257.08	256.98	257.0	8766.0
2020-03-27 04:19:00	SPY	ETF	257.0	257.45	257.0	257.4	2295.0
2020-03-27 04:20:00	SPY	ETF	257.09	257.09	256.95	256.95	631.0
2020-03-27 04:21:00	SPY	ETF	257.12	257.12	256.7	256.79	6014.0
2020-03-27 04:22:00	SPY	ETF	256.66	257.1	256.66	257.1	560.0
2020-03-27 04:23:00	SPY	ETF	256.98	257.1	256.85	256.85	5581.0
2020-03-27 04:24:00	SPY	ETF	256.93	257.29	256.85	257.29	8620.0
2020-03-27 04:25:00	SPY	ETF	257.27	257.27	257.02	257.2	7100.0
2020-03-27 04:26:00	SPY	ETF	257.05	257.05	256.87	256.87	2400.0
2020-03-27 04:27:00	SPY	ETF	256.81	257.1	256.81	257.1	303.0
2020-03-27 04:28:00	SPY	ETF	257.2	257.5	257.2	257.5	934.0
2020-03-27 04:29:00	SPY	ETF	257.47	257.77	257.47	257.77	5357.0
2020-03-27 04:30:00	SPY	ETF	257.72	257.81	257.64	257.81	2296.0
2020-03-27 04:31:00	SPY	ETF	257.86	257.86	257.61	257.83	9335.0
2020-03-27 04:32:00	SPY	ETF	257.5	257.52	257.3	257.3	856.0
2020-03-27 04:33:00	SPY	ETF	257.19	257.21	257.11	257.12	4369.0
2020-03-27 04:34:00	SPY	ETF	257.11	257.11	257.0	257.02	1967.0
2020-03-27 04:35:00	SPY	ETF	257.46	257.46	256.99	256.99	4937.0
2020-03-27 04:36:00	SPY	ETF	257.12	257.41	257.12	257.31	5612.0
2020-03-27 04:37:00	SPY	ETF	257.06	257.06	256.8	256.8	1302.0
2020-03-27 04:38:00	SPY	ETF	256.82	257.12	256.79	256.82	4192.0
2020-03-27 04:39:00	SPY	ETF	257.24	257.24	257.17	257.23	5432.0
2020-03-27 04:40:00	SPY	ETF	257.22	257.4	257.22	257.29	1258.0
2020-03-27 04:41:00	SPY	ETF	257.46	257.51	257.44	257.51	916.0
2020-03-27 04:42:00	SPY	ETF	257.24	257.24	257.19	257.19	655.0
2020-03-27 04:43:00	SPY	ETF	257.31	257.36	257.31	257.36	420.0
2020-03-27 04:44:00	SPY	ETF	257.58	257.58	257.36	257.36	320.0
2020-03-27 04:45:00	SPY	ETF	257.22	257.22	257.22	257.22	336.0
2020-03-27 04:46:00	SPY	ETF	257.54	257.57	257.5	257.5	25535.0
2020-03-27 04:47:00	SPY	ETF	257.5	257.5	257.4	257.4	25100.0
2020-03-27 04:49:00	SPY	ETF	257.36	257.36	257.19	257.21	1500.0
2020-03-27 04:50:00	SPY	ETF	257.0	257.11	257.0	257.11	411.0

> showing 50 of 245,656 rows — these rows as CSV

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