PREVIEW / etf_5min / 2020-04-14

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-14.parquet
  size:    1.8 MB
  rows:    80,465

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-04-14 04:00:00	SPY	ETF	279.27	279.3	278.84	279.25	31140.0
2020-04-14 04:05:00	SPY	ETF	279.14	279.14	279.0	279.11	6587.0
2020-04-14 04:10:00	SPY	ETF	279.16	279.16	278.83	278.85	18491.0
2020-04-14 04:15:00	SPY	ETF	278.67	278.68	278.63	278.64	1311.0
2020-04-14 04:20:00	SPY	ETF	278.92	278.92	278.92	278.92	308.0
2020-04-14 04:25:00	SPY	ETF	279.09	279.16	278.91	278.91	15255.0
2020-04-14 04:30:00	SPY	ETF	278.93	278.96	278.8	278.86	2013.0
2020-04-14 04:35:00	SPY	ETF	279.06	279.2	279.03	279.08	1687.0
2020-04-14 04:40:00	SPY	ETF	279.13	279.22	278.97	278.97	2020.0
2020-04-14 04:45:00	SPY	ETF	278.99	278.99	278.84	278.86	1625.0
2020-04-14 04:50:00	SPY	ETF	278.76	278.76	278.6	278.6	2859.0
2020-04-14 04:55:00	SPY	ETF	278.58	278.64	278.51	278.64	3013.0
2020-04-14 05:00:00	SPY	ETF	278.71	278.71	278.61	278.69	19800.0
2020-04-14 05:05:00	SPY	ETF	278.68	279.1	278.64	279.06	32113.0
2020-04-14 05:10:00	SPY	ETF	279.03	279.37	279.03	279.31	10863.0
2020-04-14 05:15:00	SPY	ETF	279.32	279.36	279.21	279.36	6419.0
2020-04-14 05:20:00	SPY	ETF	279.31	279.31	279.18	279.24	2740.0
2020-04-14 05:25:00	SPY	ETF	279.19	279.6	279.19	279.5	8095.0
2020-04-14 05:30:00	SPY	ETF	279.49	279.74	279.49	279.74	7557.0
2020-04-14 05:35:00	SPY	ETF	279.6	279.6	279.25	279.33	3765.0
2020-04-14 05:40:00	SPY	ETF	279.37	279.4	279.31	279.31	2816.0
2020-04-14 05:45:00	SPY	ETF	279.31	279.52	279.31	279.47	3275.0
2020-04-14 05:50:00	SPY	ETF	279.42	279.42	279.22	279.22	1905.0
2020-04-14 05:55:00	SPY	ETF	279.13	279.25	279.13	279.23	1657.0
2020-04-14 06:00:00	SPY	ETF	279.13	279.25	279.12	279.25	2060.0
2020-04-14 06:05:00	SPY	ETF	279.2	279.2	278.97	279.07	1765.0
2020-04-14 06:10:00	SPY	ETF	279.26	279.26	279.26	279.26	180.0
2020-04-14 06:15:00	SPY	ETF	279.18	279.18	279.1	279.1	6800.0
2020-04-14 06:20:00	SPY	ETF	279.01	279.4	278.98	279.31	19750.0
2020-04-14 06:25:00	SPY	ETF	279.32	279.46	279.29	279.35	28475.0
2020-04-14 06:30:00	SPY	ETF	279.4	279.48	279.11	279.14	18352.0
2020-04-14 06:35:00	SPY	ETF	279.2	279.31	279.17	279.23	11546.0
2020-04-14 06:40:00	SPY	ETF	279.21	279.3	279.2	279.2	27482.0
2020-04-14 06:45:00	SPY	ETF	279.03	279.15	278.5	278.5	73251.0
2020-04-14 06:50:00	SPY	ETF	278.59	278.81	278.45	278.75	42025.0
2020-04-14 06:55:00	SPY	ETF	278.71	279.02	278.58	279.0	20207.0
2020-04-14 07:00:00	SPY	ETF	278.9	279.21	278.9	279.2	51537.0
2020-04-14 07:05:00	SPY	ETF	279.16	279.31	279.01	279.02	45945.0
2020-04-14 07:10:00	SPY	ETF	279.13	279.13	278.71	278.93	36937.0
2020-04-14 07:15:00	SPY	ETF	278.93	278.95	278.52	278.59	89947.0
2020-04-14 07:20:00	SPY	ETF	278.52	278.88	278.52	278.86	53281.0
2020-04-14 07:25:00	SPY	ETF	278.84	278.99	278.75	278.97	48289.0
2020-04-14 07:30:00	SPY	ETF	278.97	279.06	278.87	278.9	40299.0
2020-04-14 07:35:00	SPY	ETF	278.9	279.47	278.84	279.36	58147.0
2020-04-14 07:40:00	SPY	ETF	279.35	279.73	279.3	279.68	59541.0
2020-04-14 07:45:00	SPY	ETF	279.69	280.01	279.68	279.92	57065.0
2020-04-14 07:50:00	SPY	ETF	279.97	280.11	279.6	279.69	104901.0
2020-04-14 07:55:00	SPY	ETF	279.67	279.86	279.53	279.7	56294.0
2020-04-14 08:00:00	SPY	ETF	279.66	280.86	278.53	279.91	194284.0
2020-04-14 08:05:00	SPY	ETF	279.91	279.98	279.68	279.74	51479.0

> showing 50 of 80,465 rows — these rows as CSV

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