PREVIEW / etf_5min / 2019-12-03

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-03.parquet
  size:    1.6 MB
  rows:    65,949

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-12-03 04:00:00	SPY	ETF	312.05	312.27	312.05	312.18	3580.0
2019-12-03 04:05:00	SPY	ETF	312.27	312.27	312.17	312.18	3750.0
2019-12-03 04:10:00	SPY	ETF	312.14	312.14	312.14	312.14	247.0
2019-12-03 04:15:00	SPY	ETF	312.09	312.09	312.09	312.09	303.0
2019-12-03 04:25:00	SPY	ETF	312.14	312.14	312.14	312.14	150.0
2019-12-03 04:30:00	SPY	ETF	312.13	312.14	312.04	312.04	5001.0
2019-12-03 04:35:00	SPY	ETF	312.0	312.0	311.97	311.97	556.0
2019-12-03 04:40:00	SPY	ETF	311.93	311.93	311.77	311.77	424.0
2019-12-03 04:45:00	SPY	ETF	311.81	311.81	311.69	311.69	616.0
2019-12-03 04:55:00	SPY	ETF	311.85	311.9	311.85	311.9	396.0
2019-12-03 05:00:00	SPY	ETF	312.06	312.14	312.06	312.09	1484.0
2019-12-03 05:05:00	SPY	ETF	311.92	311.92	311.92	311.92	1000.0
2019-12-03 05:10:00	SPY	ETF	311.9	311.9	311.05	311.17	13108.0
2019-12-03 05:15:00	SPY	ETF	311.14	311.14	310.62	310.7	9730.0
2019-12-03 05:20:00	SPY	ETF	310.74	310.74	310.45	310.64	7070.0
2019-12-03 05:25:00	SPY	ETF	310.64	310.7	310.35	310.37	7176.0
2019-12-03 05:30:00	SPY	ETF	310.42	310.6	310.41	310.6	4621.0
2019-12-03 05:35:00	SPY	ETF	310.5	310.5	310.35	310.42	3038.0
2019-12-03 05:40:00	SPY	ETF	310.39	310.41	310.36	310.37	4350.0
2019-12-03 05:45:00	SPY	ETF	310.42	310.42	310.3	310.34	9005.0
2019-12-03 05:50:00	SPY	ETF	310.46	310.55	310.41	310.5	3044.0
2019-12-03 05:55:00	SPY	ETF	310.46	310.46	310.4	310.4	11363.0
2019-12-03 06:00:00	SPY	ETF	310.52	310.55	310.52	310.55	2940.0
2019-12-03 06:05:00	SPY	ETF	310.52	310.57	310.44	310.47	8589.0
2019-12-03 06:10:00	SPY	ETF	310.47	310.5	310.45	310.5	7767.0
2019-12-03 06:15:00	SPY	ETF	310.5	310.5	310.37	310.43	2113.0
2019-12-03 06:20:00	SPY	ETF	310.44	310.71	310.44	310.71	2120.0
2019-12-03 06:25:00	SPY	ETF	310.65	310.65	310.65	310.65	100.0
2019-12-03 06:30:00	SPY	ETF	310.66	310.75	310.66	310.75	7467.0
2019-12-03 06:35:00	SPY	ETF	310.74	310.8	310.74	310.77	510.0
2019-12-03 06:40:00	SPY	ETF	310.73	310.75	310.69	310.74	2200.0
2019-12-03 06:45:00	SPY	ETF	310.82	310.82	310.75	310.8	1400.0
2019-12-03 06:50:00	SPY	ETF	310.77	310.77	310.71	310.71	1500.0
2019-12-03 06:55:00	SPY	ETF	310.79	310.87	310.79	310.84	7625.0
2019-12-03 07:00:00	SPY	ETF	310.86	310.86	310.74	310.74	40851.0
2019-12-03 07:05:00	SPY	ETF	310.75	310.75	310.64	310.67	6410.0
2019-12-03 07:10:00	SPY	ETF	310.64	310.67	310.58	310.58	37066.0
2019-12-03 07:15:00	SPY	ETF	310.58	310.6	310.53	310.58	26937.0
2019-12-03 07:20:00	SPY	ETF	310.55	310.57	310.54	310.54	3462.0
2019-12-03 07:25:00	SPY	ETF	310.57	310.6	310.54	310.6	4622.0
2019-12-03 07:30:00	SPY	ETF	310.59	310.61	310.55	310.6	5508.0
2019-12-03 07:35:00	SPY	ETF	310.57	310.57	310.57	310.57	1035.0
2019-12-03 07:40:00	SPY	ETF	310.55	310.63	309.99	310.04	127922.0
2019-12-03 07:45:00	SPY	ETF	310.07	310.22	310.06	310.08	54787.0
2019-12-03 07:50:00	SPY	ETF	310.1	310.15	309.78	309.791	68808.0
2019-12-03 07:55:00	SPY	ETF	309.8	309.97	309.8	309.9	59494.0
2019-12-03 08:00:00	SPY	ETF	309.9	312.25	309.7999	309.99	922212.0
2019-12-03 08:05:00	SPY	ETF	310.01	310.04	309.83	309.89	46373.0
2019-12-03 08:10:00	SPY	ETF	309.83	309.85	309.5	309.53	118311.0
2019-12-03 08:15:00	SPY	ETF	309.54	309.59	309.33	309.48	77659.0

> showing 50 of 65,949 rows — these rows as CSV

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