PREVIEW / etf_5min / 2021-09-09

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-09-09.parquet
  size:    1.7 MB
  rows:    79,364

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
2021-09-09 04:00:00	SPY	ETF	450.3	450.3	449.54	449.75	10427.0
2021-09-09 04:05:00	SPY	ETF	449.83	449.83	449.55	449.7	5350.0
2021-09-09 04:10:00	SPY	ETF	449.7	449.9	449.68	449.9	5599.0
2021-09-09 04:15:00	SPY	ETF	449.98	449.98	449.98	449.98	500.0
2021-09-09 04:20:00	SPY	ETF	450.01	450.01	449.81	449.81	2100.0
2021-09-09 04:25:00	SPY	ETF	449.78	449.78	449.78	449.78	200.0
2021-09-09 04:30:00	SPY	ETF	449.74	449.75	449.74	449.75	4326.0
2021-09-09 04:35:00	SPY	ETF	449.75	449.75	449.75	449.75	200.0
2021-09-09 04:40:00	SPY	ETF	449.61	449.65	449.61	449.65	300.0
2021-09-09 04:50:00	SPY	ETF	449.69	449.69	449.69	449.69	500.0
2021-09-09 04:55:00	SPY	ETF	449.56	449.56	449.56	449.56	200.0
2021-09-09 05:00:00	SPY	ETF	449.5	449.57	449.5	449.57	1400.0
2021-09-09 05:05:00	SPY	ETF	449.46	449.57	449.43	449.57	911.0
2021-09-09 05:10:00	SPY	ETF	449.61	449.61	449.38	449.39	1804.0
2021-09-09 05:15:00	SPY	ETF	449.33	449.5	449.3	449.5	3600.0
2021-09-09 05:20:00	SPY	ETF	449.58	449.6	449.58	449.6	555.0
2021-09-09 05:25:00	SPY	ETF	449.54	449.69	449.54	449.69	312.0
2021-09-09 05:30:00	SPY	ETF	450.09	450.1	450.09	450.1	200.0
2021-09-09 05:35:00	SPY	ETF	450.02	450.07	449.96	450.07	900.0
2021-09-09 05:40:00	SPY	ETF	450.1	450.1	449.81	449.81	2100.0
2021-09-09 05:45:00	SPY	ETF	449.77	449.77	449.77	449.77	200.0
2021-09-09 05:55:00	SPY	ETF	449.86	449.86	449.86	449.86	160.0
2021-09-09 06:00:00	SPY	ETF	449.85	449.89	449.8	449.88	6900.0
2021-09-09 06:10:00	SPY	ETF	449.76	449.76	449.68	449.7	2399.0
2021-09-09 06:15:00	SPY	ETF	449.7	449.7	449.7	449.7	400.0
2021-09-09 06:20:00	SPY	ETF	449.79	449.84	449.79	449.84	300.0
2021-09-09 06:25:00	SPY	ETF	449.79	449.79	449.79	449.79	490.0
2021-09-09 06:30:00	SPY	ETF	449.92	449.93	449.78	449.78	3363.0
2021-09-09 06:35:00	SPY	ETF	449.79	449.8	449.67	449.73	2598.0
2021-09-09 06:40:00	SPY	ETF	449.79	449.79	449.75	449.75	2798.0
2021-09-09 06:45:00	SPY	ETF	449.65	449.67	449.59	449.67	14540.0
2021-09-09 06:50:00	SPY	ETF	449.67	449.67	449.66	449.66	7300.0
2021-09-09 06:55:00	SPY	ETF	449.69	449.69	449.69	449.69	100.0
2021-09-09 07:00:00	SPY	ETF	449.72	449.83	449.72	449.82	1305.0
2021-09-09 07:05:00	SPY	ETF	449.8	449.92	449.8	449.86	2401.0
2021-09-09 07:10:00	SPY	ETF	449.87	449.89	449.82	449.82	26296.0
2021-09-09 07:15:00	SPY	ETF	449.79	449.84	449.79	449.84	3100.0
2021-09-09 07:20:00	SPY	ETF	449.8	449.85	449.8	449.85	1100.0
2021-09-09 07:25:00	SPY	ETF	449.83	449.83	449.72	449.78	1910.0
2021-09-09 07:30:00	SPY	ETF	449.8	449.9	449.8	449.85	3990.0
2021-09-09 07:35:00	SPY	ETF	449.85	449.87	449.75	449.75	4690.0
2021-09-09 07:40:00	SPY	ETF	449.74	449.74	449.51	449.51	15328.0
2021-09-09 07:45:00	SPY	ETF	449.42	450.29	449.42	450.29	41605.0
2021-09-09 07:50:00	SPY	ETF	450.35	450.5	450.33	450.5	27597.0
2021-09-09 07:55:00	SPY	ETF	450.49	450.69	450.49	450.63	18615.0
2021-09-09 08:00:00	SPY	ETF	450.68	451.208	448.3	450.85	41556.0
2021-09-09 08:05:00	SPY	ETF	450.88	450.88	450.66	450.66	20219.0
2021-09-09 08:10:00	SPY	ETF	450.64	450.68	450.5	450.51	18948.0
2021-09-09 08:15:00	SPY	ETF	450.53	450.62	450.52	450.55	15750.0
2021-09-09 08:20:00	SPY	ETF	450.55	450.55	450.36	450.36	6208.0

> showing 50 of 79,364 rows — these rows as CSV

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