PREVIEW / etf_5min / 2019-01-17

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-01-17.parquet
  size:    1.4 MB
  rows:    62,871

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-01-17 04:00:00	SPY	ETF	259.76	259.8	259.61	259.61	2900.0
2019-01-17 04:05:00	SPY	ETF	259.76	259.76	259.76	259.76	650.0
2019-01-17 04:10:00	SPY	ETF	259.81	259.81	259.7	259.7	650.0
2019-01-17 04:15:00	SPY	ETF	259.82	259.82	259.82	259.82	300.0
2019-01-17 04:20:00	SPY	ETF	259.68	259.85	259.68	259.78	1005.0
2019-01-17 04:25:00	SPY	ETF	259.84	259.91	259.84	259.91	20450.0
2019-01-17 04:30:00	SPY	ETF	259.72	259.72	259.72	259.72	600.0
2019-01-17 04:35:00	SPY	ETF	259.71	259.71	259.71	259.71	105.0
2019-01-17 04:40:00	SPY	ETF	259.66	259.66	259.49	259.49	2161.0
2019-01-17 04:45:00	SPY	ETF	259.58	259.76	259.57	259.57	4000.0
2019-01-17 04:50:00	SPY	ETF	259.52	259.52	259.31	259.39	2593.0
2019-01-17 04:55:00	SPY	ETF	259.36	259.56	259.32	259.49	2000.0
2019-01-17 05:00:00	SPY	ETF	259.6	259.76	259.6	259.69	15401.0
2019-01-17 05:05:00	SPY	ETF	259.72	259.75	259.69	259.69	650.0
2019-01-17 05:10:00	SPY	ETF	259.78	259.78	259.76	259.76	1300.0
2019-01-17 05:15:00	SPY	ETF	259.8	259.8	259.76	259.76	900.0
2019-01-17 05:20:00	SPY	ETF	259.97	259.97	259.91	259.93	810.0
2019-01-17 05:25:00	SPY	ETF	259.97	259.97	259.91	259.91	9100.0
2019-01-17 05:30:00	SPY	ETF	259.91	259.91	259.91	259.91	200.0
2019-01-17 05:35:00	SPY	ETF	260.0	260.01	259.81	259.81	2090.0
2019-01-17 05:40:00	SPY	ETF	259.82	259.82	259.76	259.78	31140.0
2019-01-17 05:45:00	SPY	ETF	259.83	259.95	259.83	259.95	1800.0
2019-01-17 05:50:00	SPY	ETF	259.93	259.93	259.93	259.93	300.0
2019-01-17 05:55:00	SPY	ETF	259.98	260.02	259.98	260.02	2500.0
2019-01-17 06:00:00	SPY	ETF	260.07	260.07	260.02	260.04	1700.0
2019-01-17 06:05:00	SPY	ETF	260.0	260.0	259.96	259.96	1200.0
2019-01-17 06:10:00	SPY	ETF	259.96	259.96	259.96	259.96	200.0
2019-01-17 06:15:00	SPY	ETF	259.99	259.99	259.97	259.98	550.0
2019-01-17 06:20:00	SPY	ETF	259.96	259.96	259.96	259.96	600.0
2019-01-17 06:25:00	SPY	ETF	259.94	260.02	259.94	260.02	930.0
2019-01-17 06:30:00	SPY	ETF	260.04	260.08	260.04	260.07	20300.0
2019-01-17 06:35:00	SPY	ETF	260.09	260.18	260.05	260.18	13501.0
2019-01-17 06:40:00	SPY	ETF	260.02	260.02	259.94	259.95	15007.0
2019-01-17 06:45:00	SPY	ETF	259.95	259.95	259.86	259.86	3363.0
2019-01-17 06:50:00	SPY	ETF	259.85	259.85	259.79	259.84	6697.0
2019-01-17 06:55:00	SPY	ETF	259.84	259.93	259.84	259.93	2207.0
2019-01-17 07:00:00	SPY	ETF	260.0	260.0	259.94	260.0	13945.0
2019-01-17 07:05:00	SPY	ETF	259.97	259.97	259.79	259.79	7307.0
2019-01-17 07:10:00	SPY	ETF	259.85	259.95	259.8	259.95	3201.0
2019-01-17 07:15:00	SPY	ETF	259.9	259.9	259.5	259.6	58494.0
2019-01-17 07:20:00	SPY	ETF	259.63	259.68	259.57	259.57	16850.0
2019-01-17 07:25:00	SPY	ETF	259.58	259.7	259.5	259.67	17433.0
2019-01-17 07:30:00	SPY	ETF	259.68	259.7	259.62	259.68	15332.0
2019-01-17 07:35:00	SPY	ETF	259.66	259.8	259.65	259.8	16101.0
2019-01-17 07:40:00	SPY	ETF	259.78	259.85	259.7	259.7	28945.0
2019-01-17 07:45:00	SPY	ETF	259.74	259.75	259.7	259.7	15593.0
2019-01-17 07:50:00	SPY	ETF	259.78	259.79	259.71	259.71	3830.0
2019-01-17 07:55:00	SPY	ETF	259.7	259.75	259.67	259.72	6256.0
2019-01-17 08:00:00	SPY	ETF	259.82	259.98	259.1	259.84	57994.0
2019-01-17 08:05:00	SPY	ETF	259.82	259.97	259.82	259.93	58436.0

> showing 50 of 62,871 rows — these rows as CSV

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