PREVIEW / etf_5min / 2017-04-27

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-04-27.parquet
  size:    1.2 MB
  rows:    52,952

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-04-27 04:35:00	SPY	ETF	238.4	238.41	238.4	238.41	2452.0
2017-04-27 04:45:00	SPY	ETF	238.34	238.34	238.34	238.34	100.0
2017-04-27 04:50:00	SPY	ETF	238.33	238.33	238.33	238.33	200.0
2017-04-27 05:00:00	SPY	ETF	238.28	238.32	238.28	238.32	303.0
2017-04-27 05:05:00	SPY	ETF	238.32	238.32	238.32	238.32	100.0
2017-04-27 05:30:00	SPY	ETF	238.38	238.38	238.36	238.36	1200.0
2017-04-27 05:35:00	SPY	ETF	238.36	238.36	238.34	238.34	1201.0
2017-04-27 05:40:00	SPY	ETF	238.36	238.36	238.36	238.36	500.0
2017-04-27 05:45:00	SPY	ETF	238.36	238.36	238.34	238.34	200.0
2017-04-27 05:50:00	SPY	ETF	238.33	238.37	238.31	238.37	5002.0
2017-04-27 06:05:00	SPY	ETF	238.36	238.36	238.35	238.35	600.0
2017-04-27 06:10:00	SPY	ETF	238.33	238.33	238.33	238.33	253.0
2017-04-27 06:20:00	SPY	ETF	238.31	238.31	238.31	238.31	600.0
2017-04-27 06:35:00	SPY	ETF	238.39	238.39	238.39	238.39	1503.0
2017-04-27 06:40:00	SPY	ETF	238.32	238.36	238.32	238.36	3800.0
2017-04-27 06:45:00	SPY	ETF	238.36	238.36	238.36	238.36	100.0
2017-04-27 06:50:00	SPY	ETF	238.37	238.39	238.37	238.39	651.0
2017-04-27 06:55:00	SPY	ETF	238.41	238.49	238.41	238.44	9610.0
2017-04-27 07:00:00	SPY	ETF	238.44	238.44	238.43	238.44	2201.0
2017-04-27 07:05:00	SPY	ETF	238.45	238.46	238.45	238.46	500.0
2017-04-27 07:10:00	SPY	ETF	238.46	238.48	238.45	238.48	6006.0
2017-04-27 07:15:00	SPY	ETF	238.49	238.62	238.49	238.62	44008.0
2017-04-27 07:20:00	SPY	ETF	238.6	238.6	238.58	238.6	4451.0
2017-04-27 07:25:00	SPY	ETF	238.57	238.73	238.55	238.73	67778.0
2017-04-27 07:30:00	SPY	ETF	238.69	238.69	238.66	238.67	12633.0
2017-04-27 07:35:00	SPY	ETF	238.66	238.7	238.66	238.7	29112.0
2017-04-27 07:40:00	SPY	ETF	238.69	238.7	238.64	238.64	32236.0
2017-04-27 07:45:00	SPY	ETF	238.64	238.65	238.6	238.65	49986.0
2017-04-27 07:50:00	SPY	ETF	238.65	238.66	238.63	238.66	60401.0
2017-04-27 07:55:00	SPY	ETF	238.63	238.65	238.6	238.6	18576.0
2017-04-27 08:00:00	SPY	ETF	238.6	238.71	238.37	238.67	108619.0
2017-04-27 08:05:00	SPY	ETF	238.37	238.72	238.37	238.62	137096.0
2017-04-27 08:10:00	SPY	ETF	238.65	238.65	238.59	238.63	35649.0
2017-04-27 08:15:00	SPY	ETF	238.65	238.66	238.63	238.66	11953.0
2017-04-27 08:20:00	SPY	ETF	238.66	238.67	238.61	238.61	11551.0
2017-04-27 08:25:00	SPY	ETF	238.63	238.65	238.6	238.62	17287.0
2017-04-27 08:30:00	SPY	ETF	238.62	238.65	238.58	238.63	29103.0
2017-04-27 08:35:00	SPY	ETF	238.63	238.73	238.6	238.71	54999.0
2017-04-27 08:40:00	SPY	ETF	238.71	238.75	238.69	238.69	24752.0
2017-04-27 08:45:00	SPY	ETF	238.7	238.72	238.68	238.7	94113.0
2017-04-27 08:50:00	SPY	ETF	238.7	238.7	238.42	238.5	172262.0
2017-04-27 08:55:00	SPY	ETF	238.52	238.61	238.52	238.56	92198.0
2017-04-27 09:00:00	SPY	ETF	238.57	238.6	238.51	238.52	26749.0
2017-04-27 09:05:00	SPY	ETF	238.52	238.6	238.48	238.55	39620.0
2017-04-27 09:10:00	SPY	ETF	238.54	238.7	238.54	238.64	45037.0
2017-04-27 09:15:00	SPY	ETF	238.66	238.73	238.66	238.71	42183.0
2017-04-27 09:20:00	SPY	ETF	238.71	238.74	238.69	238.7	13089.0
2017-04-27 09:25:00	SPY	ETF	238.7	238.79	238.69	238.76	31103.0
2017-04-27 09:30:00	SPY	ETF	238.77	238.8	238.4432	238.45	1814739.0
2017-04-27 09:35:00	SPY	ETF	238.46	238.59	238.43	238.49	948165.0

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

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