PREVIEW / etf_5min / 2009-03-17

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-17.parquet
  size:    666 KB
  rows:    28,488

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-03-17 04:15:00	SPY	ETF	76.13	76.2	76.13	76.18	600.0
2009-03-17 04:55:00	SPY	ETF	76.33	76.45	76.33	76.45	500.0
2009-03-17 05:00:00	SPY	ETF	76.4	76.4	76.4	76.4	100.0
2009-03-17 05:10:00	SPY	ETF	76.28	76.28	76.28	76.28	100.0
2009-03-17 05:55:00	SPY	ETF	76.45	76.48	76.4	76.45	10000.0
2009-03-17 06:00:00	SPY	ETF	76.38	76.59	76.38	76.59	5600.0
2009-03-17 06:05:00	SPY	ETF	76.51	76.51	76.51	76.51	1000.0
2009-03-17 06:10:00	SPY	ETF	76.53	76.53	76.53	76.53	200.0
2009-03-17 06:15:00	SPY	ETF	76.46	76.46	76.46	76.46	40000.0
2009-03-17 06:20:00	SPY	ETF	76.53	76.66	76.53	76.66	2300.0
2009-03-17 06:25:00	SPY	ETF	76.55	76.56	76.53	76.56	3600.0
2009-03-17 06:30:00	SPY	ETF	76.56	76.56	76.56	76.56	100.0
2009-03-17 06:35:00	SPY	ETF	76.71	76.71	76.71	76.71	1500.0
2009-03-17 06:40:00	SPY	ETF	76.71	76.71	76.71	76.71	2500.0
2009-03-17 06:45:00	SPY	ETF	76.64	76.64	76.55	76.58	2800.0
2009-03-17 06:50:00	SPY	ETF	76.54	76.56	76.48	76.51	17400.0
2009-03-17 06:55:00	SPY	ETF	76.55	76.56	76.4	76.42	10900.0
2009-03-17 07:00:00	SPY	ETF	76.45	76.45	76.16	76.18	62344.0
2009-03-17 07:05:00	SPY	ETF	76.17	76.28	76.17	76.28	27600.0
2009-03-17 07:10:00	SPY	ETF	76.26	76.3	76.26	76.3	31300.0
2009-03-17 07:15:00	SPY	ETF	76.3	76.32	76.26	76.26	17000.0
2009-03-17 07:20:00	SPY	ETF	76.26	76.33	76.26	76.3	37800.0
2009-03-17 07:25:00	SPY	ETF	76.24	76.28	76.22	76.25	3500.0
2009-03-17 07:30:00	SPY	ETF	76.23	76.33	76.23	76.33	4381.0
2009-03-17 07:35:00	SPY	ETF	76.3	76.33	76.27	76.3	42749.0
2009-03-17 07:40:00	SPY	ETF	76.3	76.31	76.27	76.3	58200.0
2009-03-17 07:45:00	SPY	ETF	76.29	76.32	76.2	76.26	70500.0
2009-03-17 07:50:00	SPY	ETF	76.25	76.25	76.07	76.15	146921.0
2009-03-17 07:55:00	SPY	ETF	76.15	76.19	76.1	76.12	198111.0
2009-03-17 08:00:00	SPY	ETF	76.12	76.81	76.02	76.06	1590286.0
2009-03-17 08:05:00	SPY	ETF	76.08	76.08	75.92	75.94	228381.0
2009-03-17 08:10:00	SPY	ETF	75.94	75.95	75.8	75.91	290371.0
2009-03-17 08:15:00	SPY	ETF	75.9	75.9	75.81	75.87	155457.0
2009-03-17 08:20:00	SPY	ETF	75.86	76.11	75.86	76.07	533879.0
2009-03-17 08:25:00	SPY	ETF	76.06	76.07	75.94	75.97	157194.0
2009-03-17 08:30:00	SPY	ETF	75.97	76.32	75.97	76.22	776796.0
2009-03-17 08:35:00	SPY	ETF	76.22	76.49	76.11	76.49	453994.0
2009-03-17 08:40:00	SPY	ETF	76.47	76.51	76.32	76.32	306236.0
2009-03-17 08:45:00	SPY	ETF	76.32	76.39	76.24	76.31	329976.0
2009-03-17 08:50:00	SPY	ETF	76.31	76.33	76.24	76.33	163093.0
2009-03-17 08:55:00	SPY	ETF	76.33	76.36	76.27	76.34	392648.0
2009-03-17 09:00:00	SPY	ETF	76.34	76.36	76.18	76.23	709432.0
2009-03-17 09:05:00	SPY	ETF	76.23	76.25	76.14	76.16	95395.0
2009-03-17 09:10:00	SPY	ETF	76.15	76.21	76.01	76.07	236578.0
2009-03-17 09:15:00	SPY	ETF	76.07	76.11	76.01	76.04	337138.0
2009-03-17 09:20:00	SPY	ETF	76.03	76.06	75.92	76.0	120081.0
2009-03-17 09:25:00	SPY	ETF	75.98	76.06	75.9	76.05	517988.0
2009-03-17 09:30:00	SPY	ETF	76.07	76.24	75.94	76.13	5019052.0
2009-03-17 09:35:00	SPY	ETF	76.13	76.18	75.8	75.81	5135059.0
2009-03-17 09:40:00	SPY	ETF	75.8	75.8	75.54	75.5701	4733352.0

> showing 50 of 28,488 rows — these rows as CSV

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