PREVIEW / etf_5min / 2020-07-24

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-24.parquet
  size:    1.5 MB
  rows:    72,745

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-07-24 04:00:00	SPY	ETF	320.67	320.95	320.53	320.95	15417.0
2020-07-24 04:05:00	SPY	ETF	320.97	321.0	320.55	320.55	14050.0
2020-07-24 04:10:00	SPY	ETF	320.55	321.22	320.54	321.22	13104.0
2020-07-24 04:15:00	SPY	ETF	321.22	321.22	321.08	321.08	3110.0
2020-07-24 04:20:00	SPY	ETF	320.9	321.05	320.88	321.04	3815.0
2020-07-24 04:25:00	SPY	ETF	321.0	321.0	320.81	320.95	1028.0
2020-07-24 04:30:00	SPY	ETF	321.04	321.4	321.04	321.3	40359.0
2020-07-24 04:35:00	SPY	ETF	321.04	321.43	321.01	321.37	28485.0
2020-07-24 04:40:00	SPY	ETF	321.35	321.35	321.23	321.32	2620.0
2020-07-24 04:45:00	SPY	ETF	321.1	321.11	321.05	321.1	1570.0
2020-07-24 04:50:00	SPY	ETF	321.15	321.45	321.15	321.45	1230.0
2020-07-24 04:55:00	SPY	ETF	321.33	321.6	321.33	321.6	3291.0
2020-07-24 05:00:00	SPY	ETF	321.68	321.68	321.47	321.47	5015.0
2020-07-24 05:05:00	SPY	ETF	321.39	321.39	321.34	321.34	950.0
2020-07-24 05:10:00	SPY	ETF	321.6	321.67	321.52	321.67	3726.0
2020-07-24 05:15:00	SPY	ETF	321.57	321.62	321.57	321.57	25703.0
2020-07-24 05:20:00	SPY	ETF	321.68	321.68	321.57	321.57	200.0
2020-07-24 05:25:00	SPY	ETF	321.55	321.55	321.55	321.55	230.0
2020-07-24 05:30:00	SPY	ETF	321.79	321.8	321.75	321.75	1541.0
2020-07-24 05:35:00	SPY	ETF	321.75	321.75	321.6	321.6	2094.0
2020-07-24 05:40:00	SPY	ETF	321.8	321.8	321.77	321.77	4041.0
2020-07-24 05:45:00	SPY	ETF	321.77	321.8	321.77	321.8	1100.0
2020-07-24 05:50:00	SPY	ETF	321.82	321.97	321.82	321.97	4926.0
2020-07-24 05:55:00	SPY	ETF	322.0	322.09	321.97	322.0	4166.0
2020-07-24 06:00:00	SPY	ETF	321.98	322.0	321.95	321.98	2292.0
2020-07-24 06:05:00	SPY	ETF	322.02	322.3	321.98	322.3	2189.0
2020-07-24 06:10:00	SPY	ETF	322.25	322.26	322.14	322.14	11418.0
2020-07-24 06:15:00	SPY	ETF	322.14	322.14	322.01	322.04	1417.0
2020-07-24 06:20:00	SPY	ETF	322.03	322.52	322.03	322.46	121377.0
2020-07-24 06:25:00	SPY	ETF	322.46	322.46	322.28	322.31	35919.0
2020-07-24 06:30:00	SPY	ETF	322.29	322.36	322.05	322.05	2016.0
2020-07-24 06:35:00	SPY	ETF	321.92	321.92	321.7	321.85	47172.0
2020-07-24 06:40:00	SPY	ETF	321.84	321.84	321.7	321.7	35019.0
2020-07-24 06:45:00	SPY	ETF	321.8	321.8	321.68	321.68	600.0
2020-07-24 06:50:00	SPY	ETF	321.74	322.03	321.67	321.85	9715.0
2020-07-24 06:55:00	SPY	ETF	321.93	321.93	321.88	321.93	1148.0
2020-07-24 07:00:00	SPY	ETF	322.03	322.3	322.03	322.3	14160.0
2020-07-24 07:05:00	SPY	ETF	322.34	322.49	322.23	322.49	7981.0
2020-07-24 07:10:00	SPY	ETF	322.45	322.45	322.05	322.05	11886.0
2020-07-24 07:15:00	SPY	ETF	322.08	322.08	321.71	321.71	35023.0
2020-07-24 07:20:00	SPY	ETF	321.71	321.8	321.71	321.8	26711.0
2020-07-24 07:25:00	SPY	ETF	321.8	321.8	321.64	321.68	36186.0
2020-07-24 07:30:00	SPY	ETF	321.66	321.71	321.48	321.48	49838.0
2020-07-24 07:35:00	SPY	ETF	321.45	321.45	321.24	321.25	33770.0
2020-07-24 07:40:00	SPY	ETF	321.27	321.4	321.21	321.32	62091.0
2020-07-24 07:45:00	SPY	ETF	321.34	321.4	320.93	321.18	57346.0
2020-07-24 07:50:00	SPY	ETF	321.3	321.44	321.27	321.27	29948.0
2020-07-24 07:55:00	SPY	ETF	321.3	321.55	321.3	321.5	27431.0
2020-07-24 08:00:00	SPY	ETF	322.2501	322.49	320.6	321.5	92263.0
2020-07-24 08:05:00	SPY	ETF	321.59	321.82	321.5	321.74	42631.0

> showing 50 of 72,745 rows — these rows as CSV

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