PREVIEW / etf_5min / 2007-08-20

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-08-20.parquet
  size:    379 KB
  rows:    18,061

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-20 05:55:00	SPY	ETF	145.0	145.0	144.88	144.88	1000.0
2007-08-20 06:00:00	SPY	ETF	144.9	144.93	144.9	144.93	800.0
2007-08-20 06:05:00	SPY	ETF	144.8	144.8	144.8	144.8	4900.0
2007-08-20 06:10:00	SPY	ETF	144.8	144.8	144.8	144.8	100.0
2007-08-20 06:20:00	SPY	ETF	144.92	144.95	144.92	144.95	8000.0
2007-08-20 06:25:00	SPY	ETF	144.95	144.95	144.95	144.95	2500.0
2007-08-20 06:30:00	SPY	ETF	145.13	145.2	145.13	145.2	8500.0
2007-08-20 06:45:00	SPY	ETF	145.27	145.27	145.27	145.27	20000.0
2007-08-20 06:50:00	SPY	ETF	145.32	145.32	145.32	145.32	1500.0
2007-08-20 06:55:00	SPY	ETF	145.37	145.37	145.37	145.37	3000.0
2007-08-20 07:00:00	SPY	ETF	145.27	145.33	145.22	145.33	13400.0
2007-08-20 07:05:00	SPY	ETF	145.25	145.25	145.07	145.07	7700.0
2007-08-20 07:10:00	SPY	ETF	145.1	145.15	144.92	144.97	35700.0
2007-08-20 07:15:00	SPY	ETF	144.93	145.0	144.9	144.99	40700.0
2007-08-20 07:20:00	SPY	ETF	144.97	144.97	144.9	144.96	19400.0
2007-08-20 07:25:00	SPY	ETF	144.97	145.12	144.97	145.1	67700.0
2007-08-20 07:30:00	SPY	ETF	145.14	145.18	145.0	145.0	70600.0
2007-08-20 07:35:00	SPY	ETF	145.05	145.12	145.05	145.12	38200.0
2007-08-20 07:40:00	SPY	ETF	145.12	145.12	145.03	145.07	29300.0
2007-08-20 07:45:00	SPY	ETF	145.12	145.12	145.11	145.11	1500.0
2007-08-20 07:50:00	SPY	ETF	145.08	145.2	145.06	145.2	18200.0
2007-08-20 07:55:00	SPY	ETF	145.18	145.2	145.15	145.18	31300.0
2007-08-20 08:00:00	SPY	ETF	145.2	145.25	144.98	145.11	427900.0
2007-08-20 08:05:00	SPY	ETF	145.12	145.23	145.12	145.23	129200.0
2007-08-20 08:10:00	SPY	ETF	145.15	145.37	145.15	145.33	225200.0
2007-08-20 08:15:00	SPY	ETF	145.33	145.34	145.22	145.22	68300.0
2007-08-20 08:20:00	SPY	ETF	145.22	145.38	145.21	145.29	43000.0
2007-08-20 08:25:00	SPY	ETF	145.31	145.33	145.16	145.19	202500.0
2007-08-20 08:30:00	SPY	ETF	145.19	145.27	145.11	145.15	91000.0
2007-08-20 08:35:00	SPY	ETF	145.14	145.2	145.0	145.18	164600.0
2007-08-20 08:40:00	SPY	ETF	145.18	145.18	145.12	145.13	33700.0
2007-08-20 08:45:00	SPY	ETF	145.13	145.13	145.02	145.09	244100.0
2007-08-20 08:50:00	SPY	ETF	145.07	145.11	144.99	145.07	95800.0
2007-08-20 08:55:00	SPY	ETF	145.09	145.15	145.07	145.15	24500.0
2007-08-20 09:00:00	SPY	ETF	145.18	145.19	145.13	145.18	58000.0
2007-08-20 09:05:00	SPY	ETF	145.18	145.28	145.18	145.27	198900.0
2007-08-20 09:10:00	SPY	ETF	145.28	145.3	144.5	145.25	210900.0
2007-08-20 09:15:00	SPY	ETF	145.21	145.3	145.02	145.18	143400.0
2007-08-20 09:20:00	SPY	ETF	145.19	145.22	145.11	145.11	46100.0
2007-08-20 09:25:00	SPY	ETF	145.11	145.18	145.03	145.13	240600.0
2007-08-20 09:30:00	SPY	ETF	145.17	145.36	145.0	145.32	3140012.0
2007-08-20 09:35:00	SPY	ETF	145.32	145.35	144.84	144.86	4016915.0
2007-08-20 09:40:00	SPY	ETF	144.86	144.92	144.61	144.71	3749843.0
2007-08-20 09:45:00	SPY	ETF	144.69	144.79	144.36	144.42	3391311.0
2007-08-20 09:50:00	SPY	ETF	144.411	144.65	144.39	144.48	3788898.0
2007-08-20 09:55:00	SPY	ETF	144.49	144.83	144.44	144.71	2535170.0
2007-08-20 10:00:00	SPY	ETF	144.71	144.93	144.49	144.56	3431099.0
2007-08-20 10:05:00	SPY	ETF	144.56	145.04	144.55	144.9	2106310.0
2007-08-20 10:10:00	SPY	ETF	144.9	145.05	144.76	144.83	2226405.0
2007-08-20 10:15:00	SPY	ETF	144.84	145.1	144.75	145.03	2588987.0

> showing 50 of 18,061 rows — these rows as CSV

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