PREVIEW / etf_5min / 2017-07-14

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-07-14.parquet
  size:    1.2 MB
  rows:    52,669

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-07-14 04:00:00	SPY	ETF	244.31	244.31	244.31	244.31	156.0
2017-07-14 04:15:00	SPY	ETF	244.2	244.2	244.2	244.2	100.0
2017-07-14 04:50:00	SPY	ETF	244.17	244.17	244.17	244.17	100.0
2017-07-14 04:55:00	SPY	ETF	244.18	244.2	244.18	244.2	4400.0
2017-07-14 05:00:00	SPY	ETF	244.16	244.16	244.16	244.16	1000.0
2017-07-14 05:25:00	SPY	ETF	244.19	244.19	244.19	244.19	200.0
2017-07-14 05:30:00	SPY	ETF	244.14	244.14	244.13	244.13	305.0
2017-07-14 06:10:00	SPY	ETF	244.21	244.21	244.21	244.21	140.0
2017-07-14 06:20:00	SPY	ETF	244.21	244.21	244.2	244.2	500.0
2017-07-14 06:30:00	SPY	ETF	244.22	244.24	244.22	244.24	300.0
2017-07-14 06:40:00	SPY	ETF	244.25	244.35	244.23	244.35	7130.0
2017-07-14 06:50:00	SPY	ETF	244.35	244.35	244.35	244.35	1301.0
2017-07-14 06:55:00	SPY	ETF	244.35	244.35	244.33	244.33	5400.0
2017-07-14 07:00:00	SPY	ETF	244.35	244.35	244.33	244.33	4401.0
2017-07-14 07:05:00	SPY	ETF	244.32	244.35	244.31	244.31	8170.0
2017-07-14 07:10:00	SPY	ETF	244.33	244.33	244.3	244.3	1901.0
2017-07-14 07:15:00	SPY	ETF	244.32	244.33	244.3	244.3	16101.0
2017-07-14 07:20:00	SPY	ETF	244.3	244.3	244.3	244.3	3062.0
2017-07-14 07:25:00	SPY	ETF	244.3	244.3	244.3	244.3	100.0
2017-07-14 07:30:00	SPY	ETF	244.3	244.34	244.3	244.34	1671.0
2017-07-14 07:40:00	SPY	ETF	244.34	244.34	244.34	244.34	212.0
2017-07-14 07:45:00	SPY	ETF	244.31	244.36	244.31	244.36	1869.0
2017-07-14 07:50:00	SPY	ETF	244.36	244.36	244.36	244.36	369.0
2017-07-14 07:55:00	SPY	ETF	244.37	244.37	244.36	244.37	13069.0
2017-07-14 08:00:00	SPY	ETF	244.35	244.38	244.3	244.33	31358.0
2017-07-14 08:05:00	SPY	ETF	244.32	244.32	244.26	244.27	29613.0
2017-07-14 08:10:00	SPY	ETF	244.29	244.29	244.29	244.29	5351.0
2017-07-14 08:15:00	SPY	ETF	244.3	244.3	244.29	244.29	2892.0
2017-07-14 08:20:00	SPY	ETF	244.29	244.31	244.26	244.3	50396.0
2017-07-14 08:25:00	SPY	ETF	244.34	244.39	244.34	244.39	19824.0
2017-07-14 08:30:00	SPY	ETF	244.39	244.56	244.39	244.45	186006.0
2017-07-14 08:35:00	SPY	ETF	244.42	244.48	244.41	244.44	19292.0
2017-07-14 08:40:00	SPY	ETF	244.42	244.49	244.42	244.49	43419.0
2017-07-14 08:45:00	SPY	ETF	244.47	244.55	244.45	244.45	58304.0
2017-07-14 08:50:00	SPY	ETF	244.47	244.6	244.46	244.59	97416.0
2017-07-14 08:55:00	SPY	ETF	244.56	244.76	244.55	244.76	136405.0
2017-07-14 09:00:00	SPY	ETF	244.72	244.76	244.67	244.7	172129.0
2017-07-14 09:05:00	SPY	ETF	244.7	244.72	244.63	244.63	60001.0
2017-07-14 09:10:00	SPY	ETF	244.63	244.63	244.57	244.57	40475.0
2017-07-14 09:15:00	SPY	ETF	244.58	244.58	244.47	244.47	77439.0
2017-07-14 09:20:00	SPY	ETF	244.47	244.51	244.45	244.5	93574.0
2017-07-14 09:25:00	SPY	ETF	244.5	244.62	244.42	244.43	514134.0
2017-07-14 09:30:00	SPY	ETF	244.43	244.57	244.31	244.5	1779761.0
2017-07-14 09:35:00	SPY	ETF	244.5	244.71	244.48	244.7	850931.0
2017-07-14 09:40:00	SPY	ETF	244.7	244.78	244.7	244.765	632707.0
2017-07-14 09:45:00	SPY	ETF	244.77	244.87	244.765	244.82	465740.0
2017-07-14 09:50:00	SPY	ETF	244.82	244.87	244.77	244.77	402213.0
2017-07-14 09:55:00	SPY	ETF	244.77	244.795	244.71	244.72	463885.0
2017-07-14 10:00:00	SPY	ETF	244.725	244.74	244.6299	244.68	396665.0
2017-07-14 10:05:00	SPY	ETF	244.69	244.7	244.58	244.61	421158.0

> showing 50 of 52,669 rows — these rows as CSV

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