PREVIEW / etf_5min / 2019-04-24

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-04-24.parquet
  size:    1.4 MB
  rows:    63,182

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-04-24 04:00:00	SPY	ETF	292.71	292.71	292.43	292.5	5450.0
2019-04-24 04:10:00	SPY	ETF	292.5	292.62	292.45	292.62	3110.0
2019-04-24 04:40:00	SPY	ETF	292.73	292.73	292.7	292.7	750.0
2019-04-24 04:55:00	SPY	ETF	292.72	292.72	292.72	292.72	1000.0
2019-04-24 05:00:00	SPY	ETF	292.7	292.7	292.7	292.7	300.0
2019-04-24 05:15:00	SPY	ETF	292.82	292.86	292.82	292.86	333.0
2019-04-24 05:20:00	SPY	ETF	292.93	292.95	292.93	292.95	679.0
2019-04-24 05:25:00	SPY	ETF	292.89	292.89	292.85	292.85	300.0
2019-04-24 05:35:00	SPY	ETF	292.9	292.9	292.9	292.9	200.0
2019-04-24 05:45:00	SPY	ETF	292.93	293.02	292.93	293.02	1329.0
2019-04-24 05:50:00	SPY	ETF	292.96	292.96	292.96	292.96	100.0
2019-04-24 05:55:00	SPY	ETF	292.95	292.95	292.95	292.95	2400.0
2019-04-24 06:00:00	SPY	ETF	293.01	293.05	293.01	293.05	919.0
2019-04-24 06:05:00	SPY	ETF	293.03	293.03	293.0	293.0	1289.0
2019-04-24 06:10:00	SPY	ETF	293.06	293.1	293.06	293.1	3079.0
2019-04-24 06:15:00	SPY	ETF	293.06	293.06	293.06	293.06	301.0
2019-04-24 06:20:00	SPY	ETF	293.0	293.0	293.0	293.0	500.0
2019-04-24 06:45:00	SPY	ETF	292.95	292.97	292.94	292.97	780.0
2019-04-24 06:50:00	SPY	ETF	293.02	293.02	292.98	292.98	1297.0
2019-04-24 07:00:00	SPY	ETF	292.97	293.03	292.95	293.03	7138.0
2019-04-24 07:05:00	SPY	ETF	293.02	293.02	293.0	293.0	18234.0
2019-04-24 07:10:00	SPY	ETF	292.94	292.94	292.9	292.9	2142.0
2019-04-24 07:15:00	SPY	ETF	292.93	292.93	292.93	292.93	200.0
2019-04-24 07:20:00	SPY	ETF	292.93	292.94	292.93	292.94	360.0
2019-04-24 07:25:00	SPY	ETF	292.93	292.93	292.93	292.93	5000.0
2019-04-24 07:30:00	SPY	ETF	292.94	293.0	292.84	293.0	13950.0
2019-04-24 07:35:00	SPY	ETF	293.0	293.0	292.99	292.99	54198.0
2019-04-24 07:40:00	SPY	ETF	292.97	292.97	292.95	292.95	693.0
2019-04-24 07:45:00	SPY	ETF	292.94	292.99	292.94	292.99	5625.0
2019-04-24 07:50:00	SPY	ETF	292.99	293.0	292.9	292.938	2826.0
2019-04-24 07:55:00	SPY	ETF	292.92	292.95	292.92	292.95	450.0
2019-04-24 08:00:00	SPY	ETF	293.0	293.01	292.56	292.96	42302.0
2019-04-24 08:05:00	SPY	ETF	292.94	292.96	292.94	292.95	400.0
2019-04-24 08:10:00	SPY	ETF	292.95	293.05	292.95	293.04	58567.0
2019-04-24 08:15:00	SPY	ETF	293.08	293.11	293.03	293.11	56305.0
2019-04-24 08:20:00	SPY	ETF	293.09	293.11	293.0499	293.05	33954.0
2019-04-24 08:25:00	SPY	ETF	293.06	293.06	293.0	293.01	11599.0
2019-04-24 08:30:00	SPY	ETF	293.03	293.03	293.0	293.0	3955.0
2019-04-24 08:35:00	SPY	ETF	292.98	292.99	292.88	292.89	15645.0
2019-04-24 08:40:00	SPY	ETF	292.91	292.91	292.9	292.9	48339.0
2019-04-24 08:45:00	SPY	ETF	292.9	292.95	292.89	292.94	12081.0
2019-04-24 08:50:00	SPY	ETF	292.95	292.99	292.94	292.98	65548.0
2019-04-24 08:55:00	SPY	ETF	293.0	293.0	292.91	292.95	21010.0
2019-04-24 09:00:00	SPY	ETF	292.92	292.92	292.8	292.86	54524.0
2019-04-24 09:05:00	SPY	ETF	292.86	292.86	292.76	292.8	75028.0
2019-04-24 09:10:00	SPY	ETF	292.81	292.83	292.75	292.79	111159.0
2019-04-24 09:15:00	SPY	ETF	292.79	292.83	292.75	292.78	68151.0
2019-04-24 09:20:00	SPY	ETF	292.77	292.84	292.75	292.84	14495.0
2019-04-24 09:25:00	SPY	ETF	292.84	292.89	292.76	292.76	19117.0
2019-04-24 09:30:00	SPY	ETF	292.79	292.83	292.54	292.64	1276886.0

> showing 50 of 63,182 rows — these rows as CSV

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