PREVIEW / etf_5min / 2009-09-17

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-17.parquet
  size:    755 KB
  rows:    31,569

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-09-17 04:05:00	SPY	ETF	107.56	107.56	107.56	107.56	300.0
2009-09-17 04:15:00	SPY	ETF	107.43	107.43	107.38	107.38	1300.0
2009-09-17 04:25:00	SPY	ETF	107.33	107.33	107.33	107.33	100.0
2009-09-17 04:45:00	SPY	ETF	107.38	107.38	107.38	107.38	1680.0
2009-09-17 04:50:00	SPY	ETF	107.26	107.26	107.23	107.23	350.0
2009-09-17 04:55:00	SPY	ETF	107.21	107.21	107.21	107.21	100.0
2009-09-17 05:00:00	SPY	ETF	107.23	107.23	107.23	107.23	300.0
2009-09-17 05:10:00	SPY	ETF	107.41	107.41	107.4	107.41	5500.0
2009-09-17 05:25:00	SPY	ETF	107.43	107.43	107.43	107.43	2500.0
2009-09-17 05:30:00	SPY	ETF	107.43	107.45	107.43	107.45	2500.0
2009-09-17 05:35:00	SPY	ETF	107.46	107.46	107.46	107.46	100.0
2009-09-17 05:40:00	SPY	ETF	107.47	107.47	107.47	107.47	190.0
2009-09-17 05:50:00	SPY	ETF	107.49	107.5	107.49	107.5	300.0
2009-09-17 06:05:00	SPY	ETF	107.5	107.5	107.5	107.5	2000.0
2009-09-17 06:25:00	SPY	ETF	107.45	107.45	107.45	107.45	200.0
2009-09-17 06:30:00	SPY	ETF	107.51	107.51	107.51	107.51	2500.0
2009-09-17 06:35:00	SPY	ETF	107.5	107.5	107.49	107.49	350.0
2009-09-17 06:40:00	SPY	ETF	107.51	107.51	107.51	107.51	500.0
2009-09-17 06:45:00	SPY	ETF	107.51	107.51	107.51	107.51	1000.0
2009-09-17 06:50:00	SPY	ETF	107.51	107.54	107.51	107.52	4550.0
2009-09-17 06:55:00	SPY	ETF	107.5	107.52	107.5	107.52	10050.0
2009-09-17 07:00:00	SPY	ETF	107.54	107.54	107.5	107.5	600.0
2009-09-17 07:05:00	SPY	ETF	107.47	107.47	107.42	107.42	3250.0
2009-09-17 07:10:00	SPY	ETF	107.43	107.45	107.43	107.45	900.0
2009-09-17 07:15:00	SPY	ETF	107.41	107.41	107.36	107.38	15950.0
2009-09-17 07:20:00	SPY	ETF	107.38	107.4	107.37	107.4	11016.0
2009-09-17 07:25:00	SPY	ETF	107.43	107.43	107.36	107.38	5806.0
2009-09-17 07:30:00	SPY	ETF	107.41	107.42	107.36	107.42	17503.0
2009-09-17 07:35:00	SPY	ETF	107.43	107.44	107.37	107.37	42900.0
2009-09-17 07:40:00	SPY	ETF	107.38	107.41	107.33	107.36	72379.0
2009-09-17 07:45:00	SPY	ETF	107.36	107.36	107.25	107.26	34500.0
2009-09-17 07:50:00	SPY	ETF	107.27	107.29	107.26	107.26	21407.0
2009-09-17 07:55:00	SPY	ETF	107.25	107.25	107.18	107.2	38700.0
2009-09-17 08:00:00	SPY	ETF	107.24	107.27	107.21	107.24	82983.0
2009-09-17 08:05:00	SPY	ETF	107.23	107.29	107.23	107.28	26350.0
2009-09-17 08:10:00	SPY	ETF	107.28	107.34	107.27	107.31	93682.0
2009-09-17 08:15:00	SPY	ETF	107.31	107.42	107.3	107.4	123753.0
2009-09-17 08:20:00	SPY	ETF	107.4	107.4	107.33	107.34	432298.0
2009-09-17 08:25:00	SPY	ETF	107.33	107.33	107.25	107.27	210798.0
2009-09-17 08:30:00	SPY	ETF	107.29	107.43	107.13	107.22	843295.0
2009-09-17 08:35:00	SPY	ETF	107.22	107.23	107.12	107.22	437456.0
2009-09-17 08:40:00	SPY	ETF	107.21	107.23	107.17	107.2	138511.0
2009-09-17 08:45:00	SPY	ETF	107.2	107.29	107.2	107.22	212740.0
2009-09-17 08:50:00	SPY	ETF	107.22	107.22	107.08	107.08	553324.0
2009-09-17 08:55:00	SPY	ETF	107.09	107.12	107.04	107.06	276972.0
2009-09-17 09:00:00	SPY	ETF	107.06	108.81	107.06	107.09	87486.0
2009-09-17 09:05:00	SPY	ETF	107.09	107.17	107.02	107.03	326053.0
2009-09-17 09:10:00	SPY	ETF	107.02	107.04	106.97	107.01	188373.0
2009-09-17 09:15:00	SPY	ETF	107.0	107.07	106.98	107.03	91220.0
2009-09-17 09:20:00	SPY	ETF	107.03	107.13	107.03	107.13	203044.0

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

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