PREVIEW / etf_5min / 2009-09-18

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-18.parquet
  size:    682 KB
  rows:    29,694

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-18 04:15:00	SPY	ETF	106.36	106.37	106.26	106.26	4500.0
2009-09-18 04:20:00	SPY	ETF	106.26	106.29	106.26	106.29	800.0
2009-09-18 04:25:00	SPY	ETF	106.4	106.4	106.31	106.38	600.0
2009-09-18 05:05:00	SPY	ETF	106.53	106.53	106.53	106.53	300.0
2009-09-18 05:10:00	SPY	ETF	106.43	106.43	106.39	106.39	400.0
2009-09-18 05:40:00	SPY	ETF	106.72	106.72	106.72	106.72	400.0
2009-09-18 05:50:00	SPY	ETF	106.78	106.78	106.78	106.78	100.0
2009-09-18 05:55:00	SPY	ETF	106.69	106.73	106.69	106.72	9700.0
2009-09-18 06:00:00	SPY	ETF	106.76	106.77	106.72	106.74	10300.0
2009-09-18 06:05:00	SPY	ETF	106.7	106.71	106.68	106.68	10000.0
2009-09-18 06:10:00	SPY	ETF	106.83	106.83	106.83	106.83	100.0
2009-09-18 06:15:00	SPY	ETF	106.77	106.77	106.77	106.77	100.0
2009-09-18 06:25:00	SPY	ETF	106.77	106.77	106.77	106.77	200.0
2009-09-18 06:40:00	SPY	ETF	106.76	106.76	106.76	106.76	100.0
2009-09-18 06:45:00	SPY	ETF	106.76	106.77	106.76	106.77	7500.0
2009-09-18 06:50:00	SPY	ETF	106.85	106.85	106.85	106.85	100.0
2009-09-18 06:55:00	SPY	ETF	106.86	106.86	106.86	106.86	2500.0
2009-09-18 07:00:00	SPY	ETF	106.92	106.92	106.84	106.86	14499.0
2009-09-18 07:05:00	SPY	ETF	106.87	106.87	106.84	106.87	2700.0
2009-09-18 07:10:00	SPY	ETF	106.87	106.88	106.84	106.85	28860.0
2009-09-18 07:15:00	SPY	ETF	106.85	106.86	106.83	106.86	39700.0
2009-09-18 07:20:00	SPY	ETF	106.86	106.86	106.83	106.84	37848.0
2009-09-18 07:25:00	SPY	ETF	106.85	106.86	106.83	106.86	24010.0
2009-09-18 07:30:00	SPY	ETF	106.86	106.86	106.81	106.85	21300.0
2009-09-18 07:35:00	SPY	ETF	106.86	106.88	106.83	106.87	12810.0
2009-09-18 07:40:00	SPY	ETF	106.85	106.87	106.8	106.82	19703.0
2009-09-18 07:45:00	SPY	ETF	106.85	106.85	106.85	106.85	200.0
2009-09-18 07:50:00	SPY	ETF	106.83	106.83	106.82	106.83	2200.0
2009-09-18 07:55:00	SPY	ETF	106.83	106.83	106.8	106.83	9868.0
2009-09-18 08:00:00	SPY	ETF	106.83	106.87	106.8	106.82	372239.0
2009-09-18 08:05:00	SPY	ETF	106.83	106.85	106.82	106.83	38555.0
2009-09-18 08:10:00	SPY	ETF	106.81	106.85	106.81	106.85	18701.0
2009-09-18 08:15:00	SPY	ETF	106.84	106.85	106.77	106.77	34583.0
2009-09-18 08:20:00	SPY	ETF	106.77	106.83	106.73	106.83	57729.0
2009-09-18 08:25:00	SPY	ETF	106.82	106.95	106.81	106.93	169349.0
2009-09-18 08:30:00	SPY	ETF	106.95	106.98	106.9	106.95	292938.0
2009-09-18 08:35:00	SPY	ETF	106.94	107.02	106.93	106.97	214075.0
2009-09-18 08:40:00	SPY	ETF	106.96	107.01	106.96	106.99	149213.0
2009-09-18 08:45:00	SPY	ETF	107.0	107.0	106.95	106.98	59161.0
2009-09-18 08:50:00	SPY	ETF	106.99	107.02	106.92	106.93	90098.0
2009-09-18 08:55:00	SPY	ETF	106.96	107.04	106.92	107.04	173101.0
2009-09-18 09:00:00	SPY	ETF	107.04	107.09	107.03	107.06	193473.0
2009-09-18 09:05:00	SPY	ETF	107.06	107.16	107.02	107.02	160679.0
2009-09-18 09:10:00	SPY	ETF	107.03	107.11	107.03	107.1	113702.0
2009-09-18 09:15:00	SPY	ETF	107.1	107.17	107.09	107.13	347256.0
2009-09-18 09:20:00	SPY	ETF	107.13	107.14	107.07	107.08	592513.0
2009-09-18 09:25:00	SPY	ETF	107.08	107.19	107.05	107.15	289249.0
2009-09-18 09:30:00	SPY	ETF	107.15	107.16	106.96	107.065	5413297.0
2009-09-18 09:35:00	SPY	ETF	107.065	107.14	106.91	106.92	4817255.0
2009-09-18 09:40:00	SPY	ETF	106.91	107.0	106.76	107.0	3960990.0

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

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