PREVIEW / etf_5min / 2018-01-12

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-01-12.parquet
  size:    1.5 MB
  rows:    63,464

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-01-12 04:00:00	SPY	ETF	276.76	276.86	276.45	276.86	2290.0
2018-01-12 04:05:00	SPY	ETF	276.86	276.88	276.82	276.82	3005.0
2018-01-12 04:10:00	SPY	ETF	276.82	276.88	276.82	276.87	1000.0
2018-01-12 04:15:00	SPY	ETF	276.88	276.92	276.88	276.92	2620.0
2018-01-12 04:20:00	SPY	ETF	276.92	276.92	276.92	276.92	709.0
2018-01-12 04:25:00	SPY	ETF	276.87	276.87	276.87	276.87	400.0
2018-01-12 04:30:00	SPY	ETF	276.84	276.84	276.84	276.84	1900.0
2018-01-12 04:35:00	SPY	ETF	276.79	276.85	276.79	276.85	1700.0
2018-01-12 04:40:00	SPY	ETF	276.88	276.88	276.88	276.88	500.0
2018-01-12 04:45:00	SPY	ETF	276.82	276.85	276.82	276.85	1100.0
2018-01-12 05:00:00	SPY	ETF	276.75	276.75	276.71	276.71	1000.0
2018-01-12 05:10:00	SPY	ETF	276.8	276.8	276.8	276.8	400.0
2018-01-12 05:15:00	SPY	ETF	276.8	276.8	276.8	276.8	5000.0
2018-01-12 05:20:00	SPY	ETF	276.77	276.77	276.77	276.77	200.0
2018-01-12 05:25:00	SPY	ETF	276.74	276.74	276.74	276.74	100.0
2018-01-12 05:30:00	SPY	ETF	276.84	276.84	276.84	276.84	300.0
2018-01-12 05:45:00	SPY	ETF	276.83	276.83	276.81	276.81	1400.0
2018-01-12 05:55:00	SPY	ETF	276.88	276.88	276.83	276.83	400.0
2018-01-12 06:00:00	SPY	ETF	276.85	276.85	276.85	276.85	3462.0
2018-01-12 06:05:00	SPY	ETF	276.88	276.88	276.88	276.88	400.0
2018-01-12 06:10:00	SPY	ETF	276.86	276.86	276.86	276.86	1500.0
2018-01-12 06:15:00	SPY	ETF	276.9	276.9	276.9	276.9	410.0
2018-01-12 06:20:00	SPY	ETF	276.85	276.85	276.85	276.85	300.0
2018-01-12 06:25:00	SPY	ETF	276.82	276.82	276.82	276.82	10000.0
2018-01-12 06:30:00	SPY	ETF	276.84	276.85	276.83	276.85	20100.0
2018-01-12 06:35:00	SPY	ETF	276.85	276.88	276.83	276.83	6800.0
2018-01-12 06:40:00	SPY	ETF	276.87	276.87	276.83	276.83	3200.0
2018-01-12 06:45:00	SPY	ETF	276.83	276.83	276.81	276.81	3400.0
2018-01-12 06:50:00	SPY	ETF	276.86	276.87	276.84	276.87	17100.0
2018-01-12 06:55:00	SPY	ETF	276.8	276.8	276.78	276.8	700.0
2018-01-12 07:00:00	SPY	ETF	276.84	276.85	276.81	276.85	14836.0
2018-01-12 07:05:00	SPY	ETF	276.86	276.91	276.8	276.9	167998.0
2018-01-12 07:10:00	SPY	ETF	276.9	276.91	276.9	276.9	10760.0
2018-01-12 07:20:00	SPY	ETF	276.85	276.85	276.72	276.75	13400.0
2018-01-12 07:25:00	SPY	ETF	276.74	276.77	276.74	276.77	5488.0
2018-01-12 07:30:00	SPY	ETF	276.74	276.75	276.73	276.73	19380.0
2018-01-12 07:35:00	SPY	ETF	276.74	276.8	276.74	276.79	13365.0
2018-01-12 07:40:00	SPY	ETF	276.74	276.76	276.71	276.71	12514.0
2018-01-12 07:45:00	SPY	ETF	276.69	276.69	276.69	276.69	3171.0
2018-01-12 07:50:00	SPY	ETF	276.69	276.72	276.69	276.71	3600.0
2018-01-12 07:55:00	SPY	ETF	276.75	276.75	276.68	276.68	11437.0
2018-01-12 08:00:00	SPY	ETF	276.68	276.9	276.66	276.68	38982.0
2018-01-12 08:05:00	SPY	ETF	276.7	276.72	276.67	276.67	32258.0
2018-01-12 08:10:00	SPY	ETF	276.65	276.66	276.6	276.64	16956.0
2018-01-12 08:15:00	SPY	ETF	276.64	276.65	276.6	276.6	26179.0
2018-01-12 08:20:00	SPY	ETF	276.58	276.66	276.58	276.66	24021.0
2018-01-12 08:25:00	SPY	ETF	276.66	276.79	276.66	276.78	61343.0
2018-01-12 08:30:00	SPY	ETF	276.79	276.79	276.41	276.41	206954.0
2018-01-12 08:35:00	SPY	ETF	276.4	276.41	275.96	276.1	214865.0
2018-01-12 08:40:00	SPY	ETF	276.13	276.2	276.05	276.08	233120.0

> showing 50 of 63,464 rows — these rows as CSV

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