PREVIEW / etf_5min / 2007-08-08

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-08-08.parquet
  size:    406 KB
  rows:    19,734

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-08 04:10:00	SPY	ETF	147.99	147.99	147.99	147.99	2000.0
2007-08-08 06:20:00	SPY	ETF	148.2	148.2	148.2	148.2	10000.0
2007-08-08 07:00:00	SPY	ETF	148.2	148.45	148.2	148.45	316100.0
2007-08-08 07:05:00	SPY	ETF	148.38	148.38	148.38	148.38	100.0
2007-08-08 07:10:00	SPY	ETF	148.39	148.45	148.39	148.45	6300.0
2007-08-08 07:15:00	SPY	ETF	148.45	148.45	148.4	148.4	5300.0
2007-08-08 07:20:00	SPY	ETF	148.45	148.47	148.45	148.47	108900.0
2007-08-08 07:25:00	SPY	ETF	148.42	148.5	148.42	148.5	41200.0
2007-08-08 07:30:00	SPY	ETF	148.47	148.55	148.47	148.55	28100.0
2007-08-08 07:35:00	SPY	ETF	148.56	148.56	148.5	148.54	75500.0
2007-08-08 07:40:00	SPY	ETF	148.6	148.6	148.5	148.5	159500.0
2007-08-08 07:45:00	SPY	ETF	148.53	148.6	148.53	148.6	70600.0
2007-08-08 07:50:00	SPY	ETF	148.6	148.77	148.6	148.75	96200.0
2007-08-08 07:55:00	SPY	ETF	148.7	148.73	148.65	148.65	144000.0
2007-08-08 08:00:00	SPY	ETF	148.56	148.74	148.4	148.58	3502400.0
2007-08-08 08:05:00	SPY	ETF	148.58	148.58	148.51	148.55	411400.0
2007-08-08 08:10:00	SPY	ETF	148.53	148.57	148.5	148.56	124700.0
2007-08-08 08:15:00	SPY	ETF	148.56	148.61	148.52	148.52	402200.0
2007-08-08 08:20:00	SPY	ETF	148.52	148.54	148.51	148.52	58600.0
2007-08-08 08:25:00	SPY	ETF	148.52	148.57	148.51	148.54	299700.0
2007-08-08 08:30:00	SPY	ETF	148.51	148.55	148.5	148.54	70100.0
2007-08-08 08:35:00	SPY	ETF	148.52	148.65	148.52	148.62	105800.0
2007-08-08 08:40:00	SPY	ETF	148.64	148.65	148.54	148.56	96400.0
2007-08-08 08:45:00	SPY	ETF	148.56	148.58	148.52	148.58	66400.0
2007-08-08 08:50:00	SPY	ETF	148.59	148.61	148.57	148.59	44900.0
2007-08-08 08:55:00	SPY	ETF	148.59	148.59	148.44	148.45	184300.0
2007-08-08 09:00:00	SPY	ETF	148.45	148.53	148.43	148.51	109400.0
2007-08-08 09:05:00	SPY	ETF	148.53	148.58	148.53	148.55	24900.0
2007-08-08 09:10:00	SPY	ETF	148.52	148.52	148.46	148.47	185300.0
2007-08-08 09:15:00	SPY	ETF	148.47	148.5	148.38	148.38	834085.0
2007-08-08 09:20:00	SPY	ETF	148.39	148.42	148.35	148.4	396400.0
2007-08-08 09:25:00	SPY	ETF	148.41	148.52	148.37	148.41	1539300.0
2007-08-08 09:30:00	SPY	ETF	148.41	148.77	148.35	148.67	4939216.0
2007-08-08 09:35:00	SPY	ETF	148.67	148.83	148.58	148.71	3695610.0
2007-08-08 09:40:00	SPY	ETF	148.72	148.99	148.61	148.91	4705358.0
2007-08-08 09:45:00	SPY	ETF	148.91	148.99	148.83	148.87	4885781.0
2007-08-08 09:50:00	SPY	ETF	148.87	149.04	148.86	148.91	3980441.0
2007-08-08 09:55:00	SPY	ETF	148.91	148.95	148.73	148.84	6092535.0
2007-08-08 10:00:00	SPY	ETF	148.84	149.02	148.77	148.97	3349530.0
2007-08-08 10:05:00	SPY	ETF	148.98	148.98	148.72	148.79	3331830.0
2007-08-08 10:10:00	SPY	ETF	148.81	148.96	148.78	148.91	2852082.0
2007-08-08 10:15:00	SPY	ETF	148.91	149.25	148.88	149.17	4192003.0
2007-08-08 10:20:00	SPY	ETF	149.18	149.42	149.11	149.38	2635750.0
2007-08-08 10:25:00	SPY	ETF	149.38	149.42	149.24	149.29	2114200.0
2007-08-08 10:30:00	SPY	ETF	149.3	149.48	148.66	149.33	2267163.0
2007-08-08 10:35:00	SPY	ETF	149.34	149.52	149.25	149.43	2492777.0
2007-08-08 10:40:00	SPY	ETF	149.42	149.64	148.61	149.63	2846529.0
2007-08-08 10:45:00	SPY	ETF	149.62	149.84	149.59	149.71	4226425.0
2007-08-08 10:50:00	SPY	ETF	149.72	149.76	149.57	149.6	2739545.0
2007-08-08 10:55:00	SPY	ETF	149.6	149.69	149.45	149.61	4088811.0

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

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