PREVIEW / etf_5min / 2019-11-21

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-11-21.parquet
  size:    1.4 MB
  rows:    60,418

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-11-21 04:00:00	SPY	ETF	310.42	310.42	310.4	310.4	1354.0
2019-11-21 04:05:00	SPY	ETF	310.39	310.41	310.34	310.41	500.0
2019-11-21 04:10:00	SPY	ETF	310.46	310.51	310.46	310.51	870.0
2019-11-21 04:15:00	SPY	ETF	310.46	310.46	310.38	310.38	1261.0
2019-11-21 04:20:00	SPY	ETF	310.34	310.38	310.32	310.34	1240.0
2019-11-21 04:25:00	SPY	ETF	310.34	310.34	310.32	310.34	4100.0
2019-11-21 04:30:00	SPY	ETF	310.34	310.4	310.34	310.4	800.0
2019-11-21 04:35:00	SPY	ETF	310.46	310.49	310.46	310.49	1100.0
2019-11-21 04:40:00	SPY	ETF	310.51	310.51	310.41	310.41	300.0
2019-11-21 04:45:00	SPY	ETF	310.44	310.44	310.44	310.44	300.0
2019-11-21 04:50:00	SPY	ETF	310.4	310.4	310.39	310.39	500.0
2019-11-21 04:55:00	SPY	ETF	310.41	310.41	310.41	310.41	300.0
2019-11-21 05:00:00	SPY	ETF	310.4	310.59	310.4	310.59	3981.0
2019-11-21 05:05:00	SPY	ETF	310.56	311.08	310.56	311.0	9610.0
2019-11-21 05:10:00	SPY	ETF	310.7	310.7	310.7	310.7	375.0
2019-11-21 05:15:00	SPY	ETF	310.81	311.14	310.81	311.14	3332.0
2019-11-21 05:20:00	SPY	ETF	311.16	311.22	311.16	311.22	7250.0
2019-11-21 05:25:00	SPY	ETF	311.1	311.1	310.93	310.93	1705.0
2019-11-21 05:30:00	SPY	ETF	310.95	310.95	310.86	310.86	1355.0
2019-11-21 05:35:00	SPY	ETF	310.83	310.83	310.68	310.76	2220.0
2019-11-21 05:40:00	SPY	ETF	310.76	310.76	310.72	310.72	263.0
2019-11-21 05:45:00	SPY	ETF	310.72	310.82	310.72	310.82	2402.0
2019-11-21 05:50:00	SPY	ETF	310.82	310.82	310.76	310.76	1035.0
2019-11-21 05:55:00	SPY	ETF	310.77	310.8	310.73	310.77	2600.0
2019-11-21 06:00:00	SPY	ETF	310.77	310.77	310.63	310.63	900.0
2019-11-21 06:10:00	SPY	ETF	310.66	310.71	310.66	310.71	7950.0
2019-11-21 06:15:00	SPY	ETF	310.71	310.71	310.69	310.69	3350.0
2019-11-21 06:20:00	SPY	ETF	310.75	310.75	310.72	310.72	2322.0
2019-11-21 06:25:00	SPY	ETF	310.7	310.7	310.7	310.7	1000.0
2019-11-21 06:30:00	SPY	ETF	310.7	310.7	310.7	310.7	100.0
2019-11-21 06:35:00	SPY	ETF	310.77	310.81	310.77	310.79	6330.0
2019-11-21 06:40:00	SPY	ETF	310.86	310.87	310.85	310.86	3400.0
2019-11-21 06:45:00	SPY	ETF	310.87	310.87	310.87	310.87	1450.0
2019-11-21 06:50:00	SPY	ETF	310.9	310.91	310.87	310.87	13750.0
2019-11-21 06:55:00	SPY	ETF	310.85	310.92	310.85	310.88	14500.0
2019-11-21 07:00:00	SPY	ETF	310.86	310.9	310.78	310.78	12048.0
2019-11-21 07:05:00	SPY	ETF	310.82	310.85	310.79	310.79	2858.0
2019-11-21 07:10:00	SPY	ETF	310.79	310.79	310.66	310.67	33739.0
2019-11-21 07:15:00	SPY	ETF	310.65	310.78	310.65	310.75	17410.0
2019-11-21 07:20:00	SPY	ETF	310.7	310.7	310.6	310.62	4276.0
2019-11-21 07:25:00	SPY	ETF	310.62	310.64	310.61	310.61	12925.0
2019-11-21 07:30:00	SPY	ETF	310.66	310.67	310.63	310.64	2551.0
2019-11-21 07:35:00	SPY	ETF	310.7	310.74	310.66	310.66	2490.0
2019-11-21 07:40:00	SPY	ETF	310.71	310.73	310.71	310.71	6914.0
2019-11-21 07:45:00	SPY	ETF	310.71	310.83	310.71	310.82	76328.0
2019-11-21 07:50:00	SPY	ETF	310.8	310.92	310.78	310.92	29166.0
2019-11-21 07:55:00	SPY	ETF	310.87	310.87	310.85	310.85	2719.0
2019-11-21 08:00:00	SPY	ETF	310.81	310.88	309.97	310.8	59184.0
2019-11-21 08:05:00	SPY	ETF	310.79	311.48	310.78	311.25	294376.0
2019-11-21 08:10:00	SPY	ETF	311.26	311.43	311.18	311.4	80063.0

> showing 50 of 60,418 rows — these rows as CSV

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