PREVIEW / etf_5min / 2019-01-15

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-01-15.parquet
  size:    1.4 MB
  rows:    63,447

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
2019-01-15 04:00:00	SPY	ETF	258.42	258.42	258.3	258.3	1016.0
2019-01-15 04:05:00	SPY	ETF	258.15	258.15	258.13	258.13	446.0
2019-01-15 04:10:00	SPY	ETF	258.2	258.2	258.05	258.11	1014.0
2019-01-15 04:15:00	SPY	ETF	258.22	258.25	258.22	258.22	1250.0
2019-01-15 04:20:00	SPY	ETF	258.11	258.26	258.11	258.23	456.0
2019-01-15 04:25:00	SPY	ETF	258.33	258.33	258.26	258.26	230.0
2019-01-15 04:30:00	SPY	ETF	258.26	258.33	258.23	258.25	5769.0
2019-01-15 04:35:00	SPY	ETF	258.25	258.25	258.05	258.12	5572.0
2019-01-15 04:40:00	SPY	ETF	258.05	258.05	258.05	258.05	300.0
2019-01-15 04:45:00	SPY	ETF	258.15	258.15	258.15	258.15	300.0
2019-01-15 04:50:00	SPY	ETF	258.0	258.0	257.89	257.95	2219.0
2019-01-15 04:55:00	SPY	ETF	257.96	257.96	257.9	257.9	516.0
2019-01-15 05:00:00	SPY	ETF	258.04	258.04	258.04	258.04	200.0
2019-01-15 05:05:00	SPY	ETF	258.14	258.14	258.08	258.09	490.0
2019-01-15 05:10:00	SPY	ETF	258.19	258.19	258.19	258.19	100.0
2019-01-15 05:15:00	SPY	ETF	258.08	258.13	258.08	258.13	200.0
2019-01-15 05:20:00	SPY	ETF	258.02	258.02	258.0	258.0	205.0
2019-01-15 05:25:00	SPY	ETF	258.03	258.1	258.03	258.08	4400.0
2019-01-15 05:30:00	SPY	ETF	258.01	258.01	257.9	257.94	1081.0
2019-01-15 05:35:00	SPY	ETF	257.98	258.08	257.98	258.08	820.0
2019-01-15 05:40:00	SPY	ETF	258.16	258.16	258.16	258.16	125.0
2019-01-15 05:45:00	SPY	ETF	258.19	258.2	258.19	258.2	669.0
2019-01-15 05:50:00	SPY	ETF	258.05	258.05	258.05	258.05	100.0
2019-01-15 05:55:00	SPY	ETF	258.2	258.34	258.2	258.3	3199.0
2019-01-15 06:00:00	SPY	ETF	258.21	258.3	258.2	258.3	3843.0
2019-01-15 06:05:00	SPY	ETF	258.39	258.4	258.39	258.4	901.0
2019-01-15 06:10:00	SPY	ETF	258.35	258.36	258.2	258.28	6965.0
2019-01-15 06:15:00	SPY	ETF	258.24	258.24	258.24	258.24	1300.0
2019-01-15 06:20:00	SPY	ETF	258.25	258.3	258.21	258.21	601.0
2019-01-15 06:25:00	SPY	ETF	258.27	258.27	258.27	258.27	100.0
2019-01-15 06:30:00	SPY	ETF	258.21	258.28	258.21	258.27	600.0
2019-01-15 06:35:00	SPY	ETF	258.45	258.45	258.35	258.35	900.0
2019-01-15 06:40:00	SPY	ETF	258.48	258.54	258.45	258.5	5010.0
2019-01-15 06:45:00	SPY	ETF	258.43	258.43	258.28	258.28	16430.0
2019-01-15 06:50:00	SPY	ETF	258.22	258.22	257.8	257.84	30692.0
2019-01-15 06:55:00	SPY	ETF	257.82	257.82	257.49	257.65	25900.0
2019-01-15 07:00:00	SPY	ETF	257.66	257.78	257.58	257.68	29189.0
2019-01-15 07:05:00	SPY	ETF	257.7	257.74	257.64	257.68	28765.0
2019-01-15 07:10:00	SPY	ETF	257.61	257.61	257.5	257.54	11892.0
2019-01-15 07:15:00	SPY	ETF	257.54	257.73	257.54	257.72	14865.0
2019-01-15 07:20:00	SPY	ETF	257.72	257.73	257.66	257.72	24210.0
2019-01-15 07:25:00	SPY	ETF	257.73	257.82	257.7	257.78	49866.0
2019-01-15 07:30:00	SPY	ETF	257.72	257.73	257.63	257.66	16654.0
2019-01-15 07:35:00	SPY	ETF	257.66	257.73	257.6	257.72	13273.0
2019-01-15 07:40:00	SPY	ETF	257.72	257.72	257.54	257.58	15533.0
2019-01-15 07:45:00	SPY	ETF	257.6	257.69	257.6	257.65	10401.0
2019-01-15 07:50:00	SPY	ETF	257.64	257.66	257.54	257.66	30358.0
2019-01-15 07:55:00	SPY	ETF	257.66	257.72	257.66	257.72	4295.0
2019-01-15 08:00:00	SPY	ETF	257.68	259.22	257.5201	257.73	46965.0
2019-01-15 08:05:00	SPY	ETF	257.73	257.95	257.73	257.74	41828.0

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

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