PREVIEW / etf_5min / 2009-11-06

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-11-06.parquet
  size:    691 KB
  rows:    29,657

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-11-06 04:15:00	SPY	ETF	106.98	106.98	106.97	106.98	1900.0
2009-11-06 04:35:00	SPY	ETF	106.87	106.87	106.87	106.87	1100.0
2009-11-06 05:15:00	SPY	ETF	106.72	106.72	106.72	106.72	100.0
2009-11-06 05:20:00	SPY	ETF	106.68	106.68	106.68	106.68	200.0
2009-11-06 05:55:00	SPY	ETF	106.84	106.84	106.84	106.84	1000.0
2009-11-06 06:00:00	SPY	ETF	107.0	107.0	107.0	107.0	2000.0
2009-11-06 06:05:00	SPY	ETF	106.98	106.98	106.93	106.93	4200.0
2009-11-06 06:10:00	SPY	ETF	106.84	106.84	106.84	106.84	100.0
2009-11-06 06:15:00	SPY	ETF	106.84	106.84	106.84	106.84	100.0
2009-11-06 06:35:00	SPY	ETF	106.94	106.94	106.94	106.94	3000.0
2009-11-06 06:45:00	SPY	ETF	106.88	106.88	106.88	106.88	1000.0
2009-11-06 06:50:00	SPY	ETF	106.88	106.9	106.88	106.88	1700.0
2009-11-06 06:55:00	SPY	ETF	106.9	106.9	106.9	106.9	600.0
2009-11-06 07:00:00	SPY	ETF	106.87	106.89	106.84	106.89	23100.0
2009-11-06 07:05:00	SPY	ETF	106.9	106.97	106.89	106.95	2060.0
2009-11-06 07:10:00	SPY	ETF	106.96	106.98	106.93	106.93	3460.0
2009-11-06 07:15:00	SPY	ETF	106.96	106.96	106.93	106.95	6642.0
2009-11-06 07:20:00	SPY	ETF	106.96	106.96	106.95	106.95	3731.0
2009-11-06 07:25:00	SPY	ETF	106.92	106.92	106.85	106.86	102746.0
2009-11-06 07:30:00	SPY	ETF	106.91	106.91	106.85	106.85	3807.0
2009-11-06 07:35:00	SPY	ETF	106.85	106.91	106.85	106.91	31202.0
2009-11-06 07:40:00	SPY	ETF	106.9	107.03	106.9	106.99	135559.0
2009-11-06 07:45:00	SPY	ETF	106.98	106.98	106.95	106.98	27500.0
2009-11-06 07:50:00	SPY	ETF	106.95	106.98	106.93	106.94	14536.0
2009-11-06 07:55:00	SPY	ETF	106.98	107.0	106.95	106.97	19500.0
2009-11-06 08:00:00	SPY	ETF	107.0	107.02	106.815	107.02	133860.0
2009-11-06 08:05:00	SPY	ETF	106.99	107.1	106.99	107.07	236595.0
2009-11-06 08:10:00	SPY	ETF	107.07	107.08	107.02	107.03	99190.0
2009-11-06 08:15:00	SPY	ETF	107.04	107.08	107.02	107.08	228976.0
2009-11-06 08:20:00	SPY	ETF	107.07	107.08	107.02	107.03	219516.0
2009-11-06 08:25:00	SPY	ETF	107.03	107.4	107.0	107.14	580307.0
2009-11-06 08:30:00	SPY	ETF	107.14	107.33	106.11	106.22	4903188.0
2009-11-06 08:35:00	SPY	ETF	106.21	106.86	106.1	106.33	2066283.0
2009-11-06 08:40:00	SPY	ETF	106.32	106.38	106.13	106.26	2050216.0
2009-11-06 08:45:00	SPY	ETF	106.26	106.3	105.93	105.93	1066394.0
2009-11-06 08:50:00	SPY	ETF	105.93	106.02	105.85	105.97	710687.0
2009-11-06 08:55:00	SPY	ETF	105.98	106.18	105.92	106.08	1047060.0
2009-11-06 09:00:00	SPY	ETF	106.09	106.15	105.97	106.06	489826.0
2009-11-06 09:05:00	SPY	ETF	106.06	106.1	106.0	106.1	384409.0
2009-11-06 09:10:00	SPY	ETF	106.1	106.32	106.05	106.27	562755.0
2009-11-06 09:15:00	SPY	ETF	106.27	106.27	106.16	106.25	403238.0
2009-11-06 09:20:00	SPY	ETF	106.26	106.33	106.2	106.2	606392.0
2009-11-06 09:25:00	SPY	ETF	106.22	106.29	106.2	106.26	1027560.0
2009-11-06 09:30:00	SPY	ETF	106.26	106.32	106.05	106.16	6177795.0
2009-11-06 09:35:00	SPY	ETF	106.16	106.55	106.14	106.49	4667062.0
2009-11-06 09:40:00	SPY	ETF	106.5	107.01	106.49	106.9	7086590.0
2009-11-06 09:45:00	SPY	ETF	106.9099	107.2	106.9001	107.02	6897506.0
2009-11-06 09:50:00	SPY	ETF	107.02	107.15	106.93	107.0595	3745891.0
2009-11-06 09:55:00	SPY	ETF	107.06	107.33	107.03	107.17	5094770.0
2009-11-06 10:00:00	SPY	ETF	107.17	107.4	107.11	107.14	3555793.0

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

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