PREVIEW / etf_1min / 2019-08-01

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-01.parquet
  size:    3.7 MB
  rows:    186,346

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-01 04:00:00	SPY	ETF	297.76	297.77	297.74	297.75	3290.0
2019-08-01 04:01:00	SPY	ETF	297.77	297.85	297.77	297.85	2700.0
2019-08-01 04:02:00	SPY	ETF	297.85	297.9	297.85	297.88	800.0
2019-08-01 04:03:00	SPY	ETF	297.87	297.9	297.87	297.9	410.0
2019-08-01 04:04:00	SPY	ETF	297.85	297.85	297.83	297.83	820.0
2019-08-01 04:05:00	SPY	ETF	297.8	297.8	297.77	297.77	600.0
2019-08-01 04:06:00	SPY	ETF	297.72	297.72	297.72	297.72	840.0
2019-08-01 04:07:00	SPY	ETF	297.72	297.72	297.72	297.72	300.0
2019-08-01 04:08:00	SPY	ETF	297.75	297.75	297.75	297.75	800.0
2019-08-01 04:09:00	SPY	ETF	297.75	297.75	297.7	297.7	800.0
2019-08-01 04:10:00	SPY	ETF	297.65	297.67	297.65	297.67	1000.0
2019-08-01 04:12:00	SPY	ETF	297.71	297.71	297.71	297.71	200.0
2019-08-01 04:14:00	SPY	ETF	297.81	297.84	297.81	297.84	800.0
2019-08-01 04:15:00	SPY	ETF	297.87	297.88	297.87	297.88	380.0
2019-08-01 04:17:00	SPY	ETF	297.84	297.84	297.84	297.84	300.0
2019-08-01 04:18:00	SPY	ETF	297.9	297.9	297.87	297.87	601.0
2019-08-01 04:21:00	SPY	ETF	297.82	297.82	297.82	297.82	200.0
2019-08-01 04:24:00	SPY	ETF	297.72	297.72	297.72	297.72	300.0
2019-08-01 04:31:00	SPY	ETF	297.64	297.64	297.64	297.64	340.0
2019-08-01 04:35:00	SPY	ETF	297.43	297.43	297.39	297.39	545.0
2019-08-01 04:37:00	SPY	ETF	297.58	297.58	297.58	297.58	300.0
2019-08-01 04:38:00	SPY	ETF	297.55	297.55	297.54	297.54	315.0
2019-08-01 04:41:00	SPY	ETF	297.76	297.76	297.76	297.76	200.0
2019-08-01 04:44:00	SPY	ETF	297.74	297.74	297.74	297.74	250.0
2019-08-01 04:47:00	SPY	ETF	297.71	297.73	297.71	297.73	1110.0
2019-08-01 04:48:00	SPY	ETF	297.76	297.78	297.76	297.78	300.0
2019-08-01 04:50:00	SPY	ETF	297.68	297.68	297.68	297.68	320.0
2019-08-01 04:51:00	SPY	ETF	297.66	297.66	297.66	297.66	300.0
2019-08-01 04:52:00	SPY	ETF	297.66	297.73	297.66	297.73	800.0
2019-08-01 04:53:00	SPY	ETF	297.78	297.81	297.78	297.81	300.0
2019-08-01 04:54:00	SPY	ETF	297.79	297.79	297.79	297.79	200.0
2019-08-01 04:55:00	SPY	ETF	297.81	297.81	297.78	297.78	3500.0
2019-08-01 04:56:00	SPY	ETF	297.81	297.81	297.81	297.81	3000.0
2019-08-01 04:57:00	SPY	ETF	297.76	297.76	297.76	297.76	300.0
2019-08-01 05:02:00	SPY	ETF	297.73	297.73	297.73	297.73	100.0
2019-08-01 05:03:00	SPY	ETF	297.8	297.81	297.8	297.8	5220.0
2019-08-01 05:05:00	SPY	ETF	297.89	298.17	297.89	298.12	1330.0
2019-08-01 05:06:00	SPY	ETF	298.25	298.25	298.23	298.23	400.0
2019-08-01 05:07:00	SPY	ETF	298.23	298.25	298.23	298.25	900.0
2019-08-01 05:08:00	SPY	ETF	298.33	298.33	298.33	298.33	317.0
2019-08-01 05:09:00	SPY	ETF	298.35	298.35	298.35	298.35	100.0
2019-08-01 05:10:00	SPY	ETF	298.25	298.25	298.23	298.23	920.0
2019-08-01 05:11:00	SPY	ETF	298.23	298.25	298.23	298.25	2100.0
2019-08-01 05:13:00	SPY	ETF	298.3	298.3	298.3	298.3	200.0
2019-08-01 05:14:00	SPY	ETF	298.3	298.3	298.3	298.3	420.0
2019-08-01 05:16:00	SPY	ETF	298.26	298.3	298.22	298.23	10000.0
2019-08-01 05:17:00	SPY	ETF	298.22	298.22	298.15	298.2	19230.0
2019-08-01 05:18:00	SPY	ETF	298.16	298.16	298.16	298.16	300.0
2019-08-01 05:23:00	SPY	ETF	298.11	298.11	298.11	298.11	300.0
2019-08-01 05:24:00	SPY	ETF	298.12	298.12	298.11	298.11	300.0

> showing 50 of 186,346 rows — these rows as CSV

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