PREVIEW / etf_5min / 2018-01-04

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-01-04.parquet
  size:    1.5 MB
  rows:    63,407

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
2018-01-04 04:00:00	SPY	ETF	270.5	270.5	270.5	270.5	100.0
2018-01-04 04:05:00	SPY	ETF	270.72	270.72	270.71	270.71	18830.0
2018-01-04 04:10:00	SPY	ETF	270.71	270.71	270.69	270.69	12465.0
2018-01-04 04:15:00	SPY	ETF	270.69	270.69	270.69	270.69	2017.0
2018-01-04 04:20:00	SPY	ETF	270.69	270.69	270.66	270.66	8500.0
2018-01-04 04:25:00	SPY	ETF	270.66	270.66	270.66	270.66	400.0
2018-01-04 04:35:00	SPY	ETF	270.66	270.68	270.66	270.68	900.0
2018-01-04 04:40:00	SPY	ETF	270.68	270.7	270.68	270.7	600.0
2018-01-04 04:45:00	SPY	ETF	270.78	270.82	270.78	270.82	420.0
2018-01-04 04:50:00	SPY	ETF	270.86	270.86	270.86	270.86	1415.0
2018-01-04 04:55:00	SPY	ETF	270.86	270.87	270.83	270.84	3900.0
2018-01-04 05:00:00	SPY	ETF	270.81	270.81	270.81	270.81	3500.0
2018-01-04 05:05:00	SPY	ETF	270.79	270.79	270.79	270.79	1000.0
2018-01-04 05:10:00	SPY	ETF	270.78	270.78	270.78	270.78	600.0
2018-01-04 05:20:00	SPY	ETF	270.77	270.77	270.77	270.77	100.0
2018-01-04 05:30:00	SPY	ETF	270.73	270.75	270.7	270.7	4700.0
2018-01-04 05:35:00	SPY	ETF	270.68	270.68	270.68	270.68	300.0
2018-01-04 05:45:00	SPY	ETF	270.68	270.68	270.68	270.68	8800.0
2018-01-04 05:50:00	SPY	ETF	270.64	270.69	270.64	270.69	500.0
2018-01-04 06:05:00	SPY	ETF	270.61	270.65	270.61	270.65	300.0
2018-01-04 06:10:00	SPY	ETF	270.66	270.66	270.66	270.66	300.0
2018-01-04 06:15:00	SPY	ETF	270.68	270.68	270.68	270.68	400.0
2018-01-04 06:25:00	SPY	ETF	270.78	270.78	270.78	270.78	2000.0
2018-01-04 06:40:00	SPY	ETF	270.68	270.77	270.68	270.77	3800.0
2018-01-04 06:55:00	SPY	ETF	270.73	270.81	270.73	270.78	9950.0
2018-01-04 07:00:00	SPY	ETF	270.78	270.83	270.78	270.83	14110.0
2018-01-04 07:05:00	SPY	ETF	270.81	270.86	270.81	270.86	600.0
2018-01-04 07:10:00	SPY	ETF	270.85	270.87	270.83	270.86	29614.0
2018-01-04 07:15:00	SPY	ETF	270.86	270.94	270.86	270.94	157681.0
2018-01-04 07:20:00	SPY	ETF	270.92	270.96	270.92	270.96	15300.0
2018-01-04 07:25:00	SPY	ETF	270.95	271.05	270.95	271.05	165193.0
2018-01-04 07:30:00	SPY	ETF	271.05	271.05	270.91	270.94	34503.0
2018-01-04 07:35:00	SPY	ETF	270.91	270.95	270.91	270.92	6676.0
2018-01-04 07:40:00	SPY	ETF	270.95	270.95	270.92	270.92	1050.0
2018-01-04 07:45:00	SPY	ETF	270.94	270.94	270.9	270.9	4406.0
2018-01-04 07:50:00	SPY	ETF	270.89	270.92	270.89	270.92	4510.0
2018-01-04 07:55:00	SPY	ETF	270.9	270.91	270.84	270.86	3728.0
2018-01-04 08:00:00	SPY	ETF	270.84	270.93	270.79	270.92	413636.0
2018-01-04 08:05:00	SPY	ETF	270.9	270.9	270.86	270.88	22100.0
2018-01-04 08:10:00	SPY	ETF	270.9	271.0	270.9	271.0	20339.0
2018-01-04 08:15:00	SPY	ETF	271.03	271.08	271.0	271.08	38223.0
2018-01-04 08:20:00	SPY	ETF	271.06	271.15	271.05	271.14	20144.0
2018-01-04 08:25:00	SPY	ETF	271.15	271.18	271.14	271.15	17678.0
2018-01-04 08:30:00	SPY	ETF	271.15	271.16	271.08	271.08	19912.0
2018-01-04 08:35:00	SPY	ETF	271.1	271.19	271.1	271.17	7253.0
2018-01-04 08:40:00	SPY	ETF	271.17	271.18	271.14	271.14	50213.0
2018-01-04 08:45:00	SPY	ETF	271.15	271.18	271.12	271.12	43310.0
2018-01-04 08:50:00	SPY	ETF	271.11	271.17	271.1	271.14	10229.0
2018-01-04 08:55:00	SPY	ETF	271.11	271.12	271.05	271.12	54599.0
2018-01-04 09:00:00	SPY	ETF	271.13	271.18	271.12	271.17	31572.0

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

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