PREVIEW / etf_5min / 2017-10-18

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-10-18.parquet
  size:    1.2 MB
  rows:    53,832

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
2017-10-18 04:15:00	SPY	ETF	255.5	255.5	255.49	255.49	5000.0
2017-10-18 05:20:00	SPY	ETF	255.54	255.54	255.54	255.54	3000.0
2017-10-18 05:25:00	SPY	ETF	255.57	255.57	255.57	255.57	500.0
2017-10-18 05:35:00	SPY	ETF	255.57	255.57	255.57	255.57	600.0
2017-10-18 05:40:00	SPY	ETF	255.57	255.58	255.57	255.58	4000.0
2017-10-18 05:45:00	SPY	ETF	255.62	255.62	255.62	255.62	5080.0
2017-10-18 05:50:00	SPY	ETF	255.77	255.77	255.77	255.77	100.0
2017-10-18 06:00:00	SPY	ETF	255.73	255.73	255.73	255.73	2500.0
2017-10-18 06:05:00	SPY	ETF	255.73	255.73	255.73	255.73	100.0
2017-10-18 06:20:00	SPY	ETF	255.67	255.67	255.67	255.67	100.0
2017-10-18 06:25:00	SPY	ETF	255.7	255.72	255.7	255.72	400.0
2017-10-18 06:40:00	SPY	ETF	255.73	255.76	255.73	255.76	1800.0
2017-10-18 06:45:00	SPY	ETF	255.78	255.78	255.78	255.78	3300.0
2017-10-18 06:50:00	SPY	ETF	255.78	255.82	255.77	255.79	7100.0
2017-10-18 06:55:00	SPY	ETF	255.83	255.83	255.83	255.83	2000.0
2017-10-18 07:00:00	SPY	ETF	255.85	255.85	255.82	255.84	7350.0
2017-10-18 07:05:00	SPY	ETF	255.82	255.82	255.82	255.82	190.0
2017-10-18 07:10:00	SPY	ETF	255.8	255.8	255.8	255.8	3028.0
2017-10-18 07:15:00	SPY	ETF	255.8	255.85	255.8	255.85	8950.0
2017-10-18 07:20:00	SPY	ETF	255.86	255.86	255.82	255.82	11365.0
2017-10-18 07:25:00	SPY	ETF	255.82	255.82	255.8	255.82	5635.0
2017-10-18 07:30:00	SPY	ETF	255.83	255.83	255.8	255.83	26226.0
2017-10-18 07:35:00	SPY	ETF	255.85	255.85	255.79	255.79	1169.0
2017-10-18 07:40:00	SPY	ETF	255.8	255.8	255.8	255.8	300.0
2017-10-18 07:45:00	SPY	ETF	255.81	255.81	255.8	255.8	4128.0
2017-10-18 07:50:00	SPY	ETF	255.82	255.82	255.82	255.82	200.0
2017-10-18 07:55:00	SPY	ETF	255.82	255.82	255.82	255.82	200.0
2017-10-18 08:00:00	SPY	ETF	255.81	255.86	255.75	255.8	646173.0
2017-10-18 08:05:00	SPY	ETF	255.75	255.79	255.75	255.79	4200.0
2017-10-18 08:10:00	SPY	ETF	255.8	255.84	255.8	255.83	3745.0
2017-10-18 08:15:00	SPY	ETF	255.84	255.9	255.84	255.9	19524.0
2017-10-18 08:20:00	SPY	ETF	255.89	255.92	255.89	255.91	10600.0
2017-10-18 08:25:00	SPY	ETF	255.9	255.91	255.9	255.9	2920.0
2017-10-18 08:30:00	SPY	ETF	255.88	255.89	255.86	255.86	7183.0
2017-10-18 08:35:00	SPY	ETF	255.88	255.89	255.87	255.87	10925.0
2017-10-18 08:40:00	SPY	ETF	255.87	255.87	255.83	255.83	20574.0
2017-10-18 08:45:00	SPY	ETF	255.82	255.85	255.82	255.83	28473.0
2017-10-18 08:50:00	SPY	ETF	255.85	255.86	255.83	255.85	42599.0
2017-10-18 08:55:00	SPY	ETF	255.83	255.84	255.82	255.83	4566.0
2017-10-18 09:00:00	SPY	ETF	255.83	255.89	255.83	255.87	58096.0
2017-10-18 09:05:00	SPY	ETF	255.88	255.89	255.88	255.89	3321.0
2017-10-18 09:10:00	SPY	ETF	255.89	255.98	255.89	255.95	95609.0
2017-10-18 09:15:00	SPY	ETF	255.95	255.97	255.94	255.94	19945.0
2017-10-18 09:20:00	SPY	ETF	255.93	255.95	255.93	255.95	19210.0
2017-10-18 09:25:00	SPY	ETF	255.94	255.95	255.9	255.91	64311.0
2017-10-18 09:30:00	SPY	ETF	255.9	255.93	255.82	255.88	1382836.0
2017-10-18 09:35:00	SPY	ETF	255.875	255.9	255.77	255.82	851349.0
2017-10-18 09:40:00	SPY	ETF	255.82	255.83	255.7	255.82	633206.0
2017-10-18 09:45:00	SPY	ETF	255.83	255.83	255.64	255.67	666072.0
2017-10-18 09:50:00	SPY	ETF	255.66	255.75	255.655	255.739	371745.0

> showing 50 of 53,832 rows — these rows as CSV

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