PREVIEW / etf_5min / 2019-12-23

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-23.parquet
  size:    1.5 MB
  rows:    65,547

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-12-23 04:00:00	SPY	ETF	321.34	321.35	321.34	321.35	300.0
2019-12-23 04:05:00	SPY	ETF	321.35	321.35	321.35	321.35	1000.0
2019-12-23 04:10:00	SPY	ETF	321.33	321.36	321.33	321.36	510.0
2019-12-23 04:15:00	SPY	ETF	321.35	321.44	321.35	321.44	650.0
2019-12-23 04:20:00	SPY	ETF	321.46	321.46	321.46	321.46	100.0
2019-12-23 04:30:00	SPY	ETF	321.42	321.44	321.42	321.44	288.0
2019-12-23 04:35:00	SPY	ETF	321.44	321.44	321.44	321.44	1100.0
2019-12-23 04:40:00	SPY	ETF	321.44	321.44	321.44	321.44	1500.0
2019-12-23 04:45:00	SPY	ETF	321.42	321.42	321.4	321.4	1133.0
2019-12-23 04:55:00	SPY	ETF	321.4	321.4	321.4	321.4	660.0
2019-12-23 05:00:00	SPY	ETF	321.37	321.37	321.37	321.37	600.0
2019-12-23 05:05:00	SPY	ETF	321.42	321.42	321.42	321.42	400.0
2019-12-23 05:10:00	SPY	ETF	321.43	321.43	321.43	321.43	200.0
2019-12-23 05:20:00	SPY	ETF	321.47	321.47	321.47	321.47	158.0
2019-12-23 05:30:00	SPY	ETF	321.48	321.5	321.48	321.5	1850.0
2019-12-23 05:35:00	SPY	ETF	321.49	321.49	321.44	321.44	4200.0
2019-12-23 05:45:00	SPY	ETF	321.43	321.44	321.43	321.44	750.0
2019-12-23 05:50:00	SPY	ETF	321.43	321.47	321.43	321.47	649.0
2019-12-23 05:55:00	SPY	ETF	321.42	321.42	321.41	321.41	3000.0
2019-12-23 06:05:00	SPY	ETF	321.47	321.47	321.47	321.47	450.0
2019-12-23 06:10:00	SPY	ETF	321.61	321.61	321.61	321.61	500.0
2019-12-23 06:15:00	SPY	ETF	321.62	321.62	321.61	321.61	5205.0
2019-12-23 06:20:00	SPY	ETF	321.61	321.61	321.61	321.61	400.0
2019-12-23 06:25:00	SPY	ETF	321.63	321.66	321.61	321.66	6100.0
2019-12-23 06:35:00	SPY	ETF	321.58	321.61	321.54	321.61	10231.0
2019-12-23 06:40:00	SPY	ETF	321.62	321.62	321.62	321.62	1050.0
2019-12-23 06:50:00	SPY	ETF	321.58	321.59	321.58	321.59	208.0
2019-12-23 06:55:00	SPY	ETF	321.56	321.56	321.56	321.56	350.0
2019-12-23 07:00:00	SPY	ETF	321.62	321.66	321.58	321.64	12908.0
2019-12-23 07:05:00	SPY	ETF	321.65	321.98	321.65	321.89	17736.0
2019-12-23 07:10:00	SPY	ETF	321.89	321.89	321.81	321.81	1880.0
2019-12-23 07:15:00	SPY	ETF	321.8	321.83	321.78	321.8	1824.0
2019-12-23 07:20:00	SPY	ETF	321.8	321.8	321.74	321.78	9036.0
2019-12-23 07:25:00	SPY	ETF	321.75	321.83	321.75	321.83	1428.0
2019-12-23 07:30:00	SPY	ETF	321.81	321.84	321.79	321.79	2800.0
2019-12-23 07:35:00	SPY	ETF	321.79	321.83	321.79	321.83	396.0
2019-12-23 07:40:00	SPY	ETF	321.81	321.81	321.77	321.77	3800.0
2019-12-23 07:45:00	SPY	ETF	321.78	321.8	321.77	321.79	19531.0
2019-12-23 07:50:00	SPY	ETF	321.8	321.81	321.8	321.81	1104.0
2019-12-23 07:55:00	SPY	ETF	321.81	321.84	321.8	321.8	19280.0
2019-12-23 08:00:00	SPY	ETF	321.65	321.8801	321.22	321.75	14581.0
2019-12-23 08:05:00	SPY	ETF	321.75	321.77	321.72	321.72	9062.0
2019-12-23 08:10:00	SPY	ETF	321.72	321.77	321.72	321.77	6036.0
2019-12-23 08:15:00	SPY	ETF	321.79	321.79	321.75	321.75	9185.0
2019-12-23 08:20:00	SPY	ETF	321.75	321.8	321.74	321.7902	8811.0
2019-12-23 08:25:00	SPY	ETF	321.77	321.82	321.77	321.8	42408.0
2019-12-23 08:30:00	SPY	ETF	321.8	321.82	321.78	321.8	16146.0
2019-12-23 08:35:00	SPY	ETF	321.82	321.86	321.82	321.86	14394.0
2019-12-23 08:40:00	SPY	ETF	321.84	321.92	321.84	321.8999	17565.0
2019-12-23 08:45:00	SPY	ETF	321.9	321.9	321.8	321.83	14735.0

> showing 50 of 65,547 rows — these rows as CSV

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