PREVIEW / etf_1min / 2022-01-13

all etf 1-min files

  file:    by_date/etf_1min/2022/2022-01-13.parquet
  size:    4.7 MB
  rows:    258,173

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
2022-01-13 04:00:00	SPY	ETF	470.82	470.82	470.82	470.82	100.0
2022-01-13 04:01:00	SPY	ETF	470.65	470.65	470.65	470.65	664.0
2022-01-13 04:03:00	SPY	ETF	470.7	470.7	470.7	470.7	300.0
2022-01-13 04:04:00	SPY	ETF	470.53	470.53	470.52	470.52	500.0
2022-01-13 04:05:00	SPY	ETF	470.57	470.57	470.55	470.55	728.0
2022-01-13 04:10:00	SPY	ETF	470.68	470.68	470.6	470.6	536.0
2022-01-13 04:11:00	SPY	ETF	470.63	470.63	470.53	470.53	337.0
2022-01-13 04:12:00	SPY	ETF	470.64	470.66	470.64	470.66	290.0
2022-01-13 04:13:00	SPY	ETF	470.68	470.68	470.64	470.64	207.0
2022-01-13 04:14:00	SPY	ETF	470.57	470.57	470.57	470.57	100.0
2022-01-13 04:15:00	SPY	ETF	470.44	470.44	470.44	470.44	206.0
2022-01-13 04:16:00	SPY	ETF	470.44	470.44	470.44	470.44	215.0
2022-01-13 04:20:00	SPY	ETF	470.54	470.65	470.54	470.65	839.0
2022-01-13 04:21:00	SPY	ETF	470.66	470.73	470.66	470.73	400.0
2022-01-13 04:24:00	SPY	ETF	470.7	470.7	470.7	470.7	110.0
2022-01-13 04:25:00	SPY	ETF	470.7	470.7	470.7	470.7	258.0
2022-01-13 04:26:00	SPY	ETF	470.68	470.68	470.68	470.68	100.0
2022-01-13 04:27:00	SPY	ETF	470.72	470.72	470.72	470.72	138.0
2022-01-13 04:28:00	SPY	ETF	470.72	470.72	470.72	470.72	207.0
2022-01-13 04:35:00	SPY	ETF	470.84	470.84	470.84	470.84	100.0
2022-01-13 04:36:00	SPY	ETF	470.85	470.87	470.85	470.87	337.0
2022-01-13 04:37:00	SPY	ETF	470.87	470.87	470.84	470.84	420.0
2022-01-13 04:40:00	SPY	ETF	470.88	470.88	470.88	470.88	100.0
2022-01-13 04:44:00	SPY	ETF	470.93	470.93	470.93	470.93	100.0
2022-01-13 04:48:00	SPY	ETF	470.75	470.75	470.75	470.75	208.0
2022-01-13 04:52:00	SPY	ETF	470.72	470.72	470.72	470.72	600.0
2022-01-13 04:54:00	SPY	ETF	470.87	470.87	470.87	470.87	100.0
2022-01-13 04:59:00	SPY	ETF	470.83	470.83	470.83	470.83	100.0
2022-01-13 05:00:00	SPY	ETF	471.0	471.0	470.99	470.99	329.0
2022-01-13 05:01:00	SPY	ETF	471.02	471.02	470.93	470.93	3458.0
2022-01-13 05:04:00	SPY	ETF	470.94	470.94	470.94	470.94	100.0
2022-01-13 05:05:00	SPY	ETF	471.0	471.0	471.0	471.0	200.0
2022-01-13 05:06:00	SPY	ETF	470.99	470.99	470.99	470.99	100.0
2022-01-13 05:09:00	SPY	ETF	471.03	471.03	471.03	471.03	100.0
2022-01-13 05:10:00	SPY	ETF	471.02	471.02	471.02	471.02	605.0
2022-01-13 05:11:00	SPY	ETF	471.0	471.0	471.0	471.0	100.0
2022-01-13 05:12:00	SPY	ETF	471.02	471.1	471.02	471.1	247.0
2022-01-13 05:14:00	SPY	ETF	471.02	471.02	471.02	471.02	342.0
2022-01-13 05:15:00	SPY	ETF	471.0	471.0	471.0	471.0	100.0
2022-01-13 05:18:00	SPY	ETF	471.08	471.08	471.08	471.08	800.0
2022-01-13 05:20:00	SPY	ETF	471.13	471.16	471.13	471.16	425.0
2022-01-13 05:25:00	SPY	ETF	471.18	471.31	471.18	471.28	2499.0
2022-01-13 05:26:00	SPY	ETF	471.34	471.34	471.16	471.16	300.0
2022-01-13 05:27:00	SPY	ETF	471.19	471.23	471.18	471.18	10000.0
2022-01-13 05:30:00	SPY	ETF	471.27	471.27	471.27	471.27	240.0
2022-01-13 05:31:00	SPY	ETF	471.32	471.32	471.32	471.32	100.0
2022-01-13 05:32:00	SPY	ETF	471.34	471.34	471.34	471.34	480.0
2022-01-13 05:34:00	SPY	ETF	471.37	471.37	471.33	471.33	200.0
2022-01-13 05:35:00	SPY	ETF	471.3	471.3	471.3	471.3	500.0
2022-01-13 05:36:00	SPY	ETF	471.32	471.32	471.26	471.26	200.0

> showing 50 of 258,173 rows — these rows as CSV

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