PREVIEW / etf_5min / 2023-01-10

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-10.parquet
  size:    1.9 MB
  rows:    94,644

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
2023-01-10 04:00:00	SPY	ETF	387.86	387.86	387.04	387.04	6306.0
2023-01-10 04:05:00	SPY	ETF	387.1	387.25	386.98	387.19	4196.0
2023-01-10 04:10:00	SPY	ETF	387.22	387.22	386.99	386.99	5227.0
2023-01-10 04:15:00	SPY	ETF	386.91	387.19	386.91	387.05	3297.0
2023-01-10 04:20:00	SPY	ETF	387.04	387.08	387.04	387.08	200.0
2023-01-10 04:25:00	SPY	ETF	387.14	387.33	387.14	387.33	200.0
2023-01-10 04:30:00	SPY	ETF	387.28	387.46	387.28	387.46	8200.0
2023-01-10 04:35:00	SPY	ETF	387.36	387.73	387.35	387.73	14816.0
2023-01-10 04:40:00	SPY	ETF	387.69	387.69	387.58	387.64	750.0
2023-01-10 04:45:00	SPY	ETF	387.42	387.64	387.42	387.64	700.0
2023-01-10 04:50:00	SPY	ETF	387.67	387.67	387.52	387.57	2033.0
2023-01-10 04:55:00	SPY	ETF	387.63	387.67	387.62	387.67	563.0
2023-01-10 05:00:00	SPY	ETF	387.82	387.83	387.6	387.6	600.0
2023-01-10 05:05:00	SPY	ETF	387.56	387.56	387.49	387.49	550.0
2023-01-10 05:10:00	SPY	ETF	387.52	387.52	387.4	387.42	2700.0
2023-01-10 05:15:00	SPY	ETF	387.43	387.58	387.43	387.55	4500.0
2023-01-10 05:20:00	SPY	ETF	387.65	387.7	387.62	387.62	400.0
2023-01-10 05:30:00	SPY	ETF	387.76	387.78	387.76	387.77	912.0
2023-01-10 05:35:00	SPY	ETF	387.86	387.93	387.86	387.9	3165.0
2023-01-10 05:40:00	SPY	ETF	387.95	387.95	387.74	387.75	4309.0
2023-01-10 05:45:00	SPY	ETF	387.7	387.91	387.7	387.86	3097.0
2023-01-10 05:50:00	SPY	ETF	387.72	387.74	387.66	387.66	1600.0
2023-01-10 05:55:00	SPY	ETF	387.65	387.76	387.63	387.63	1006.0
2023-01-10 06:00:00	SPY	ETF	387.63	387.63	387.55	387.6	1719.0
2023-01-10 06:05:00	SPY	ETF	387.52	387.52	387.41	387.43	1000.0
2023-01-10 06:10:00	SPY	ETF	387.27	387.3	386.9	386.96	11332.0
2023-01-10 06:15:00	SPY	ETF	386.97	387.18	386.97	387.17	2313.0
2023-01-10 06:20:00	SPY	ETF	387.2	387.2	387.05	387.05	1548.0
2023-01-10 06:25:00	SPY	ETF	387.03	387.1	387.03	387.09	2600.0
2023-01-10 06:30:00	SPY	ETF	387.1	387.1	386.81	386.81	9573.0
2023-01-10 06:35:00	SPY	ETF	386.75	386.83	386.69	386.75	65137.0
2023-01-10 06:40:00	SPY	ETF	386.72	386.75	386.5	386.73	7700.0
2023-01-10 06:45:00	SPY	ETF	386.73	386.73	386.67	386.68	1520.0
2023-01-10 06:50:00	SPY	ETF	386.75	386.86	386.67	386.71	4598.0
2023-01-10 06:55:00	SPY	ETF	386.67	386.76	386.67	386.76	4550.0
2023-01-10 07:00:00	SPY	ETF	386.71	386.75	386.53	386.74	8723.0
2023-01-10 07:05:00	SPY	ETF	386.66	386.69	386.5	386.5	14126.0
2023-01-10 07:10:00	SPY	ETF	386.5	386.53	386.31	386.46	85354.0
2023-01-10 07:15:00	SPY	ETF	386.59	386.7	385.81	386.05	75896.0
2023-01-10 07:20:00	SPY	ETF	386.06	386.15	385.86	386.05	101746.0
2023-01-10 07:25:00	SPY	ETF	386.1	386.36	386.1	386.29	58996.0
2023-01-10 07:30:00	SPY	ETF	386.28	386.3	386.0	386.01	28050.0
2023-01-10 07:35:00	SPY	ETF	386.02	386.23	386.0	386.14	5862.0
2023-01-10 07:40:00	SPY	ETF	386.05	386.28	386.05	386.12	3546.0
2023-01-10 07:45:00	SPY	ETF	386.0	386.17	385.891	385.891	15117.0
2023-01-10 07:50:00	SPY	ETF	385.92	386.19	385.74	386.15	43910.0
2023-01-10 07:55:00	SPY	ETF	386.22	386.31	386.19	386.28	31683.0
2023-01-10 08:00:00	SPY	ETF	386.25	387.7396	385.8	386.09	106872.0
2023-01-10 08:05:00	SPY	ETF	386.06	386.35	386.05	386.35	90889.0
2023-01-10 08:10:00	SPY	ETF	386.35	386.5	386.21	386.27	49247.0

> showing 50 of 94,644 rows — these rows as CSV

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