PREVIEW / etf_5min / 2007-11-16

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-11-16.parquet
  size:    409 KB
  rows:    19,637

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-16 05:05:00	SPY	ETF	145.5	145.5	145.5	145.5	1800.0
2007-11-16 05:40:00	SPY	ETF	145.35	145.35	145.35	145.35	200.0
2007-11-16 05:50:00	SPY	ETF	145.66	145.66	145.66	145.66	1000.0
2007-11-16 05:55:00	SPY	ETF	145.72	145.72	145.72	145.72	4000.0
2007-11-16 06:05:00	SPY	ETF	145.7	145.7	145.7	145.7	4000.0
2007-11-16 06:10:00	SPY	ETF	145.76	145.76	145.76	145.76	25000.0
2007-11-16 06:20:00	SPY	ETF	145.89	145.93	145.89	145.93	100000.0
2007-11-16 06:35:00	SPY	ETF	145.82	145.82	145.82	145.82	10000.0
2007-11-16 06:45:00	SPY	ETF	145.84	145.84	145.78	145.78	5000.0
2007-11-16 06:50:00	SPY	ETF	145.79	145.8	145.79	145.8	10000.0
2007-11-16 06:55:00	SPY	ETF	145.76	145.76	145.76	145.76	100.0
2007-11-16 07:00:00	SPY	ETF	145.69	145.75	145.65	145.74	83800.0
2007-11-16 07:05:00	SPY	ETF	145.77	145.84	145.76	145.84	122400.0
2007-11-16 07:10:00	SPY	ETF	145.87	145.9	145.87	145.9	25300.0
2007-11-16 07:15:00	SPY	ETF	145.88	146.02	145.88	146.02	155300.0
2007-11-16 07:20:00	SPY	ETF	146.01	146.11	145.96	146.11	229900.0
2007-11-16 07:25:00	SPY	ETF	146.13	146.34	146.13	146.34	195200.0
2007-11-16 07:30:00	SPY	ETF	146.34	146.35	146.23	146.23	246000.0
2007-11-16 07:35:00	SPY	ETF	146.25	146.3	146.23	146.25	48900.0
2007-11-16 07:40:00	SPY	ETF	146.29	146.33	146.2	146.2	39000.0
2007-11-16 07:45:00	SPY	ETF	146.2	146.23	146.17	146.2	21700.0
2007-11-16 07:50:00	SPY	ETF	146.18	146.21	146.14	146.18	34900.0
2007-11-16 07:55:00	SPY	ETF	146.18	146.22	146.17	146.22	36700.0
2007-11-16 08:00:00	SPY	ETF	146.21	146.46	145.68	146.37	1165100.0
2007-11-16 08:05:00	SPY	ETF	146.37	146.38	146.32	146.32	108700.0
2007-11-16 08:10:00	SPY	ETF	146.33	146.36	146.31	146.31	74200.0
2007-11-16 08:15:00	SPY	ETF	146.31	146.31	146.15	146.18	150600.0
2007-11-16 08:20:00	SPY	ETF	146.16	146.21	146.1	146.2	355300.0
2007-11-16 08:25:00	SPY	ETF	146.21	146.3	146.1	146.22	1788400.0
2007-11-16 08:30:00	SPY	ETF	146.22	146.35	145.78	146.29	679000.0
2007-11-16 08:35:00	SPY	ETF	146.28	146.3	146.27	146.29	143900.0
2007-11-16 08:40:00	SPY	ETF	146.3	146.42	146.27	146.37	126800.0
2007-11-16 08:45:00	SPY	ETF	146.34	146.42	146.27	146.42	164200.0
2007-11-16 08:50:00	SPY	ETF	146.4	146.41	146.31	146.38	116500.0
2007-11-16 08:55:00	SPY	ETF	146.39	146.49	146.34	146.44	644900.0
2007-11-16 09:00:00	SPY	ETF	146.43	146.43	146.15	146.15	936400.0
2007-11-16 09:05:00	SPY	ETF	146.14	146.17	146.0	146.1	349500.0
2007-11-16 09:10:00	SPY	ETF	146.1	146.18	146.06	146.12	561700.0
2007-11-16 09:15:00	SPY	ETF	146.14	146.27	146.05	146.14	651100.0
2007-11-16 09:20:00	SPY	ETF	146.14	146.22	146.13	146.21	87800.0
2007-11-16 09:25:00	SPY	ETF	146.22	146.34	146.18	146.28	417300.0
2007-11-16 09:30:00	SPY	ETF	146.28	146.33	146.11	146.16	7082031.0
2007-11-16 09:35:00	SPY	ETF	146.16	146.43	145.86	145.89	5897131.0
2007-11-16 09:40:00	SPY	ETF	145.88	146.15	145.87	145.87	3897344.0
2007-11-16 09:45:00	SPY	ETF	145.87	145.89	145.65	145.85	4370905.0
2007-11-16 09:50:00	SPY	ETF	145.85	145.86	145.5	145.56	3825141.0
2007-11-16 09:55:00	SPY	ETF	145.57	145.76	145.29	145.31	3489438.0
2007-11-16 10:00:00	SPY	ETF	145.31	145.59	144.84	144.94	13573060.0
2007-11-16 10:05:00	SPY	ETF	144.95	145.12	144.76	145.06	10177451.0
2007-11-16 10:10:00	SPY	ETF	145.07	145.68	145.04	145.14	4640825.0

> showing 50 of 19,637 rows — these rows as CSV

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