PREVIEW / etf_5min / 2017-03-10

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-10.parquet
  size:    1.3 MB
  rows:    54,743

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-03-10 04:00:00	SPY	ETF	237.71	237.75	237.64	237.75	1881.0
2017-03-10 04:05:00	SPY	ETF	237.8	237.85	237.8	237.82	1569.0
2017-03-10 04:15:00	SPY	ETF	237.8	237.8	237.8	237.8	1000.0
2017-03-10 04:20:00	SPY	ETF	237.73	237.73	237.73	237.73	100.0
2017-03-10 04:25:00	SPY	ETF	237.74	237.74	237.73	237.73	400.0
2017-03-10 04:30:00	SPY	ETF	237.72	237.72	237.72	237.72	700.0
2017-03-10 04:35:00	SPY	ETF	237.78	237.79	237.73	237.73	420.0
2017-03-10 04:40:00	SPY	ETF	237.75	237.75	237.7	237.73	800.0
2017-03-10 04:45:00	SPY	ETF	237.63	237.63	237.63	237.63	100.0
2017-03-10 04:55:00	SPY	ETF	237.68	237.68	237.68	237.68	200.0
2017-03-10 05:00:00	SPY	ETF	237.73	237.73	237.73	237.73	100.0
2017-03-10 05:05:00	SPY	ETF	237.68	237.71	237.68	237.71	1815.0
2017-03-10 05:10:00	SPY	ETF	237.68	237.68	237.67	237.67	1100.0
2017-03-10 05:15:00	SPY	ETF	237.72	237.72	237.72	237.72	300.0
2017-03-10 05:20:00	SPY	ETF	237.72	237.75	237.71	237.75	1450.0
2017-03-10 05:25:00	SPY	ETF	237.86	237.86	237.77	237.77	2000.0
2017-03-10 05:30:00	SPY	ETF	237.77	237.81	237.77	237.81	7000.0
2017-03-10 05:40:00	SPY	ETF	237.71	237.73	237.71	237.73	3800.0
2017-03-10 05:45:00	SPY	ETF	237.73	237.73	237.71	237.71	1125.0
2017-03-10 05:50:00	SPY	ETF	237.68	237.71	237.67	237.67	26500.0
2017-03-10 05:55:00	SPY	ETF	237.7	237.7	237.7	237.7	200.0
2017-03-10 06:00:00	SPY	ETF	237.76	237.76	237.73	237.73	400.0
2017-03-10 06:05:00	SPY	ETF	237.8	237.8	237.8	237.8	885.0
2017-03-10 06:10:00	SPY	ETF	237.83	237.86	237.83	237.86	1310.0
2017-03-10 06:15:00	SPY	ETF	237.87	237.94	237.87	237.89	41310.0
2017-03-10 06:20:00	SPY	ETF	237.93	237.93	237.9	237.9	9451.0
2017-03-10 06:25:00	SPY	ETF	237.89	237.92	237.89	237.92	4200.0
2017-03-10 06:30:00	SPY	ETF	237.92	237.92	237.91	237.92	3215.0
2017-03-10 06:35:00	SPY	ETF	237.87	237.88	237.85	237.88	9015.0
2017-03-10 06:40:00	SPY	ETF	237.85	237.9	237.85	237.85	146850.0
2017-03-10 06:45:00	SPY	ETF	237.84	237.87	237.81	237.82	65850.0
2017-03-10 06:50:00	SPY	ETF	237.82	237.86	237.8	237.83	17050.0
2017-03-10 06:55:00	SPY	ETF	237.84	237.84	237.83	237.84	1570.0
2017-03-10 07:00:00	SPY	ETF	237.82	237.82	237.73	237.74	14750.0
2017-03-10 07:05:00	SPY	ETF	237.74	237.76	237.73	237.76	26010.0
2017-03-10 07:10:00	SPY	ETF	237.76	237.78	237.73	237.73	34210.0
2017-03-10 07:15:00	SPY	ETF	237.74	237.74	237.7	237.73	56826.0
2017-03-10 07:20:00	SPY	ETF	237.72	237.75	237.69	237.75	37100.0
2017-03-10 07:25:00	SPY	ETF	237.75	237.75	237.72	237.75	26600.0
2017-03-10 07:30:00	SPY	ETF	237.76	237.77	237.74	237.76	4400.0
2017-03-10 07:35:00	SPY	ETF	237.77	237.77	237.72	237.72	6520.0
2017-03-10 07:40:00	SPY	ETF	237.72	237.72	237.7	237.7	26273.0
2017-03-10 07:45:00	SPY	ETF	237.7	237.76	237.7	237.73	12523.0
2017-03-10 07:50:00	SPY	ETF	237.71	237.73	237.67	237.69	79502.0
2017-03-10 07:55:00	SPY	ETF	237.69	237.71	237.66	237.68	11350.0
2017-03-10 08:00:00	SPY	ETF	237.69	237.82	236.97	237.66	81619.0
2017-03-10 08:05:00	SPY	ETF	237.68	237.68	237.64	237.68	42174.0
2017-03-10 08:10:00	SPY	ETF	237.68	237.76	237.68	237.75	69806.0
2017-03-10 08:15:00	SPY	ETF	237.75	237.82	237.75	237.82	65730.0
2017-03-10 08:20:00	SPY	ETF	237.79	237.82	237.73	237.75	65115.0

> showing 50 of 54,743 rows — these rows as CSV

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