PREVIEW / etf_5min / 2009-12-02

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-12-02.parquet
  size:    710 KB
  rows:    31,212

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-12-02 04:20:00	SPY	ETF	111.22	111.22	111.22	111.22	100.0
2009-12-02 04:25:00	SPY	ETF	111.18	111.18	111.18	111.18	139.0
2009-12-02 04:55:00	SPY	ETF	111.34	111.34	111.34	111.34	100.0
2009-12-02 05:10:00	SPY	ETF	111.38	111.38	111.38	111.38	100.0
2009-12-02 05:15:00	SPY	ETF	111.42	111.42	111.42	111.42	100.0
2009-12-02 05:45:00	SPY	ETF	111.23	111.23	111.23	111.23	2000.0
2009-12-02 05:55:00	SPY	ETF	111.35	111.35	111.35	111.35	500.0
2009-12-02 06:10:00	SPY	ETF	111.23	111.23	111.22	111.22	600.0
2009-12-02 06:20:00	SPY	ETF	111.11	111.11	111.08	111.08	300.0
2009-12-02 06:55:00	SPY	ETF	111.21	111.21	111.21	111.21	500.0
2009-12-02 07:00:00	SPY	ETF	111.2	111.24	111.16	111.16	11200.0
2009-12-02 07:05:00	SPY	ETF	111.15	111.19	111.15	111.18	64084.0
2009-12-02 07:10:00	SPY	ETF	111.18	111.18	111.18	111.18	8506.0
2009-12-02 07:15:00	SPY	ETF	111.2	111.34	111.2	111.34	90801.0
2009-12-02 07:20:00	SPY	ETF	111.34	111.37	111.33	111.34	76002.0
2009-12-02 07:25:00	SPY	ETF	111.39	111.4	111.26	111.26	334200.0
2009-12-02 07:30:00	SPY	ETF	111.24	111.27	111.21	111.24	113700.0
2009-12-02 07:35:00	SPY	ETF	111.28	111.4	111.28	111.39	84800.0
2009-12-02 07:40:00	SPY	ETF	111.38	111.38	111.32	111.32	440491.0
2009-12-02 07:45:00	SPY	ETF	111.31	111.33	111.25	111.26	153927.0
2009-12-02 07:50:00	SPY	ETF	111.26	111.34	111.24	111.33	169342.0
2009-12-02 07:55:00	SPY	ETF	111.33	111.38	111.33	111.38	87301.0
2009-12-02 08:00:00	SPY	ETF	111.35	111.49	111.2	111.45	1548148.0
2009-12-02 08:05:00	SPY	ETF	111.45	111.54	111.45	111.52	658975.0
2009-12-02 08:10:00	SPY	ETF	111.52	111.57	111.5	111.54	79568.0
2009-12-02 08:15:00	SPY	ETF	111.51	111.54	111.29	111.3	735246.0
2009-12-02 08:20:00	SPY	ETF	111.3	111.32	111.16	111.32	188042.0
2009-12-02 08:25:00	SPY	ETF	111.32	111.35	111.28	111.29	47697.0
2009-12-02 08:30:00	SPY	ETF	111.29	111.39	111.23	111.37	758617.0
2009-12-02 08:35:00	SPY	ETF	111.36	111.36	111.28	111.31	34865.0
2009-12-02 08:40:00	SPY	ETF	111.29	111.32	111.27	111.31	58890.0
2009-12-02 08:45:00	SPY	ETF	111.32	111.32	111.25	111.26	88109.0
2009-12-02 08:50:00	SPY	ETF	111.26	111.26	111.23	111.24	34715.0
2009-12-02 08:55:00	SPY	ETF	111.24	111.24	111.18	111.21	71440.0
2009-12-02 09:00:00	SPY	ETF	111.22	111.27	111.22	111.25	187018.0
2009-12-02 09:05:00	SPY	ETF	111.25	111.25	111.22	111.25	27605.0
2009-12-02 09:10:00	SPY	ETF	111.25	111.27	111.16	111.18	140388.0
2009-12-02 09:15:00	SPY	ETF	111.19	111.27	111.18	111.23	51004.0
2009-12-02 09:20:00	SPY	ETF	111.22	111.23	111.22	111.23	55894.0
2009-12-02 09:25:00	SPY	ETF	111.21	111.28	111.21	111.28	88435.0
2009-12-02 09:30:00	SPY	ETF	111.28	111.52	111.21	111.4901	2914202.0
2009-12-02 09:35:00	SPY	ETF	111.49	111.57	111.41	111.48	3655044.0
2009-12-02 09:40:00	SPY	ETF	111.48	111.58	111.25	111.25	3029750.0
2009-12-02 09:45:00	SPY	ETF	111.26	111.4	111.21	111.38	2107390.0
2009-12-02 09:50:00	SPY	ETF	111.38	111.54	111.35	111.45	1997706.0
2009-12-02 09:55:00	SPY	ETF	111.46	111.51	111.32	111.43	2115042.0
2009-12-02 10:00:00	SPY	ETF	111.42	111.605	111.42	111.56	2051604.0
2009-12-02 10:05:00	SPY	ETF	111.56	111.65	111.55	111.62	1796207.0
2009-12-02 10:10:00	SPY	ETF	111.62	112.01	111.62	111.95	6266672.0
2009-12-02 10:15:00	SPY	ETF	111.95	112.01	111.86	111.92	2025224.0

> showing 50 of 31,212 rows — these rows as CSV

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