PREVIEW / etf_5min / 2009-07-24

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-24.parquet
  size:    721 KB
  rows:    29,896

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
2009-07-24 04:10:00	SPY	ETF	97.5	97.5	97.5	97.5	200.0
2009-07-24 04:15:00	SPY	ETF	97.63	97.81	97.63	97.81	20474.0
2009-07-24 04:25:00	SPY	ETF	97.72	97.72	97.72	97.72	4000.0
2009-07-24 04:30:00	SPY	ETF	97.7	97.7	97.7	97.7	200.0
2009-07-24 04:35:00	SPY	ETF	97.62	97.66	97.62	97.65	20150.0
2009-07-24 04:45:00	SPY	ETF	97.59	97.59	97.59	97.59	5000.0
2009-07-24 04:55:00	SPY	ETF	97.53	97.53	97.53	97.53	1000.0
2009-07-24 05:20:00	SPY	ETF	97.48	97.53	97.48	97.53	1000.0
2009-07-24 05:35:00	SPY	ETF	97.48	97.48	97.48	97.48	200.0
2009-07-24 05:50:00	SPY	ETF	97.61	97.61	97.61	97.61	6500.0
2009-07-24 05:55:00	SPY	ETF	97.62	97.64	97.62	97.64	13600.0
2009-07-24 06:00:00	SPY	ETF	97.61	97.64	97.61	97.64	300.0
2009-07-24 06:05:00	SPY	ETF	97.62	97.62	97.62	97.62	10198.0
2009-07-24 06:10:00	SPY	ETF	97.63	97.65	97.62	97.65	7000.0
2009-07-24 06:15:00	SPY	ETF	97.65	97.65	97.6	97.6	600.0
2009-07-24 06:25:00	SPY	ETF	97.53	97.53	97.53	97.53	250.0
2009-07-24 06:30:00	SPY	ETF	97.48	97.55	97.47	97.55	15500.0
2009-07-24 06:35:00	SPY	ETF	97.53	97.55	97.53	97.55	10120.0
2009-07-24 06:40:00	SPY	ETF	97.55	97.57	97.48	97.52	147995.0
2009-07-24 06:45:00	SPY	ETF	97.55	97.55	97.55	97.55	1360.0
2009-07-24 06:50:00	SPY	ETF	97.54	97.55	97.53	97.55	22640.0
2009-07-24 06:55:00	SPY	ETF	97.6	97.6	97.6	97.6	4952.0
2009-07-24 07:00:00	SPY	ETF	97.56	97.64	97.56	97.6	137200.0
2009-07-24 07:05:00	SPY	ETF	97.58	97.59	97.55	97.59	29755.0
2009-07-24 07:10:00	SPY	ETF	97.57	97.64	97.57	97.57	31960.0
2009-07-24 07:15:00	SPY	ETF	97.55	97.6	97.52	97.52	74391.0
2009-07-24 07:20:00	SPY	ETF	97.52	97.53	97.49	97.52	13900.0
2009-07-24 07:25:00	SPY	ETF	97.52	97.58	97.52	97.53	24500.0
2009-07-24 07:30:00	SPY	ETF	97.58	97.58	97.52	97.57	55800.0
2009-07-24 07:35:00	SPY	ETF	97.58	97.58	97.52	97.54	37647.0
2009-07-24 07:40:00	SPY	ETF	97.55	97.55	97.47	97.47	109609.0
2009-07-24 07:45:00	SPY	ETF	97.49	97.54	97.47	97.5	79457.0
2009-07-24 07:50:00	SPY	ETF	97.51	97.54	97.5	97.5	289678.0
2009-07-24 07:55:00	SPY	ETF	97.55	97.57	97.51	97.57	145634.0
2009-07-24 08:00:00	SPY	ETF	97.56	97.63	97.49	97.5	167380.0
2009-07-24 08:05:00	SPY	ETF	97.5	97.52	97.47	97.49	56719.0
2009-07-24 08:10:00	SPY	ETF	97.49	97.5	97.42	97.42	252055.0
2009-07-24 08:15:00	SPY	ETF	97.43	97.43	97.35	97.36	123938.0
2009-07-24 08:20:00	SPY	ETF	97.35	97.36	97.26	97.27	350384.0
2009-07-24 08:25:00	SPY	ETF	97.29	97.32	97.27	97.3	329195.0
2009-07-24 08:30:00	SPY	ETF	97.3	97.37	97.25	97.37	147414.0
2009-07-24 08:35:00	SPY	ETF	97.37	97.42	97.35	97.39	196790.0
2009-07-24 08:40:00	SPY	ETF	97.39	97.4	97.29	97.3	639414.0
2009-07-24 08:45:00	SPY	ETF	97.3	97.31	97.2	97.2	113105.0
2009-07-24 08:50:00	SPY	ETF	97.19	97.21	97.15	97.16	222707.0
2009-07-24 08:55:00	SPY	ETF	97.17	97.21	97.15	97.18	82091.0
2009-07-24 09:00:00	SPY	ETF	97.18	97.2	97.15	97.15	106769.0
2009-07-24 09:05:00	SPY	ETF	97.17	97.22	97.15	97.22	461386.0
2009-07-24 09:10:00	SPY	ETF	97.21	97.24	97.2	97.23	124479.0
2009-07-24 09:15:00	SPY	ETF	97.23	97.24	97.19	97.2	77132.0

> showing 50 of 29,896 rows — these rows as CSV

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