PREVIEW / etf_5min / 2009-09-04

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-04.parquet
  size:    678 KB
  rows:    28,677

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-04 04:15:00	SPY	ETF	100.94	100.94	100.94	100.94	1400.0
2009-09-04 04:25:00	SPY	ETF	101.01	101.01	100.98	100.98	300.0
2009-09-04 04:30:00	SPY	ETF	100.98	100.98	100.98	100.98	300.0
2009-09-04 04:40:00	SPY	ETF	101.03	101.03	101.03	101.03	300.0
2009-09-04 04:50:00	SPY	ETF	101.08	101.08	101.08	101.08	100.0
2009-09-04 05:00:00	SPY	ETF	101.1	101.16	101.1	101.16	1090.0
2009-09-04 05:25:00	SPY	ETF	101.06	101.06	101.06	101.06	100.0
2009-09-04 05:45:00	SPY	ETF	101.03	101.03	101.0	101.0	1200.0
2009-09-04 06:00:00	SPY	ETF	100.9	100.9	100.9	100.9	400.0
2009-09-04 06:40:00	SPY	ETF	100.91	100.91	100.91	100.91	10000.0
2009-09-04 06:45:00	SPY	ETF	100.91	100.91	100.91	100.91	550.0
2009-09-04 06:50:00	SPY	ETF	100.91	100.91	100.91	100.91	100.0
2009-09-04 07:00:00	SPY	ETF	100.93	101.08	100.93	101.04	14520.0
2009-09-04 07:05:00	SPY	ETF	101.05	101.08	101.04	101.04	63134.0
2009-09-04 07:10:00	SPY	ETF	101.04	101.05	101.04	101.04	27234.0
2009-09-04 07:15:00	SPY	ETF	101.1	101.12	101.06	101.1	27179.0
2009-09-04 07:20:00	SPY	ETF	101.08	101.08	101.04	101.08	31500.0
2009-09-04 07:25:00	SPY	ETF	101.06	101.08	101.01	101.01	5484.0
2009-09-04 07:30:00	SPY	ETF	100.98	101.0	100.97	100.97	26000.0
2009-09-04 07:35:00	SPY	ETF	100.98	101.02	100.97	101.01	76737.0
2009-09-04 07:40:00	SPY	ETF	101.02	101.05	100.99	101.0	25203.0
2009-09-04 07:45:00	SPY	ETF	100.97	101.0	100.97	101.0	7200.0
2009-09-04 07:50:00	SPY	ETF	101.0	101.02	101.0	101.0	74889.0
2009-09-04 07:55:00	SPY	ETF	100.99	101.06	100.99	101.06	26269.0
2009-09-04 08:00:00	SPY	ETF	100.41	101.16	100.41	101.12	132804.0
2009-09-04 08:05:00	SPY	ETF	101.12	101.15	101.07	101.09	531200.0
2009-09-04 08:10:00	SPY	ETF	101.09	101.1	101.05	101.07	683109.0
2009-09-04 08:15:00	SPY	ETF	101.08	101.14	101.07	101.09	82487.0
2009-09-04 08:20:00	SPY	ETF	101.09	101.09	101.04	101.06	104443.0
2009-09-04 08:25:00	SPY	ETF	101.07	101.13	100.93	100.95	733780.0
2009-09-04 08:30:00	SPY	ETF	100.92	101.21	100.51	101.12	4756832.0
2009-09-04 08:35:00	SPY	ETF	101.12	101.43	101.1	101.33	2172202.0
2009-09-04 08:40:00	SPY	ETF	101.33	101.38	100.65	101.01	1837855.0
2009-09-04 08:45:00	SPY	ETF	101.01	101.02	100.85	100.95	1190601.0
2009-09-04 08:50:00	SPY	ETF	100.96	100.97	100.65	100.84	617649.0
2009-09-04 08:55:00	SPY	ETF	100.84	100.92	100.8	100.85	350449.0
2009-09-04 09:00:00	SPY	ETF	100.83	100.9	100.63	100.71	884934.0
2009-09-04 09:05:00	SPY	ETF	100.72	100.73	100.59	100.63	829545.0
2009-09-04 09:10:00	SPY	ETF	100.64	100.8	100.6	100.76	490944.0
2009-09-04 09:15:00	SPY	ETF	100.76	100.94	100.72	100.86	405239.0
2009-09-04 09:20:00	SPY	ETF	100.86	100.94	100.86	100.91	218378.0
2009-09-04 09:25:00	SPY	ETF	100.91	100.92	100.81	100.86	169405.0
2009-09-04 09:30:00	SPY	ETF	100.85	100.97	100.62	100.96	5564557.0
2009-09-04 09:35:00	SPY	ETF	100.96	101.14	100.87	100.999	4664347.0
2009-09-04 09:40:00	SPY	ETF	100.99	101.13	100.92	101.01	2493785.0
2009-09-04 09:45:00	SPY	ETF	101.0	101.06	100.71	100.77	2767624.0
2009-09-04 09:50:00	SPY	ETF	100.77	100.78	100.55	100.75	2510828.0
2009-09-04 09:55:00	SPY	ETF	100.75	100.85	100.65	100.66	1886194.0
2009-09-04 10:00:00	SPY	ETF	100.67	100.94	100.65	100.8399	2067698.0
2009-09-04 10:05:00	SPY	ETF	100.83	100.94	100.81	100.88	740358.0

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

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