PREVIEW / etf_5min / 2017-06-13

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-13.parquet
  size:    1.2 MB
  rows:    53,093

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-06-13 04:00:00	SPY	ETF	243.77	243.97	243.77	243.92	9430.0
2017-06-13 04:05:00	SPY	ETF	243.86	243.89	243.86	243.88	8600.0
2017-06-13 04:10:00	SPY	ETF	243.9	243.92	243.9	243.92	4100.0
2017-06-13 04:20:00	SPY	ETF	243.85	243.85	243.85	243.85	200.0
2017-06-13 04:55:00	SPY	ETF	243.86	243.86	243.86	243.86	3500.0
2017-06-13 05:00:00	SPY	ETF	243.83	243.83	243.81	243.81	400.0
2017-06-13 05:05:00	SPY	ETF	243.81	243.81	243.81	243.81	1000.0
2017-06-13 05:10:00	SPY	ETF	243.83	243.83	243.83	243.83	1100.0
2017-06-13 05:15:00	SPY	ETF	243.78	243.78	243.78	243.78	1400.0
2017-06-13 05:20:00	SPY	ETF	243.73	243.73	243.73	243.73	100.0
2017-06-13 05:45:00	SPY	ETF	243.68	243.68	243.68	243.68	2500.0
2017-06-13 06:00:00	SPY	ETF	243.75	243.75	243.75	243.75	500.0
2017-06-13 06:15:00	SPY	ETF	243.77	243.77	243.77	243.77	500.0
2017-06-13 06:20:00	SPY	ETF	243.79	243.79	243.79	243.79	140.0
2017-06-13 06:45:00	SPY	ETF	243.73	243.73	243.73	243.73	100.0
2017-06-13 06:50:00	SPY	ETF	243.68	243.68	243.68	243.68	2600.0
2017-06-13 06:55:00	SPY	ETF	243.72	243.72	243.72	243.72	800.0
2017-06-13 07:00:00	SPY	ETF	243.68	243.75	243.68	243.7	20238.0
2017-06-13 07:05:00	SPY	ETF	243.74	243.74	243.7	243.7	5145.0
2017-06-13 07:10:00	SPY	ETF	243.68	243.7	243.68	243.7	3938.0
2017-06-13 07:15:00	SPY	ETF	243.71	243.71	243.68	243.7	17149.0
2017-06-13 07:20:00	SPY	ETF	243.71	243.71	243.71	243.71	1172.0
2017-06-13 07:25:00	SPY	ETF	243.69	243.69	243.69	243.69	1171.0
2017-06-13 07:30:00	SPY	ETF	243.71	243.73	243.71	243.73	2972.0
2017-06-13 07:35:00	SPY	ETF	243.71	243.71	243.7	243.7	1400.0
2017-06-13 07:40:00	SPY	ETF	243.7	243.7	243.68	243.68	4470.0
2017-06-13 07:45:00	SPY	ETF	243.69	243.69	243.68	243.69	13306.0
2017-06-13 07:50:00	SPY	ETF	243.71	243.71	243.7	243.7	400.0
2017-06-13 07:55:00	SPY	ETF	243.68	243.7	243.68	243.7	1675.0
2017-06-13 08:00:00	SPY	ETF	243.7	243.72	243.66	243.66	15632.0
2017-06-13 08:05:00	SPY	ETF	243.68	243.7	243.64	243.64	33145.0
2017-06-13 08:10:00	SPY	ETF	243.71	243.73	243.71	243.73	12120.0
2017-06-13 08:15:00	SPY	ETF	243.73	243.77	243.72	243.76	23121.0
2017-06-13 08:20:00	SPY	ETF	243.75	243.75	243.73	243.73	6958.0
2017-06-13 08:25:00	SPY	ETF	243.77	243.79	243.75	243.78	24433.0
2017-06-13 08:30:00	SPY	ETF	243.77	243.8	243.76	243.77	13235.0
2017-06-13 08:35:00	SPY	ETF	243.77	243.8	243.77	243.79	12900.0
2017-06-13 08:40:00	SPY	ETF	243.79	243.81	243.79	243.81	5889.0
2017-06-13 08:45:00	SPY	ETF	243.81	243.88	243.81	243.86	18682.0
2017-06-13 08:50:00	SPY	ETF	243.88	243.89	243.82	243.88	56688.0
2017-06-13 08:55:00	SPY	ETF	243.88	243.88	243.85	243.85	29445.0
2017-06-13 09:00:00	SPY	ETF	243.89	243.9	243.87	243.89	84258.0
2017-06-13 09:05:00	SPY	ETF	243.88	243.91	243.87	243.91	22025.0
2017-06-13 09:10:00	SPY	ETF	243.91	243.95	243.9	243.91	36550.0
2017-06-13 09:15:00	SPY	ETF	243.91	243.95	243.89	243.93	18031.0
2017-06-13 09:20:00	SPY	ETF	243.93	243.96	243.92	243.96	130684.0
2017-06-13 09:25:00	SPY	ETF	243.96	243.99	243.92	243.99	46115.0
2017-06-13 09:30:00	SPY	ETF	243.98	244.0897	243.95	244.03	2235775.0
2017-06-13 09:35:00	SPY	ETF	244.02	244.09	243.93	244.06	1064385.0
2017-06-13 09:40:00	SPY	ETF	244.06	244.27	244.06	244.25	1093381.0

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

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