PREVIEW / etf_1min / 2020-03-10

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-10.parquet
  size:    5.0 MB
  rows:    255,446

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-10 04:00:00	SPY	ETF	281.96	282.36	281.95	281.95	11721.0
2020-03-10 04:01:00	SPY	ETF	282.0	282.12	281.95	282.05	6528.0
2020-03-10 04:02:00	SPY	ETF	281.81	281.81	281.69	281.69	2686.0
2020-03-10 04:03:00	SPY	ETF	282.0	282.0	281.79	281.84	2059.0
2020-03-10 04:04:00	SPY	ETF	282.0	282.26	281.89	282.17	6438.0
2020-03-10 04:05:00	SPY	ETF	281.93	282.15	281.89	281.96	2710.0
2020-03-10 04:06:00	SPY	ETF	282.08	282.4	282.08	282.4	6110.0
2020-03-10 04:07:00	SPY	ETF	282.44	283.22	282.44	283.06	7727.0
2020-03-10 04:08:00	SPY	ETF	283.11	283.4	283.11	283.4	3236.0
2020-03-10 04:09:00	SPY	ETF	283.3	283.42	283.3	283.34	3630.0
2020-03-10 04:11:00	SPY	ETF	283.01	283.01	283.01	283.01	1595.0
2020-03-10 04:12:00	SPY	ETF	282.63	282.63	282.0	282.03	7581.0
2020-03-10 04:13:00	SPY	ETF	282.06	282.06	281.77	281.8	16194.0
2020-03-10 04:14:00	SPY	ETF	281.82	281.82	281.24	281.38	10465.0
2020-03-10 04:15:00	SPY	ETF	281.32	281.47	281.32	281.47	622.0
2020-03-10 04:16:00	SPY	ETF	281.57	281.8	281.57	281.74	1399.0
2020-03-10 04:17:00	SPY	ETF	281.6	282.33	281.6	282.33	2433.0
2020-03-10 04:18:00	SPY	ETF	282.39	282.47	282.17	282.17	3540.0
2020-03-10 04:19:00	SPY	ETF	282.4	282.64	282.4	282.64	670.0
2020-03-10 04:20:00	SPY	ETF	282.59	282.59	282.46	282.5	5341.0
2020-03-10 04:21:00	SPY	ETF	282.26	282.26	282.26	282.26	115.0
2020-03-10 04:22:00	SPY	ETF	282.26	282.43	282.26	282.43	1280.0
2020-03-10 04:23:00	SPY	ETF	282.43	283.2	282.43	283.19	5415.0
2020-03-10 04:24:00	SPY	ETF	283.24	283.39	283.24	283.39	5170.0
2020-03-10 04:25:00	SPY	ETF	283.49	283.49	283.35	283.45	3109.0
2020-03-10 04:26:00	SPY	ETF	283.5	283.8	283.43	283.7	6150.0
2020-03-10 04:27:00	SPY	ETF	283.7	283.7	283.18	283.27	3152.0
2020-03-10 04:28:00	SPY	ETF	283.23	283.39	283.23	283.39	1600.0
2020-03-10 04:29:00	SPY	ETF	283.5	283.5	283.5	283.5	140.0
2020-03-10 04:30:00	SPY	ETF	283.6	283.6	283.37	283.37	3425.0
2020-03-10 04:31:00	SPY	ETF	283.54	283.75	283.52	283.75	3415.0
2020-03-10 04:32:00	SPY	ETF	283.85	283.97	283.83	283.97	4983.0
2020-03-10 04:33:00	SPY	ETF	283.97	284.0	283.76	283.78	3044.0
2020-03-10 04:34:00	SPY	ETF	283.86	283.9	283.81	283.83	4700.0
2020-03-10 04:35:00	SPY	ETF	283.73	284.0	283.73	284.0	6865.0
2020-03-10 04:36:00	SPY	ETF	284.05	284.2	284.0	284.2	5653.0
2020-03-10 04:37:00	SPY	ETF	284.2	284.28	284.16	284.16	4720.0
2020-03-10 04:39:00	SPY	ETF	284.29	284.29	284.29	284.29	215.0
2020-03-10 04:40:00	SPY	ETF	284.35	284.73	284.35	284.72	1951.0
2020-03-10 04:41:00	SPY	ETF	284.65	284.65	284.47	284.48	1723.0
2020-03-10 04:42:00	SPY	ETF	284.51	284.73	284.51	284.7	6771.0
2020-03-10 04:43:00	SPY	ETF	284.64	284.93	284.64	284.93	5202.0
2020-03-10 04:44:00	SPY	ETF	285.0	285.13	285.0	285.07	5515.0
2020-03-10 04:45:00	SPY	ETF	285.05	285.05	284.84	284.86	1585.0
2020-03-10 04:46:00	SPY	ETF	284.93	285.14	284.93	285.14	508.0
2020-03-10 04:47:00	SPY	ETF	285.07	285.07	284.72	284.72	1750.0
2020-03-10 04:48:00	SPY	ETF	284.94	284.94	284.83	284.83	458.0
2020-03-10 04:49:00	SPY	ETF	284.7	284.98	284.7	284.83	6234.0
2020-03-10 04:50:00	SPY	ETF	284.94	284.94	284.61	284.61	1632.0
2020-03-10 04:51:00	SPY	ETF	284.86	284.98	284.73	284.98	13500.0

> showing 50 of 255,446 rows — these rows as CSV

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