PREVIEW / etf_5min / 2017-06-29

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-29.parquet
  size:    1.3 MB
  rows:    56,115

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-29 04:00:00	SPY	ETF	243.82	243.82	243.8	243.8	2300.0
2017-06-29 04:05:00	SPY	ETF	243.8	243.8	243.78	243.78	430.0
2017-06-29 04:15:00	SPY	ETF	243.8	243.82	243.8	243.8	2050.0
2017-06-29 04:20:00	SPY	ETF	243.81	243.81	243.81	243.81	940.0
2017-06-29 04:25:00	SPY	ETF	243.77	243.77	243.77	243.77	2500.0
2017-06-29 04:30:00	SPY	ETF	243.83	243.83	243.83	243.83	100.0
2017-06-29 04:35:00	SPY	ETF	243.83	243.83	243.83	243.83	800.0
2017-06-29 04:55:00	SPY	ETF	243.82	243.83	243.82	243.83	720.0
2017-06-29 05:15:00	SPY	ETF	243.8	243.8	243.76	243.76	1510.0
2017-06-29 05:35:00	SPY	ETF	243.73	243.73	243.72	243.72	2475.0
2017-06-29 05:40:00	SPY	ETF	243.7	243.7	243.66	243.66	400.0
2017-06-29 05:45:00	SPY	ETF	243.63	243.63	243.59	243.59	1320.0
2017-06-29 05:55:00	SPY	ETF	243.7	243.7	243.7	243.7	5100.0
2017-06-29 06:00:00	SPY	ETF	243.68	243.7	243.66	243.68	7598.0
2017-06-29 06:05:00	SPY	ETF	243.65	243.67	243.65	243.65	3700.0
2017-06-29 06:10:00	SPY	ETF	243.65	243.65	243.58	243.58	1100.0
2017-06-29 06:15:00	SPY	ETF	243.68	243.68	243.63	243.63	500.0
2017-06-29 06:20:00	SPY	ETF	243.65	243.65	243.65	243.65	300.0
2017-06-29 06:25:00	SPY	ETF	243.65	243.68	243.65	243.68	1100.0
2017-06-29 06:30:00	SPY	ETF	243.65	243.65	243.65	243.65	3700.0
2017-06-29 06:35:00	SPY	ETF	243.65	243.65	243.65	243.65	1500.0
2017-06-29 06:40:00	SPY	ETF	243.65	243.65	243.6	243.6	3300.0
2017-06-29 06:45:00	SPY	ETF	243.63	243.64	243.63	243.64	600.0
2017-06-29 06:50:00	SPY	ETF	243.6	243.7	243.59	243.7	2930.0
2017-06-29 06:55:00	SPY	ETF	243.73	243.73	243.69	243.72	5650.0
2017-06-29 07:00:00	SPY	ETF	243.79	243.8	243.75	243.75	4550.0
2017-06-29 07:05:00	SPY	ETF	243.74	243.75	243.69	243.73	13463.0
2017-06-29 07:10:00	SPY	ETF	243.78	243.88	243.78	243.87	11555.0
2017-06-29 07:15:00	SPY	ETF	243.88	243.95	243.84	243.95	74776.0
2017-06-29 07:20:00	SPY	ETF	243.95	243.95	243.9	243.94	51768.0
2017-06-29 07:25:00	SPY	ETF	243.92	243.92	243.87	243.9	5250.0
2017-06-29 07:30:00	SPY	ETF	243.91	243.98	243.91	243.98	24888.0
2017-06-29 07:35:00	SPY	ETF	243.98	244.0	243.98	244.0	6574.0
2017-06-29 07:40:00	SPY	ETF	244.0	244.09	244.0	244.09	17763.0
2017-06-29 07:45:00	SPY	ETF	244.1	244.12	244.05	244.1	19126.0
2017-06-29 07:50:00	SPY	ETF	244.12	244.14	244.08	244.14	15217.0
2017-06-29 07:55:00	SPY	ETF	244.14	244.14	244.06	244.06	6738.0
2017-06-29 08:00:00	SPY	ETF	243.91	244.09	243.91	244.06	27960.0
2017-06-29 08:05:00	SPY	ETF	244.11	244.11	243.67	244.02	81328.0
2017-06-29 08:10:00	SPY	ETF	244.02	244.02	243.96	243.96	17693.0
2017-06-29 08:15:00	SPY	ETF	243.98	244.03	243.98	244.02	56516.0
2017-06-29 08:20:00	SPY	ETF	244.01	244.03	243.84	243.87	78100.0
2017-06-29 08:25:00	SPY	ETF	243.87	243.87	243.76	243.79	64804.0
2017-06-29 08:30:00	SPY	ETF	243.81	243.88	243.75	243.78	15441.0
2017-06-29 08:35:00	SPY	ETF	243.76	243.76	243.67	243.67	73358.0
2017-06-29 08:40:00	SPY	ETF	243.7	243.72	243.66	243.72	31045.0
2017-06-29 08:45:00	SPY	ETF	243.72	243.72	243.57	243.6	94119.0
2017-06-29 08:50:00	SPY	ETF	243.6	243.64	243.54	243.58	36729.0
2017-06-29 08:55:00	SPY	ETF	243.58	243.66	243.57	243.6	28367.0
2017-06-29 09:00:00	SPY	ETF	243.6	243.6	243.51	243.52	16856.0

> showing 50 of 56,115 rows — these rows as CSV

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