PREVIEW / etf_5min / 2017-05-31

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-31.parquet
  size:    1.2 MB
  rows:    53,100

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-05-31 04:05:00	SPY	ETF	241.66	241.66	241.66	241.66	200.0
2017-05-31 04:20:00	SPY	ETF	241.53	241.56	241.53	241.56	300.0
2017-05-31 05:15:00	SPY	ETF	241.43	241.43	241.42	241.42	200.0
2017-05-31 05:55:00	SPY	ETF	241.52	241.52	241.52	241.52	300.0
2017-05-31 06:25:00	SPY	ETF	241.54	241.54	241.54	241.54	800.0
2017-05-31 06:35:00	SPY	ETF	241.62	241.62	241.62	241.62	4000.0
2017-05-31 06:40:00	SPY	ETF	241.68	241.69	241.68	241.69	4100.0
2017-05-31 06:45:00	SPY	ETF	241.69	241.69	241.69	241.69	2500.0
2017-05-31 06:50:00	SPY	ETF	241.71	241.71	241.71	241.71	400.0
2017-05-31 06:55:00	SPY	ETF	241.69	241.69	241.69	241.69	300.0
2017-05-31 07:00:00	SPY	ETF	241.74	241.74	241.71	241.71	4503.0
2017-05-31 07:05:00	SPY	ETF	241.73	241.76	241.7	241.73	10700.0
2017-05-31 07:10:00	SPY	ETF	241.74	241.76	241.73	241.73	12000.0
2017-05-31 07:15:00	SPY	ETF	241.73	241.77	241.73	241.77	21720.0
2017-05-31 07:20:00	SPY	ETF	241.79	241.8	241.79	241.79	1691.0
2017-05-31 07:25:00	SPY	ETF	241.76	241.78	241.75	241.75	5900.0
2017-05-31 07:30:00	SPY	ETF	241.75	241.79	241.75	241.79	9721.0
2017-05-31 07:35:00	SPY	ETF	241.79	241.79	241.77	241.77	1338.0
2017-05-31 07:40:00	SPY	ETF	241.77	241.77	241.76	241.76	53207.0
2017-05-31 07:45:00	SPY	ETF	241.76	241.92	241.76	241.92	42197.0
2017-05-31 07:50:00	SPY	ETF	241.92	241.93	241.85	241.86	34216.0
2017-05-31 07:55:00	SPY	ETF	241.86	241.86	241.83	241.86	14767.0
2017-05-31 08:00:00	SPY	ETF	241.85	241.86	241.73	241.86	35157.0
2017-05-31 08:05:00	SPY	ETF	241.85	242.0	241.84	241.96	29964.0
2017-05-31 08:10:00	SPY	ETF	241.96	241.97	241.95	241.96	5050.0
2017-05-31 08:15:00	SPY	ETF	241.97	242.04	241.97	242.04	34090.0
2017-05-31 08:20:00	SPY	ETF	242.03	242.03	241.97	242.03	98629.0
2017-05-31 08:25:00	SPY	ETF	242.02	242.03	241.97	242.0	151802.0
2017-05-31 08:30:00	SPY	ETF	242.01	242.01	241.93	241.94	89000.0
2017-05-31 08:35:00	SPY	ETF	241.95	241.96	241.93	241.95	10051.0
2017-05-31 08:40:00	SPY	ETF	241.94	241.96	241.94	241.96	10101.0
2017-05-31 08:45:00	SPY	ETF	241.93	241.96	241.93	241.95	16620.0
2017-05-31 08:50:00	SPY	ETF	241.95	241.95	241.88	241.91	23781.0
2017-05-31 08:55:00	SPY	ETF	241.9	241.97	241.89	241.95	99666.0
2017-05-31 09:00:00	SPY	ETF	241.95	241.96	241.92	241.93	22750.0
2017-05-31 09:05:00	SPY	ETF	241.94	241.98	241.92	241.98	36633.0
2017-05-31 09:10:00	SPY	ETF	241.98	241.99	241.94	241.97	33222.0
2017-05-31 09:15:00	SPY	ETF	241.97	241.97	241.92	241.94	9803.0
2017-05-31 09:20:00	SPY	ETF	241.95	241.97	241.91	241.94	58907.0
2017-05-31 09:25:00	SPY	ETF	241.94	241.96	241.83	241.83	126381.0
2017-05-31 09:30:00	SPY	ETF	241.84	241.88	241.74	241.7427	1014446.0
2017-05-31 09:35:00	SPY	ETF	241.75	241.79	241.68	241.7505	671156.0
2017-05-31 09:40:00	SPY	ETF	241.755	241.8	241.71	241.725	580153.0
2017-05-31 09:45:00	SPY	ETF	241.7246	241.78	241.33	241.35	1244601.0
2017-05-31 09:50:00	SPY	ETF	241.35	241.47	241.24	241.25	1265131.0
2017-05-31 09:55:00	SPY	ETF	241.24	241.29	240.91	240.97	1401644.0
2017-05-31 10:00:00	SPY	ETF	240.98	240.995	240.65	240.85	1910364.0
2017-05-31 10:05:00	SPY	ETF	240.85	240.86	240.64	240.795	1403021.0
2017-05-31 10:10:00	SPY	ETF	240.8	240.98	240.66	240.9573	1787620.0
2017-05-31 10:15:00	SPY	ETF	240.96	241.02	240.81	240.89	1158350.0

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

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