PREVIEW / etf_1min / 2020-01-30

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-30.parquet
  size:    3.7 MB
  rows:    188,736

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-01-30 04:00:00	SPY	ETF	324.5	324.5	324.37	324.4	7466.0
2020-01-30 04:01:00	SPY	ETF	324.42	324.42	324.42	324.42	910.0
2020-01-30 04:03:00	SPY	ETF	324.42	324.42	324.42	324.42	330.0
2020-01-30 04:04:00	SPY	ETF	324.39	324.42	324.3	324.42	2003.0
2020-01-30 04:05:00	SPY	ETF	324.42	324.52	324.42	324.52	850.0
2020-01-30 04:06:00	SPY	ETF	324.52	324.78	324.52	324.78	5704.0
2020-01-30 04:07:00	SPY	ETF	324.7	324.7	324.7	324.7	425.0
2020-01-30 04:08:00	SPY	ETF	324.65	324.69	324.65	324.68	325.0
2020-01-30 04:09:00	SPY	ETF	324.69	324.8	324.69	324.8	3300.0
2020-01-30 04:10:00	SPY	ETF	324.7	324.7	324.7	324.7	235.0
2020-01-30 04:11:00	SPY	ETF	324.68	324.71	324.68	324.71	3305.0
2020-01-30 04:12:00	SPY	ETF	324.73	324.73	324.68	324.68	1900.0
2020-01-30 04:14:00	SPY	ETF	324.67	324.69	324.67	324.69	220.0
2020-01-30 04:18:00	SPY	ETF	324.73	324.73	324.73	324.73	182.0
2020-01-30 04:19:00	SPY	ETF	324.89	324.89	324.88	324.88	978.0
2020-01-30 04:20:00	SPY	ETF	325.0	325.14	325.0	325.13	4511.0
2020-01-30 04:21:00	SPY	ETF	325.12	325.12	325.12	325.12	450.0
2020-01-30 04:23:00	SPY	ETF	325.1	325.1	325.1	325.1	323.0
2020-01-30 04:24:00	SPY	ETF	325.27	325.32	325.24	325.24	5893.0
2020-01-30 04:29:00	SPY	ETF	325.05	325.06	325.0	325.06	1989.0
2020-01-30 04:31:00	SPY	ETF	324.97	324.97	324.97	324.97	2010.0
2020-01-30 04:32:00	SPY	ETF	324.99	324.99	324.99	324.99	1010.0
2020-01-30 04:34:00	SPY	ETF	324.85	324.85	324.85	324.85	215.0
2020-01-30 04:35:00	SPY	ETF	324.83	324.83	324.83	324.83	1110.0
2020-01-30 04:36:00	SPY	ETF	324.94	324.94	324.94	324.94	530.0
2020-01-30 04:37:00	SPY	ETF	325.0	325.0	325.0	325.0	301.0
2020-01-30 04:42:00	SPY	ETF	324.75	324.75	324.75	324.75	150.0
2020-01-30 04:43:00	SPY	ETF	324.7	324.73	324.7	324.73	2330.0
2020-01-30 04:44:00	SPY	ETF	324.78	324.78	324.78	324.78	341.0
2020-01-30 04:46:00	SPY	ETF	324.72	324.72	324.72	324.72	1000.0
2020-01-30 04:47:00	SPY	ETF	324.72	324.72	324.72	324.72	310.0
2020-01-30 04:48:00	SPY	ETF	324.7	324.7	324.67	324.67	500.0
2020-01-30 04:49:00	SPY	ETF	324.66	324.66	324.65	324.65	250.0
2020-01-30 04:50:00	SPY	ETF	324.67	324.72	324.66	324.72	560.0
2020-01-30 04:51:00	SPY	ETF	324.75	324.75	324.75	324.75	500.0
2020-01-30 04:53:00	SPY	ETF	324.85	324.85	324.85	324.85	500.0
2020-01-30 04:54:00	SPY	ETF	324.92	324.92	324.92	324.92	100.0
2020-01-30 04:56:00	SPY	ETF	324.85	324.85	324.85	324.85	502.0
2020-01-30 04:59:00	SPY	ETF	324.82	324.82	324.78	324.78	720.0
2020-01-30 05:01:00	SPY	ETF	324.69	324.69	324.68	324.68	205.0
2020-01-30 05:02:00	SPY	ETF	324.57	324.57	324.57	324.57	400.0
2020-01-30 05:03:00	SPY	ETF	324.69	324.69	324.69	324.69	300.0
2020-01-30 05:04:00	SPY	ETF	324.69	324.71	324.65	324.71	800.0
2020-01-30 05:09:00	SPY	ETF	324.67	324.67	324.67	324.67	438.0
2020-01-30 05:10:00	SPY	ETF	324.7	324.7	324.7	324.7	100.0
2020-01-30 05:11:00	SPY	ETF	324.72	324.72	324.72	324.72	325.0
2020-01-30 05:16:00	SPY	ETF	324.76	324.76	324.76	324.76	100.0
2020-01-30 05:20:00	SPY	ETF	324.59	324.59	324.59	324.59	500.0
2020-01-30 05:24:00	SPY	ETF	324.5	324.5	324.5	324.5	845.0
2020-01-30 05:25:00	SPY	ETF	324.57	324.64	324.57	324.64	1630.0

> showing 50 of 188,736 rows — these rows as CSV

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