PREVIEW / etf_5min / 2019-03-19

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-03-19.parquet
  size:    1.4 MB
  rows:    63,869

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-03-19 04:00:00	SPY	ETF	282.76	282.94	282.76	282.94	900.0
2019-03-19 04:20:00	SPY	ETF	282.84	282.84	282.84	282.84	400.0
2019-03-19 04:30:00	SPY	ETF	282.94	283.11	282.94	283.11	1116.0
2019-03-19 04:35:00	SPY	ETF	283.13	283.22	283.13	283.15	820.0
2019-03-19 04:40:00	SPY	ETF	283.15	283.2	283.15	283.2	400.0
2019-03-19 04:50:00	SPY	ETF	283.27	283.27	283.27	283.27	700.0
2019-03-19 05:00:00	SPY	ETF	283.27	283.27	283.22	283.22	1200.0
2019-03-19 05:05:00	SPY	ETF	283.23	283.3	283.23	283.28	6575.0
2019-03-19 05:10:00	SPY	ETF	283.24	283.28	283.23	283.28	400.0
2019-03-19 05:20:00	SPY	ETF	283.28	283.31	283.28	283.31	1600.0
2019-03-19 05:25:00	SPY	ETF	283.34	283.44	283.34	283.44	6135.0
2019-03-19 05:35:00	SPY	ETF	283.42	283.44	283.39	283.39	8250.0
2019-03-19 05:40:00	SPY	ETF	283.41	283.45	283.39	283.39	1527.0
2019-03-19 05:45:00	SPY	ETF	283.39	283.43	283.38	283.38	1950.0
2019-03-19 05:50:00	SPY	ETF	283.36	283.36	283.36	283.36	719.0
2019-03-19 05:55:00	SPY	ETF	283.37	283.38	283.36	283.36	2149.0
2019-03-19 06:00:00	SPY	ETF	283.33	283.34	283.33	283.34	269.0
2019-03-19 06:05:00	SPY	ETF	283.41	283.41	283.41	283.41	100.0
2019-03-19 06:10:00	SPY	ETF	283.39	283.39	283.33	283.36	491.0
2019-03-19 06:15:00	SPY	ETF	283.33	283.36	283.33	283.36	700.0
2019-03-19 06:20:00	SPY	ETF	283.35	283.39	283.35	283.39	200.0
2019-03-19 06:25:00	SPY	ETF	283.38	283.4	283.38	283.39	1240.0
2019-03-19 06:30:00	SPY	ETF	283.35	283.42	283.35	283.42	2400.0
2019-03-19 06:35:00	SPY	ETF	283.43	283.43	283.37	283.4	1460.0
2019-03-19 06:40:00	SPY	ETF	283.44	283.44	283.44	283.44	200.0
2019-03-19 06:45:00	SPY	ETF	283.47	283.57	283.47	283.57	903.0
2019-03-19 06:50:00	SPY	ETF	283.47	283.58	283.47	283.57	1115.0
2019-03-19 06:55:00	SPY	ETF	283.58	283.79	283.58	283.79	5157.0
2019-03-19 07:00:00	SPY	ETF	283.72	283.75	283.66	283.67	23610.0
2019-03-19 07:05:00	SPY	ETF	283.68	283.68	283.62	283.67	20380.0
2019-03-19 07:10:00	SPY	ETF	283.67	283.68	283.67	283.68	1350.0
2019-03-19 07:15:00	SPY	ETF	283.67	283.7	283.65	283.69	2800.0
2019-03-19 07:20:00	SPY	ETF	283.67	283.67	283.6	283.64	1525.0
2019-03-19 07:25:00	SPY	ETF	283.63	283.65	283.62	283.65	3995.0
2019-03-19 07:30:00	SPY	ETF	283.61	283.61	283.56	283.56	7215.0
2019-03-19 07:35:00	SPY	ETF	283.57	283.57	283.52	283.55	11012.0
2019-03-19 07:40:00	SPY	ETF	283.54	283.55	283.52	283.55	1345.0
2019-03-19 07:45:00	SPY	ETF	283.54	283.59	283.52	283.55	6722.0
2019-03-19 07:50:00	SPY	ETF	283.53	283.53	283.47	283.47	3267.0
2019-03-19 07:55:00	SPY	ETF	283.5	283.5	283.46	283.5	5501.0
2019-03-19 08:00:00	SPY	ETF	283.648	283.705	282.83	283.58	41673.0
2019-03-19 08:05:00	SPY	ETF	283.58	283.62	283.55	283.57	37121.0
2019-03-19 08:10:00	SPY	ETF	283.55	283.65	283.55	283.6	4185.0
2019-03-19 08:15:00	SPY	ETF	283.59	283.65	283.59	283.65	4595.0
2019-03-19 08:20:00	SPY	ETF	283.66	283.71	283.65	283.71	19366.0
2019-03-19 08:25:00	SPY	ETF	283.71	283.71	283.48	283.48	17123.0
2019-03-19 08:30:00	SPY	ETF	283.51	283.59	283.48	283.57	15097.0
2019-03-19 08:35:00	SPY	ETF	283.57	283.64	283.42	283.43	22822.0
2019-03-19 08:40:00	SPY	ETF	283.43	283.5	283.42	283.5	23310.0
2019-03-19 08:45:00	SPY	ETF	283.47	283.51	283.46	283.5	73808.0

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

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