PREVIEW / etf_1min / 2020-03-13

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-13.parquet
  size:    5.4 MB
  rows:    272,220

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-13 04:00:00	SPY	ETF	257.99	260.0	257.5	259.32	33627.0
2020-03-13 04:01:00	SPY	ETF	259.44	259.44	259.0	259.2	20593.0
2020-03-13 04:02:00	SPY	ETF	259.35	259.63	259.3	259.63	5062.0
2020-03-13 04:03:00	SPY	ETF	259.56	259.88	259.52	259.82	5460.0
2020-03-13 04:04:00	SPY	ETF	259.88	260.14	259.88	260.1	16096.0
2020-03-13 04:05:00	SPY	ETF	260.08	260.1	259.3	259.32	8149.0
2020-03-13 04:06:00	SPY	ETF	259.24	259.3	258.9	258.9	13434.0
2020-03-13 04:07:00	SPY	ETF	258.92	259.16	258.86	259.16	3247.0
2020-03-13 04:08:00	SPY	ETF	259.04	259.04	258.32	258.34	1621.0
2020-03-13 04:09:00	SPY	ETF	258.44	258.44	258.03	258.1	2209.0
2020-03-13 04:10:00	SPY	ETF	257.52	257.94	257.32	257.94	2140.0
2020-03-13 04:11:00	SPY	ETF	257.86	257.86	257.16	257.16	2187.0
2020-03-13 04:12:00	SPY	ETF	257.2	257.25	256.8	256.82	4145.0
2020-03-13 04:13:00	SPY	ETF	256.5	256.51	256.19	256.26	3970.0
2020-03-13 04:14:00	SPY	ETF	256.5	256.86	256.4	256.86	5253.0
2020-03-13 04:15:00	SPY	ETF	256.74	257.02	256.73	256.94	14712.0
2020-03-13 04:16:00	SPY	ETF	257.02	257.02	256.62	256.62	4515.0
2020-03-13 04:17:00	SPY	ETF	256.81	256.97	256.56	256.56	2590.0
2020-03-13 04:18:00	SPY	ETF	256.61	256.61	255.87	255.87	2383.0
2020-03-13 04:19:00	SPY	ETF	256.22	256.45	255.46	255.46	2692.0
2020-03-13 04:20:00	SPY	ETF	255.35	257.66	255.35	256.19	5236.0
2020-03-13 04:21:00	SPY	ETF	256.47	257.13	256.47	256.81	3460.0
2020-03-13 04:22:00	SPY	ETF	256.29	256.29	256.0	256.13	3508.0
2020-03-13 04:23:00	SPY	ETF	256.18	258.0	255.94	256.04	7698.0
2020-03-13 04:24:00	SPY	ETF	256.36	256.36	255.65	255.88	9566.0
2020-03-13 04:25:00	SPY	ETF	255.93	256.85	255.93	256.85	1065.0
2020-03-13 04:26:00	SPY	ETF	257.0	257.0	256.75	256.75	1188.0
2020-03-13 04:27:00	SPY	ETF	256.0	256.24	256.0	256.24	255.0
2020-03-13 04:28:00	SPY	ETF	256.15	256.15	256.15	256.15	242.0
2020-03-13 04:29:00	SPY	ETF	256.54	256.65	256.53	256.65	2775.0
2020-03-13 04:30:00	SPY	ETF	256.59	256.59	255.69	255.69	2374.0
2020-03-13 04:31:00	SPY	ETF	255.58	255.58	254.58	254.65	5551.0
2020-03-13 04:32:00	SPY	ETF	254.65	254.72	254.08	254.33	4466.0
2020-03-13 04:33:00	SPY	ETF	254.5	254.99	254.5	254.94	5266.0
2020-03-13 04:34:00	SPY	ETF	254.75	254.83	254.75	254.76	2390.0
2020-03-13 04:35:00	SPY	ETF	254.78	254.95	254.67	254.95	8910.0
2020-03-13 04:36:00	SPY	ETF	254.88	255.42	254.84	254.84	562.0
2020-03-13 04:37:00	SPY	ETF	255.08	255.13	254.9	254.9	6338.0
2020-03-13 04:38:00	SPY	ETF	254.7	254.91	254.6	254.85	8708.0
2020-03-13 04:39:00	SPY	ETF	254.75	254.75	254.61	254.61	1196.0
2020-03-13 04:40:00	SPY	ETF	254.72	254.72	254.33	254.33	3730.0
2020-03-13 04:41:00	SPY	ETF	254.3	254.3	253.46	253.46	10316.0
2020-03-13 04:42:00	SPY	ETF	253.43	254.02	253.35	253.76	10468.0
2020-03-13 04:43:00	SPY	ETF	253.7	253.76	253.53	253.7	4542.0
2020-03-13 04:44:00	SPY	ETF	253.84	254.35	253.84	254.24	5092.0
2020-03-13 04:45:00	SPY	ETF	254.46	254.91	254.41	254.91	2842.0
2020-03-13 04:46:00	SPY	ETF	254.87	254.97	254.77	254.77	3608.0
2020-03-13 04:47:00	SPY	ETF	254.48	254.48	254.01	254.16	3648.0
2020-03-13 04:48:00	SPY	ETF	254.22	254.7	254.22	254.7	402.0
2020-03-13 04:49:00	SPY	ETF	254.08	254.08	253.8	253.8	722.0

> showing 50 of 272,220 rows — these rows as CSV

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