PREVIEW / etf_5min / 2019-08-06

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-06.parquet
  size:    1.6 MB
  rows:    68,062

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-08-06 04:00:00	SPY	ETF	283.68	283.83	283.17	283.27	31945.0
2019-08-06 04:05:00	SPY	ETF	283.28	283.63	283.27	283.58	18811.0
2019-08-06 04:10:00	SPY	ETF	283.51	283.7	283.5	283.52	7824.0
2019-08-06 04:15:00	SPY	ETF	283.65	284.1	283.57	284.04	17165.0
2019-08-06 04:20:00	SPY	ETF	284.07	284.43	284.07	284.42	4854.0
2019-08-06 04:25:00	SPY	ETF	284.3	285.15	284.3	285.02	13553.0
2019-08-06 04:30:00	SPY	ETF	285.02	285.02	284.8	284.8	6422.0
2019-08-06 04:35:00	SPY	ETF	284.82	285.12	284.82	285.08	7839.0
2019-08-06 04:40:00	SPY	ETF	285.13	285.13	284.93	285.03	2207.0
2019-08-06 04:45:00	SPY	ETF	285.13	285.18	285.03	285.14	9731.0
2019-08-06 04:50:00	SPY	ETF	285.15	285.19	285.03	285.07	7581.0
2019-08-06 04:55:00	SPY	ETF	285.06	285.12	284.9	285.07	4075.0
2019-08-06 05:00:00	SPY	ETF	284.94	285.02	284.94	285.02	9570.0
2019-08-06 05:05:00	SPY	ETF	284.95	285.14	284.94	285.14	3505.0
2019-08-06 05:10:00	SPY	ETF	285.12	285.27	285.11	285.11	3285.0
2019-08-06 05:15:00	SPY	ETF	285.14	285.37	285.14	285.32	4106.0
2019-08-06 05:20:00	SPY	ETF	285.37	285.62	285.37	285.49	10236.0
2019-08-06 05:25:00	SPY	ETF	285.42	285.49	285.36	285.49	1161.0
2019-08-06 05:30:00	SPY	ETF	285.36	285.36	285.3	285.32	4658.0
2019-08-06 05:35:00	SPY	ETF	285.32	285.51	285.24	285.49	4764.0
2019-08-06 05:40:00	SPY	ETF	285.33	285.78	285.31	285.66	12446.0
2019-08-06 05:45:00	SPY	ETF	285.69	285.69	285.53	285.56	23344.0
2019-08-06 05:50:00	SPY	ETF	285.58	285.61	285.41	285.41	6480.0
2019-08-06 05:55:00	SPY	ETF	285.49	285.51	285.3	285.4	61504.0
2019-08-06 06:00:00	SPY	ETF	285.24	285.24	285.11	285.13	5760.0
2019-08-06 06:05:00	SPY	ETF	285.13	285.17	285.0	285.03	78217.0
2019-08-06 06:10:00	SPY	ETF	285.01	285.13	284.93	284.93	27111.0
2019-08-06 06:15:00	SPY	ETF	284.92	285.05	284.92	285.05	10470.0
2019-08-06 06:20:00	SPY	ETF	285.05	285.11	284.9	285.11	20214.0
2019-08-06 06:25:00	SPY	ETF	285.07	285.13	284.99	285.07	22302.0
2019-08-06 06:30:00	SPY	ETF	285.05	285.41	285.04	285.4	15564.0
2019-08-06 06:35:00	SPY	ETF	285.35	285.38	285.3	285.33	5410.0
2019-08-06 06:40:00	SPY	ETF	285.33	285.33	285.2	285.22	7700.0
2019-08-06 06:45:00	SPY	ETF	285.23	285.42	285.13	285.16	27335.0
2019-08-06 06:50:00	SPY	ETF	285.11	285.21	285.11	285.15	41225.0
2019-08-06 06:55:00	SPY	ETF	285.14	285.14	284.92	285.09	26208.0
2019-08-06 07:00:00	SPY	ETF	285.11	285.25	284.91	284.92	74549.0
2019-08-06 07:05:00	SPY	ETF	284.92	285.23	284.87	285.15	107673.0
2019-08-06 07:10:00	SPY	ETF	285.16	285.31	284.9	285.06	102486.0
2019-08-06 07:15:00	SPY	ETF	285.09	285.27	285.09	285.25	92546.0
2019-08-06 07:20:00	SPY	ETF	285.23	285.48	285.22	285.37	66516.0
2019-08-06 07:25:00	SPY	ETF	285.39	285.5	285.3	285.5	31148.0
2019-08-06 07:30:00	SPY	ETF	285.46	285.52	285.32	285.35	36656.0
2019-08-06 07:35:00	SPY	ETF	285.35	286.0	285.35	285.82	88335.0
2019-08-06 07:40:00	SPY	ETF	285.82	286.15	285.7	286.15	54308.0
2019-08-06 07:45:00	SPY	ETF	286.14	286.14	285.4	285.47	52479.0
2019-08-06 07:50:00	SPY	ETF	285.47	285.57	285.31	285.43	34394.0
2019-08-06 07:55:00	SPY	ETF	285.38	285.54	285.34	285.43	38427.0
2019-08-06 08:00:00	SPY	ETF	281.09	286.06	279.3075	285.41	876816.0
2019-08-06 08:05:00	SPY	ETF	285.44	285.75	285.39	285.4	58758.0

> showing 50 of 68,062 rows — these rows as CSV

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