PREVIEW / etf_5min / 2018-02-12

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-12.parquet
  size:    1.5 MB
  rows:    65,778

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-02-12 04:00:00	SPY	ETF	263.48	265.26	263.48	265.14	13181.0
2018-02-12 04:05:00	SPY	ETF	265.17	265.31	265.17	265.29	6935.0
2018-02-12 04:10:00	SPY	ETF	265.29	265.29	264.93	265.09	10870.0
2018-02-12 04:15:00	SPY	ETF	264.99	265.04	264.84	264.91	18510.0
2018-02-12 04:20:00	SPY	ETF	264.79	265.13	264.69	264.69	14425.0
2018-02-12 04:25:00	SPY	ETF	264.75	264.77	264.54	264.54	8389.0
2018-02-12 04:30:00	SPY	ETF	264.56	264.68	264.56	264.68	1015.0
2018-02-12 04:40:00	SPY	ETF	264.72	264.76	264.61	264.73	9700.0
2018-02-12 04:45:00	SPY	ETF	264.75	264.92	264.75	264.83	3675.0
2018-02-12 04:50:00	SPY	ETF	264.78	264.78	264.72	264.72	950.0
2018-02-12 04:55:00	SPY	ETF	265.0	265.08	264.95	264.95	520.0
2018-02-12 05:00:00	SPY	ETF	264.91	264.91	264.91	264.91	100.0
2018-02-12 05:05:00	SPY	ETF	264.73	264.78	264.73	264.78	2516.0
2018-02-12 05:10:00	SPY	ETF	264.91	264.91	264.77	264.77	6350.0
2018-02-12 05:15:00	SPY	ETF	264.88	264.91	264.88	264.91	208.0
2018-02-12 05:20:00	SPY	ETF	264.77	264.82	264.7	264.7	3768.0
2018-02-12 05:25:00	SPY	ETF	264.67	264.67	264.57	264.6	3800.0
2018-02-12 05:30:00	SPY	ETF	264.61	264.8	264.55	264.8	8500.0
2018-02-12 05:35:00	SPY	ETF	264.8	264.88	264.76	264.76	6000.0
2018-02-12 05:40:00	SPY	ETF	264.63	264.63	264.51	264.6	6000.0
2018-02-12 05:45:00	SPY	ETF	264.66	264.66	264.29	264.51	2700.0
2018-02-12 05:50:00	SPY	ETF	264.55	264.59	264.48	264.48	13607.0
2018-02-12 05:55:00	SPY	ETF	264.48	264.77	264.46	264.77	32008.0
2018-02-12 06:00:00	SPY	ETF	264.69	264.8	264.69	264.75	4500.0
2018-02-12 06:05:00	SPY	ETF	264.66	264.92	264.63	264.85	2591.0
2018-02-12 06:10:00	SPY	ETF	264.85	264.87	264.6	264.7	6721.0
2018-02-12 06:15:00	SPY	ETF	264.75	264.81	264.75	264.75	2500.0
2018-02-12 06:20:00	SPY	ETF	264.64	264.79	264.64	264.65	1700.0
2018-02-12 06:25:00	SPY	ETF	264.7	264.7	264.7	264.7	200.0
2018-02-12 06:30:00	SPY	ETF	264.74	264.76	264.68	264.68	1850.0
2018-02-12 06:35:00	SPY	ETF	264.64	264.69	264.48	264.48	6300.0
2018-02-12 06:40:00	SPY	ETF	264.4	264.55	264.35	264.55	7264.0
2018-02-12 06:45:00	SPY	ETF	264.48	264.52	264.47	264.52	3650.0
2018-02-12 06:50:00	SPY	ETF	264.39	264.44	264.35	264.37	20585.0
2018-02-12 06:55:00	SPY	ETF	264.39	264.39	264.25	264.27	42643.0
2018-02-12 07:00:00	SPY	ETF	264.4	264.74	264.27	264.69	41681.0
2018-02-12 07:05:00	SPY	ETF	264.74	264.75	264.59	264.62	26683.0
2018-02-12 07:10:00	SPY	ETF	264.57	264.6	264.4	264.47	135073.0
2018-02-12 07:15:00	SPY	ETF	264.42	264.75	264.38	264.69	85441.0
2018-02-12 07:20:00	SPY	ETF	264.67	265.02	264.65	264.97	36968.0
2018-02-12 07:25:00	SPY	ETF	264.9	264.98	264.82	264.83	64046.0
2018-02-12 07:30:00	SPY	ETF	264.84	264.87	264.75	264.79	56808.0
2018-02-12 07:35:00	SPY	ETF	264.77	264.93	264.77	264.93	58417.0
2018-02-12 07:40:00	SPY	ETF	264.94	264.97	264.56	264.6	30581.0
2018-02-12 07:45:00	SPY	ETF	264.59	264.68	264.38	264.38	54985.0
2018-02-12 07:50:00	SPY	ETF	264.4	264.6	264.4	264.6	12565.0
2018-02-12 07:55:00	SPY	ETF	264.57	264.68	264.54	264.6	32180.0
2018-02-12 08:00:00	SPY	ETF	264.61	264.94	263.22	264.59	118381.0
2018-02-12 08:05:00	SPY	ETF	264.56	264.62	264.45	264.62	33134.0
2018-02-12 08:10:00	SPY	ETF	264.59	264.8	264.55	264.8	48387.0

> showing 50 of 65,778 rows — these rows as CSV

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