PREVIEW / etf_5min / 2007-11-19

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-11-19.parquet
  size:    437 KB
  rows:    20,870

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-11-19 04:15:00	SPY	ETF	145.93	145.93	145.93	145.93	1000.0
2007-11-19 04:45:00	SPY	ETF	145.53	145.53	145.53	145.53	1000.0
2007-11-19 05:40:00	SPY	ETF	145.43	145.43	145.43	145.43	10000.0
2007-11-19 05:45:00	SPY	ETF	145.38	145.38	145.38	145.38	10000.0
2007-11-19 05:50:00	SPY	ETF	145.37	145.37	145.37	145.37	100.0
2007-11-19 06:05:00	SPY	ETF	145.1	145.1	145.1	145.1	5000.0
2007-11-19 06:10:00	SPY	ETF	145.19	145.19	145.18	145.18	2000.0
2007-11-19 06:15:00	SPY	ETF	145.23	145.23	145.23	145.23	5000.0
2007-11-19 06:20:00	SPY	ETF	145.35	145.35	145.29	145.29	3500.0
2007-11-19 06:25:00	SPY	ETF	145.02	145.02	144.93	144.93	17400.0
2007-11-19 06:30:00	SPY	ETF	145.05	145.07	145.05	145.07	15000.0
2007-11-19 06:35:00	SPY	ETF	145.15	145.15	145.15	145.15	100.0
2007-11-19 06:40:00	SPY	ETF	145.09	145.09	145.09	145.09	500.0
2007-11-19 06:55:00	SPY	ETF	145.11	145.17	145.1	145.15	25400.0
2007-11-19 07:00:00	SPY	ETF	145.15	145.32	145.11	145.23	232700.0
2007-11-19 07:05:00	SPY	ETF	145.22	145.28	145.22	145.28	21000.0
2007-11-19 07:10:00	SPY	ETF	145.27	145.27	145.18	145.2	88600.0
2007-11-19 07:15:00	SPY	ETF	145.3	145.34	145.15	145.2	197600.0
2007-11-19 07:20:00	SPY	ETF	145.17	145.19	145.09	145.19	143000.0
2007-11-19 07:25:00	SPY	ETF	145.2	145.21	145.15	145.18	144500.0
2007-11-19 07:30:00	SPY	ETF	145.18	145.19	145.15	145.18	89900.0
2007-11-19 07:35:00	SPY	ETF	145.16	145.19	145.1	145.1	51000.0
2007-11-19 07:40:00	SPY	ETF	145.13	145.2	145.13	145.2	20800.0
2007-11-19 07:45:00	SPY	ETF	145.21	145.35	145.21	145.35	18300.0
2007-11-19 07:50:00	SPY	ETF	145.38	145.46	145.33	145.33	23400.0
2007-11-19 07:55:00	SPY	ETF	145.36	145.36	145.32	145.32	6400.0
2007-11-19 08:00:00	SPY	ETF	145.3	145.3	145.14	145.22	275800.0
2007-11-19 08:05:00	SPY	ETF	145.2	145.24	145.19	145.2	330100.0
2007-11-19 08:10:00	SPY	ETF	145.2	145.23	145.05	145.09	128200.0
2007-11-19 08:15:00	SPY	ETF	145.11	145.2	145.1	145.2	82200.0
2007-11-19 08:20:00	SPY	ETF	145.23	145.25	145.0	145.03	114800.0
2007-11-19 08:25:00	SPY	ETF	145.04	145.14	145.0	145.14	88700.0
2007-11-19 08:30:00	SPY	ETF	145.15	145.2	145.09	145.15	48100.0
2007-11-19 08:35:00	SPY	ETF	145.17	145.17	145.1	145.14	62600.0
2007-11-19 08:40:00	SPY	ETF	145.14	145.17	145.04	145.15	138900.0
2007-11-19 08:45:00	SPY	ETF	145.15	145.15	145.1	145.12	45500.0
2007-11-19 08:50:00	SPY	ETF	145.14	145.21	145.11	145.21	50900.0
2007-11-19 08:55:00	SPY	ETF	145.22	145.25	145.17	145.17	42000.0
2007-11-19 09:00:00	SPY	ETF	145.15	145.15	145.02	145.07	123100.0
2007-11-19 09:05:00	SPY	ETF	145.03	145.21	145.03	145.19	186900.0
2007-11-19 09:10:00	SPY	ETF	145.2	145.23	145.1304	145.19	252209.0
2007-11-19 09:15:00	SPY	ETF	145.15	145.18	145.11	145.18	54100.0
2007-11-19 09:20:00	SPY	ETF	145.18	145.2	145.16	145.2	92800.0
2007-11-19 09:25:00	SPY	ETF	145.21	145.31	145.21	145.27	86900.0
2007-11-19 09:30:00	SPY	ETF	145.28	145.36	145.06	145.06	2080106.0
2007-11-19 09:35:00	SPY	ETF	145.06	145.2826	144.87	145.02	6237744.0
2007-11-19 09:40:00	SPY	ETF	145.02	145.12	144.56	144.97	5375849.0
2007-11-19 09:45:00	SPY	ETF	144.97	145.26	144.97	145.16	2842515.0
2007-11-19 09:50:00	SPY	ETF	145.16	145.28	145.01	145.24	2153389.0
2007-11-19 09:55:00	SPY	ETF	145.25	145.31	144.88	144.88	3627204.0

> showing 50 of 20,870 rows — these rows as CSV

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