PREVIEW / etf_5min / 2007-08-16

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-08-16.parquet
  size:    485 KB
  rows:    22,861

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
2007-08-16 04:05:00	SPY	ETF	140.31	140.31	140.31	140.31	1000.0
2007-08-16 04:35:00	SPY	ETF	140.28	140.28	140.09	140.09	1400.0
2007-08-16 05:20:00	SPY	ETF	139.99	139.99	139.99	139.99	200.0
2007-08-16 05:25:00	SPY	ETF	139.9	139.9	139.67	139.67	500.0
2007-08-16 05:30:00	SPY	ETF	139.51	139.51	139.51	139.51	200.0
2007-08-16 05:50:00	SPY	ETF	139.47	139.54	139.47	139.54	1000.0
2007-08-16 05:55:00	SPY	ETF	139.76	139.76	139.76	139.76	3000.0
2007-08-16 06:00:00	SPY	ETF	139.74	139.74	139.74	139.74	1000.0
2007-08-16 06:05:00	SPY	ETF	139.74	139.74	139.74	139.74	1000.0
2007-08-16 06:10:00	SPY	ETF	139.81	139.81	139.69	139.69	6000.0
2007-08-16 06:15:00	SPY	ETF	139.74	139.75	139.74	139.75	4000.0
2007-08-16 06:20:00	SPY	ETF	139.94	139.95	139.84	139.84	31000.0
2007-08-16 06:25:00	SPY	ETF	139.96	139.98	139.81	139.81	3800.0
2007-08-16 06:30:00	SPY	ETF	139.76	139.76	139.74	139.75	8500.0
2007-08-16 06:35:00	SPY	ETF	139.7	139.7	139.17	139.17	47300.0
2007-08-16 06:40:00	SPY	ETF	139.18	139.52	139.15	139.42	73500.0
2007-08-16 06:45:00	SPY	ETF	139.4	139.5	139.4	139.41	5400.0
2007-08-16 06:50:00	SPY	ETF	139.49	139.6	139.47	139.47	26500.0
2007-08-16 06:55:00	SPY	ETF	139.47	139.51	139.36	139.39	143200.0
2007-08-16 07:00:00	SPY	ETF	139.39	139.42	139.25	139.37	167000.0
2007-08-16 07:05:00	SPY	ETF	139.37	139.38	139.28	139.34	292200.0
2007-08-16 07:10:00	SPY	ETF	139.34	139.55	139.25	139.35	305800.0
2007-08-16 07:15:00	SPY	ETF	139.35	139.41	139.25	139.3	119500.0
2007-08-16 07:20:00	SPY	ETF	139.25	139.26	139.12	139.15	669700.0
2007-08-16 07:25:00	SPY	ETF	139.16	139.3	139.12	139.28	77500.0
2007-08-16 07:30:00	SPY	ETF	139.25	139.53	139.2	139.44	413400.0
2007-08-16 07:35:00	SPY	ETF	139.4	139.6	139.25	139.56	201200.0
2007-08-16 07:40:00	SPY	ETF	139.6	139.6	139.49	139.5	178400.0
2007-08-16 07:45:00	SPY	ETF	139.52	139.52	139.05	139.1	231200.0
2007-08-16 07:50:00	SPY	ETF	139.1	139.19	139.05	139.14	277400.0
2007-08-16 07:55:00	SPY	ETF	139.12	139.36	139.05	139.35	172400.0
2007-08-16 08:00:00	SPY	ETF	139.4	139.95	139.15	139.24	739200.0
2007-08-16 08:05:00	SPY	ETF	139.25	139.47	139.19	139.45	320200.0
2007-08-16 08:10:00	SPY	ETF	139.42	139.56	139.29	139.4	534300.0
2007-08-16 08:15:00	SPY	ETF	139.45	139.68	139.44	139.68	662100.0
2007-08-16 08:20:00	SPY	ETF	139.69	139.7	139.53	139.54	556400.0
2007-08-16 08:25:00	SPY	ETF	139.54	139.7	139.54	139.66	170000.0
2007-08-16 08:30:00	SPY	ETF	139.66	139.73	139.4	139.7	540300.0
2007-08-16 08:35:00	SPY	ETF	139.7	139.91	139.54	139.82	617900.0
2007-08-16 08:40:00	SPY	ETF	139.82	139.91	139.6	139.65	784600.0
2007-08-16 08:45:00	SPY	ETF	139.65	140.05	139.64	139.9	1076700.0
2007-08-16 08:50:00	SPY	ETF	139.93	140.24	139.93	140.21	1285700.0
2007-08-16 08:55:00	SPY	ETF	140.24	140.3	140.05	140.06	3088400.0
2007-08-16 09:00:00	SPY	ETF	140.06	140.25	139.93	140.05	553800.0
2007-08-16 09:05:00	SPY	ETF	140.02	140.03	139.65	139.75	1661300.0
2007-08-16 09:10:00	SPY	ETF	139.79	139.98	139.78	139.96	338600.0
2007-08-16 09:15:00	SPY	ETF	139.97	140.0	139.8	139.87	535600.0
2007-08-16 09:20:00	SPY	ETF	139.86	139.95	139.8	139.93	433800.0
2007-08-16 09:25:00	SPY	ETF	139.93	140.0	139.76	139.79	1533619.0
2007-08-16 09:30:00	SPY	ETF	139.79	139.9	139.5	139.87	6870979.0

> showing 50 of 22,861 rows — these rows as CSV

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