PREVIEW / etf_1min / 2020-09-25

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-09-25.parquet
  size:    3.6 MB
  rows:    193,031

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-09-25 04:00:00	SPY	ETF	323.8	323.81	323.73	323.81	9586.0
2020-09-25 04:01:00	SPY	ETF	323.83	323.9	323.83	323.9	700.0
2020-09-25 04:03:00	SPY	ETF	323.99	323.99	323.99	323.99	303.0
2020-09-25 04:05:00	SPY	ETF	323.92	323.92	323.91	323.91	718.0
2020-09-25 04:06:00	SPY	ETF	323.75	323.75	323.66	323.66	267.0
2020-09-25 04:07:00	SPY	ETF	323.61	323.63	323.58	323.58	2406.0
2020-09-25 04:08:00	SPY	ETF	323.37	323.37	323.33	323.33	1526.0
2020-09-25 04:10:00	SPY	ETF	323.36	323.36	323.34	323.35	2948.0
2020-09-25 04:13:00	SPY	ETF	323.26	323.26	323.26	323.26	2561.0
2020-09-25 04:14:00	SPY	ETF	323.31	323.31	323.31	323.31	180.0
2020-09-25 04:20:00	SPY	ETF	323.45	323.45	323.45	323.45	800.0
2020-09-25 04:23:00	SPY	ETF	323.6	323.6	323.6	323.6	199.0
2020-09-25 04:28:00	SPY	ETF	323.51	323.51	323.51	323.51	400.0
2020-09-25 04:30:00	SPY	ETF	323.37	323.37	323.37	323.37	550.0
2020-09-25 04:31:00	SPY	ETF	323.51	323.64	323.51	323.63	2599.0
2020-09-25 04:33:00	SPY	ETF	323.58	323.64	323.58	323.64	2420.0
2020-09-25 04:35:00	SPY	ETF	323.71	323.71	323.71	323.71	226.0
2020-09-25 04:37:00	SPY	ETF	323.68	323.68	323.68	323.68	100.0
2020-09-25 04:42:00	SPY	ETF	323.75	323.8	323.75	323.75	921.0
2020-09-25 04:43:00	SPY	ETF	323.68	323.68	323.68	323.68	150.0
2020-09-25 04:45:00	SPY	ETF	323.59	323.59	323.59	323.59	850.0
2020-09-25 04:48:00	SPY	ETF	323.7	323.7	323.68	323.68	500.0
2020-09-25 04:55:00	SPY	ETF	323.9	323.9	323.9	323.9	100.0
2020-09-25 04:58:00	SPY	ETF	323.82	323.84	323.8	323.84	2905.0
2020-09-25 04:59:00	SPY	ETF	323.94	323.96	323.94	323.95	1606.0
2020-09-25 05:00:00	SPY	ETF	324.12	324.21	324.12	324.16	5560.0
2020-09-25 05:04:00	SPY	ETF	324.19	324.2	324.18	324.18	2801.0
2020-09-25 05:07:00	SPY	ETF	324.11	324.13	324.11	324.13	1000.0
2020-09-25 05:13:00	SPY	ETF	324.18	324.18	324.18	324.18	170.0
2020-09-25 05:14:00	SPY	ETF	324.1	324.1	323.93	323.93	1847.0
2020-09-25 05:17:00	SPY	ETF	323.82	323.82	323.76	323.77	3178.0
2020-09-25 05:19:00	SPY	ETF	323.68	323.68	323.68	323.68	1139.0
2020-09-25 05:22:00	SPY	ETF	323.58	323.58	323.48	323.48	1941.0
2020-09-25 05:23:00	SPY	ETF	323.46	323.46	323.41	323.41	350.0
2020-09-25 05:24:00	SPY	ETF	323.44	323.44	323.41	323.41	540.0
2020-09-25 05:26:00	SPY	ETF	323.5	323.61	323.5	323.61	1100.0
2020-09-25 05:27:00	SPY	ETF	323.64	323.68	323.64	323.66	1430.0
2020-09-25 05:28:00	SPY	ETF	323.69	323.69	323.55	323.55	1001.0
2020-09-25 05:29:00	SPY	ETF	323.64	323.64	323.64	323.64	335.0
2020-09-25 05:30:00	SPY	ETF	323.39	323.39	323.36	323.36	310.0
2020-09-25 05:31:00	SPY	ETF	323.36	323.36	323.36	323.36	430.0
2020-09-25 05:33:00	SPY	ETF	323.46	323.46	323.43	323.43	338.0
2020-09-25 05:34:00	SPY	ETF	323.41	323.42	323.41	323.42	1000.0
2020-09-25 05:37:00	SPY	ETF	323.36	323.36	323.36	323.36	618.0
2020-09-25 05:39:00	SPY	ETF	323.36	323.36	323.32	323.32	400.0
2020-09-25 05:41:00	SPY	ETF	323.31	323.31	323.31	323.31	286.0
2020-09-25 05:42:00	SPY	ETF	323.21	323.21	323.0	323.0	928.0
2020-09-25 05:43:00	SPY	ETF	322.99	323.0	322.99	322.99	1355.0
2020-09-25 05:44:00	SPY	ETF	322.97	322.97	322.9	322.9	1988.0
2020-09-25 05:45:00	SPY	ETF	322.83	322.83	322.7	322.79	3506.0

> showing 50 of 193,031 rows — these rows as CSV

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