PREVIEW / etf_5min / 2007-05-24

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-05-24.parquet
  size:    367 KB
  rows:    17,271

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
2007-05-24 04:15:00	SPY	ETF	152.15	152.15	152.15	152.15	100.0
2007-05-24 06:05:00	SPY	ETF	152.27	152.27	152.27	152.27	5000.0
2007-05-24 07:00:00	SPY	ETF	152.27	152.29	152.26	152.29	10100.0
2007-05-24 07:05:00	SPY	ETF	152.33	152.33	152.3	152.33	109700.0
2007-05-24 07:10:00	SPY	ETF	152.33	152.36	152.33	152.35	18200.0
2007-05-24 07:15:00	SPY	ETF	152.36	152.37	152.32	152.34	19500.0
2007-05-24 07:20:00	SPY	ETF	152.37	152.39	152.36	152.37	116000.0
2007-05-24 07:25:00	SPY	ETF	152.41	152.41	152.37	152.37	1500.0
2007-05-24 07:30:00	SPY	ETF	152.37	152.37	152.37	152.37	100.0
2007-05-24 07:35:00	SPY	ETF	152.34	152.35	152.32	152.35	8100.0
2007-05-24 07:40:00	SPY	ETF	152.33	152.33	152.29	152.29	9900.0
2007-05-24 07:45:00	SPY	ETF	152.29	152.31	152.29	152.29	9000.0
2007-05-24 07:50:00	SPY	ETF	152.29	152.35	152.29	152.35	11600.0
2007-05-24 07:55:00	SPY	ETF	152.35	152.35	152.31	152.32	37100.0
2007-05-24 08:00:00	SPY	ETF	152.24	152.35	152.24	152.28	236800.0
2007-05-24 08:05:00	SPY	ETF	152.28	152.33	152.26	152.28	5600.0
2007-05-24 08:10:00	SPY	ETF	152.28	152.3	152.28	152.3	8400.0
2007-05-24 08:15:00	SPY	ETF	152.32	152.34	152.32	152.32	2900.0
2007-05-24 08:20:00	SPY	ETF	152.34	152.41	152.34	152.34	84700.0
2007-05-24 08:25:00	SPY	ETF	152.35	152.42	152.34	152.42	54100.0
2007-05-24 08:30:00	SPY	ETF	152.39	152.55	152.27	152.46	1099000.0
2007-05-24 08:35:00	SPY	ETF	152.47	152.48	152.37	152.47	681700.0
2007-05-24 08:40:00	SPY	ETF	152.47	152.47	152.42	152.44	57600.0
2007-05-24 08:45:00	SPY	ETF	152.45	152.59	152.45	152.58	657900.0
2007-05-24 08:50:00	SPY	ETF	152.56	152.64	152.55	152.63	351100.0
2007-05-24 08:55:00	SPY	ETF	152.63	152.63	152.54	152.54	186400.0
2007-05-24 09:00:00	SPY	ETF	152.54	152.6	152.54	152.6	180400.0
2007-05-24 09:05:00	SPY	ETF	152.6	152.6	152.54	152.55	137800.0
2007-05-24 09:10:00	SPY	ETF	152.56	152.57	152.5	152.53	370400.0
2007-05-24 09:15:00	SPY	ETF	152.52	152.52	152.5	152.5	132400.0
2007-05-24 09:20:00	SPY	ETF	152.51	152.54	152.51	152.54	35900.0
2007-05-24 09:25:00	SPY	ETF	152.53	152.55	152.49	152.55	166407.0
2007-05-24 09:30:00	SPY	ETF	152.53	152.56	152.44	152.49	1573399.0
2007-05-24 09:35:00	SPY	ETF	152.5	152.56	152.28	152.33	3564887.0
2007-05-24 09:40:00	SPY	ETF	152.33	152.44	152.29	152.43	1693000.0
2007-05-24 09:45:00	SPY	ETF	152.44	152.55	152.38	152.52	1709300.0
2007-05-24 09:50:00	SPY	ETF	152.52	152.73	152.51	152.7	3848450.0
2007-05-24 09:55:00	SPY	ETF	152.7	152.78	152.58	152.65	1985599.0
2007-05-24 10:00:00	SPY	ETF	152.65	153.2	152.54	153.04	9103801.0
2007-05-24 10:05:00	SPY	ETF	153.05	153.21	152.97	153.05	2823483.0
2007-05-24 10:10:00	SPY	ETF	153.05	153.1	152.91	152.94	1889228.0
2007-05-24 10:15:00	SPY	ETF	152.94	152.99	152.89	152.91	2430780.0
2007-05-24 10:20:00	SPY	ETF	152.91	152.945	152.79	152.88	1095608.0
2007-05-24 10:25:00	SPY	ETF	152.87	152.93	152.78	152.87	934000.0
2007-05-24 10:30:00	SPY	ETF	152.88	152.93	152.72	152.77	1549850.0
2007-05-24 10:35:00	SPY	ETF	152.77	152.81	152.52	152.53	2041200.0
2007-05-24 10:40:00	SPY	ETF	152.53	152.61	152.35	152.35	2329500.0
2007-05-24 10:45:00	SPY	ETF	152.35	152.42	152.23	152.38	4590892.0
2007-05-24 10:50:00	SPY	ETF	152.38	152.39	152.23	152.27	1448299.0
2007-05-24 10:55:00	SPY	ETF	152.27	152.275	151.9	152.04	6654800.0

> showing 50 of 17,271 rows — these rows as CSV

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