PREVIEW / etf_1min / 2019-08-26

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-26.parquet
  size:    3.2 MB
  rows:    167,998

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
2019-08-26 04:00:00	SPY	ETF	286.7	286.99	286.7	286.73	5103.0
2019-08-26 04:01:00	SPY	ETF	286.71	287.0	286.71	286.96	3197.0
2019-08-26 04:02:00	SPY	ETF	286.88	286.88	286.73	286.73	2300.0
2019-08-26 04:03:00	SPY	ETF	286.67	286.67	286.48	286.48	4014.0
2019-08-26 04:04:00	SPY	ETF	286.57	286.6	286.48	286.48	2655.0
2019-08-26 04:05:00	SPY	ETF	286.57	286.58	286.56	286.56	3950.0
2019-08-26 04:06:00	SPY	ETF	286.54	286.55	286.54	286.55	500.0
2019-08-26 04:07:00	SPY	ETF	286.43	286.43	286.37	286.37	1120.0
2019-08-26 04:08:00	SPY	ETF	286.44	286.44	286.44	286.44	200.0
2019-08-26 04:09:00	SPY	ETF	286.4	286.49	286.4	286.49	600.0
2019-08-26 04:10:00	SPY	ETF	286.55	286.55	286.5	286.55	6210.0
2019-08-26 04:11:00	SPY	ETF	286.66	286.81	286.66	286.81	1222.0
2019-08-26 04:12:00	SPY	ETF	286.84	286.9	286.84	286.9	5400.0
2019-08-26 04:13:00	SPY	ETF	286.89	286.89	286.85	286.85	454.0
2019-08-26 04:14:00	SPY	ETF	286.85	286.91	286.85	286.88	2600.0
2019-08-26 04:15:00	SPY	ETF	286.9	287.0	286.86	287.0	6055.0
2019-08-26 04:16:00	SPY	ETF	287.17	287.17	287.17	287.17	505.0
2019-08-26 04:17:00	SPY	ETF	287.02	287.02	287.02	287.02	150.0
2019-08-26 04:19:00	SPY	ETF	287.01	287.01	287.01	287.01	100.0
2019-08-26 04:22:00	SPY	ETF	287.3	287.36	287.28	287.28	1919.0
2019-08-26 04:25:00	SPY	ETF	287.19	287.19	287.19	287.19	306.0
2019-08-26 04:26:00	SPY	ETF	287.13	287.13	287.13	287.13	160.0
2019-08-26 04:28:00	SPY	ETF	287.1	287.1	287.1	287.1	628.0
2019-08-26 04:30:00	SPY	ETF	287.01	287.03	287.01	287.03	310.0
2019-08-26 04:31:00	SPY	ETF	287.01	287.06	286.99	287.06	400.0
2019-08-26 04:32:00	SPY	ETF	287.04	287.04	287.04	287.04	100.0
2019-08-26 04:34:00	SPY	ETF	287.14	287.2	287.14	287.2	322.0
2019-08-26 04:35:00	SPY	ETF	287.31	287.31	287.31	287.31	1073.0
2019-08-26 04:36:00	SPY	ETF	287.36	287.38	287.34	287.36	3720.0
2019-08-26 04:37:00	SPY	ETF	287.33	287.65	287.33	287.64	1336.0
2019-08-26 04:38:00	SPY	ETF	287.64	287.65	287.59	287.65	1350.0
2019-08-26 04:39:00	SPY	ETF	287.65	287.94	287.65	287.93	1778.0
2019-08-26 04:40:00	SPY	ETF	287.94	288.05	287.9	287.93	2124.0
2019-08-26 04:42:00	SPY	ETF	287.93	287.93	287.87	287.87	1230.0
2019-08-26 04:43:00	SPY	ETF	288.02	288.08	288.01	288.04	1896.0
2019-08-26 04:44:00	SPY	ETF	288.0	288.0	287.9	287.9	1350.0
2019-08-26 04:45:00	SPY	ETF	287.9	287.9	287.9	287.9	1000.0
2019-08-26 04:46:00	SPY	ETF	287.79	287.83	287.79	287.83	2170.0
2019-08-26 04:47:00	SPY	ETF	287.76	287.76	287.65	287.65	1204.0
2019-08-26 04:48:00	SPY	ETF	287.69	287.75	287.69	287.75	3150.0
2019-08-26 04:49:00	SPY	ETF	287.71	287.71	287.71	287.71	150.0
2019-08-26 04:50:00	SPY	ETF	287.73	287.76	287.73	287.73	400.0
2019-08-26 04:51:00	SPY	ETF	287.77	287.78	287.77	287.78	900.0
2019-08-26 04:52:00	SPY	ETF	287.78	287.78	287.78	287.78	100.0
2019-08-26 04:54:00	SPY	ETF	287.88	287.88	287.88	287.88	180.0
2019-08-26 04:55:00	SPY	ETF	287.98	287.98	287.98	287.98	104.0
2019-08-26 04:56:00	SPY	ETF	287.95	287.98	287.95	287.97	360.0
2019-08-26 04:57:00	SPY	ETF	287.91	287.98	287.91	287.98	2600.0
2019-08-26 04:58:00	SPY	ETF	287.98	287.98	287.93	287.93	700.0
2019-08-26 04:59:00	SPY	ETF	287.97	287.97	287.88	287.91	630.0

> showing 50 of 167,998 rows — these rows as CSV

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