PREVIEW / etf_5min / 2007-08-23

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-08-23.parquet
  size:    366 KB
  rows:    17,837

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-23 04:05:00	SPY	ETF	147.87	147.87	147.87	147.87	700.0
2007-08-23 04:50:00	SPY	ETF	147.7	147.7	147.7	147.7	1000.0
2007-08-23 05:00:00	SPY	ETF	147.77	147.77	147.77	147.77	1000.0
2007-08-23 05:50:00	SPY	ETF	148.0	148.0	148.0	148.0	1100.0
2007-08-23 06:05:00	SPY	ETF	148.05	148.05	147.99	147.99	900.0
2007-08-23 06:15:00	SPY	ETF	148.0	148.0	148.0	148.0	25000.0
2007-08-23 06:30:00	SPY	ETF	148.03	148.04	148.03	148.04	900.0
2007-08-23 06:35:00	SPY	ETF	148.03	148.03	148.03	148.03	3000.0
2007-08-23 06:40:00	SPY	ETF	148.0	148.0	148.0	148.0	500.0
2007-08-23 06:45:00	SPY	ETF	147.89	147.92	147.85	147.92	2500.0
2007-08-23 06:50:00	SPY	ETF	147.89	147.89	147.89	147.89	1000.0
2007-08-23 06:55:00	SPY	ETF	147.89	147.89	147.89	147.89	2500.0
2007-08-23 07:00:00	SPY	ETF	147.88	147.89	147.84	147.84	144700.0
2007-08-23 07:05:00	SPY	ETF	147.83	147.9	147.82	147.87	62800.0
2007-08-23 07:10:00	SPY	ETF	147.84	147.9	147.8	147.9	66400.0
2007-08-23 07:15:00	SPY	ETF	147.88	147.98	147.88	147.96	42900.0
2007-08-23 07:20:00	SPY	ETF	147.95	148.02	147.95	147.99	129700.0
2007-08-23 07:25:00	SPY	ETF	147.94	148.02	147.94	147.97	96800.0
2007-08-23 07:30:00	SPY	ETF	148.0	148.03	147.97	148.03	73600.0
2007-08-23 07:35:00	SPY	ETF	148.0	148.02	147.99	147.99	48900.0
2007-08-23 07:40:00	SPY	ETF	147.99	147.99	147.82	147.82	68400.0
2007-08-23 07:45:00	SPY	ETF	147.83	147.86	147.65	147.65	107800.0
2007-08-23 07:50:00	SPY	ETF	147.67	147.75	147.59	147.73	77200.0
2007-08-23 07:55:00	SPY	ETF	147.7	147.7	147.6	147.68	47300.0
2007-08-23 08:00:00	SPY	ETF	147.69	148.05	147.54	147.56	732200.0
2007-08-23 08:05:00	SPY	ETF	147.58	147.65	147.52	147.63	32100.0
2007-08-23 08:10:00	SPY	ETF	147.63	147.65	147.55	147.57	178700.0
2007-08-23 08:15:00	SPY	ETF	147.57	147.6	147.46	147.46	202300.0
2007-08-23 08:20:00	SPY	ETF	147.48	147.66	147.47	147.62	262700.0
2007-08-23 08:25:00	SPY	ETF	147.62	147.97	147.53	147.59	679000.0
2007-08-23 08:30:00	SPY	ETF	147.61	147.66	147.53	147.55	91700.0
2007-08-23 08:35:00	SPY	ETF	147.56	147.8	147.53	147.56	257100.0
2007-08-23 08:40:00	SPY	ETF	147.53	147.53	147.45	147.45	40300.0
2007-08-23 08:45:00	SPY	ETF	147.45	147.47	147.38	147.41	156700.0
2007-08-23 08:50:00	SPY	ETF	147.42	148.13	147.36	147.37	213600.0
2007-08-23 08:55:00	SPY	ETF	147.37	147.9	147.32	147.33	414500.0
2007-08-23 09:00:00	SPY	ETF	147.35	148.0	147.31	147.43	229600.0
2007-08-23 09:05:00	SPY	ETF	147.45	147.45	147.37	147.41	333300.0
2007-08-23 09:10:00	SPY	ETF	147.42	147.6	147.42	147.56	442500.0
2007-08-23 09:15:00	SPY	ETF	147.55	147.6	147.47	147.48	657000.0
2007-08-23 09:20:00	SPY	ETF	147.49	147.57	147.42	147.46	472000.0
2007-08-23 09:25:00	SPY	ETF	147.45	147.46	147.32	147.33	321300.0
2007-08-23 09:30:00	SPY	ETF	147.34	147.65	147.33	147.4	4931437.0
2007-08-23 09:35:00	SPY	ETF	147.4	147.43	147.14	147.42	8135600.0
2007-08-23 09:40:00	SPY	ETF	147.43	147.44	147.05	147.06	2692200.0
2007-08-23 09:45:00	SPY	ETF	147.07	147.09	146.86	146.99	7435200.0
2007-08-23 09:50:00	SPY	ETF	146.98	147.04	146.66	146.7	4882000.0
2007-08-23 09:55:00	SPY	ETF	146.7	146.9914	146.55	146.79	4745400.0
2007-08-23 10:00:00	SPY	ETF	146.79	146.89	146.65	146.8	3715900.0
2007-08-23 10:05:00	SPY	ETF	146.81	147.04	146.75	146.75	4224008.0

> showing 50 of 17,837 rows — these rows as CSV

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