PREVIEW / etf_5min / 2008-05-09

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-05-09.parquet
  size:    439 KB
  rows:    20,788

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
2008-05-09 04:15:00	SPY	ETF	138.7	138.7	138.67	138.67	200.0
2008-05-09 04:20:00	SPY	ETF	138.65	138.65	138.61	138.61	300.0
2008-05-09 04:45:00	SPY	ETF	138.65	138.65	138.65	138.65	1000.0
2008-05-09 04:50:00	SPY	ETF	138.62	138.62	138.62	138.62	6500.0
2008-05-09 05:30:00	SPY	ETF	138.5	138.5	138.5	138.5	100.0
2008-05-09 05:40:00	SPY	ETF	138.34	138.34	138.32	138.32	300.0
2008-05-09 06:00:00	SPY	ETF	138.35	138.35	138.35	138.35	2500.0
2008-05-09 06:10:00	SPY	ETF	138.53	138.53	138.53	138.53	10000.0
2008-05-09 06:20:00	SPY	ETF	138.45	138.5	138.45	138.5	5000.0
2008-05-09 06:25:00	SPY	ETF	138.52	138.52	138.52	138.52	100.0
2008-05-09 06:40:00	SPY	ETF	138.45	138.45	138.38	138.38	52500.0
2008-05-09 06:45:00	SPY	ETF	138.38	138.38	138.35	138.35	5200.0
2008-05-09 06:50:00	SPY	ETF	138.33	138.35	138.33	138.35	4500.0
2008-05-09 06:55:00	SPY	ETF	138.42	138.5	138.42	138.5	31200.0
2008-05-09 07:00:00	SPY	ETF	138.49	138.51	138.43	138.51	112200.0
2008-05-09 07:05:00	SPY	ETF	138.52	138.52	138.44	138.44	127013.0
2008-05-09 07:10:00	SPY	ETF	138.42	138.52	138.42	138.52	40400.0
2008-05-09 07:15:00	SPY	ETF	138.5	138.52	138.49	138.52	28428.0
2008-05-09 07:20:00	SPY	ETF	138.54	138.59	138.54	138.59	47100.0
2008-05-09 07:25:00	SPY	ETF	138.58	138.59	138.52	138.55	39099.0
2008-05-09 07:30:00	SPY	ETF	138.55	138.55	138.51	138.53	58071.0
2008-05-09 07:35:00	SPY	ETF	138.5	138.59	138.5	138.52	29358.0
2008-05-09 07:40:00	SPY	ETF	138.57	138.58	138.54	138.54	6114.0
2008-05-09 07:45:00	SPY	ETF	138.52	138.53	138.44	138.45	66800.0
2008-05-09 07:50:00	SPY	ETF	138.42	138.42	138.36	138.38	188600.0
2008-05-09 07:55:00	SPY	ETF	138.38	138.41	138.35	138.36	556900.0
2008-05-09 08:00:00	SPY	ETF	138.58	139.8	138.36	138.44	379930.0
2008-05-09 08:05:00	SPY	ETF	138.46	138.55	138.46	138.48	308471.0
2008-05-09 08:10:00	SPY	ETF	138.48	138.52	138.46	138.49	229565.0
2008-05-09 08:15:00	SPY	ETF	138.49	138.51	138.49	138.49	207945.0
2008-05-09 08:20:00	SPY	ETF	138.5	138.55	138.38	138.44	184122.0
2008-05-09 08:25:00	SPY	ETF	138.44	138.46	138.4	138.42	74193.0
2008-05-09 08:30:00	SPY	ETF	138.43	138.56	138.43	138.56	199213.0
2008-05-09 08:35:00	SPY	ETF	138.56	138.62	138.53	138.62	311011.0
2008-05-09 08:40:00	SPY	ETF	138.61	138.66	138.57	138.59	205923.0
2008-05-09 08:45:00	SPY	ETF	138.62	138.62	138.51	138.53	69121.0
2008-05-09 08:50:00	SPY	ETF	138.54	138.57	138.5	138.55	146681.0
2008-05-09 08:55:00	SPY	ETF	138.53	138.58	138.5	138.57	55850.0
2008-05-09 09:00:00	SPY	ETF	138.57	138.63	138.57	138.63	77157.0
2008-05-09 09:05:00	SPY	ETF	138.63	138.7	138.6	138.63	462837.0
2008-05-09 09:10:00	SPY	ETF	138.63	138.66	138.62	138.65	38794.0
2008-05-09 09:15:00	SPY	ETF	138.64	138.66	138.55	138.56	66326.0
2008-05-09 09:20:00	SPY	ETF	138.56	138.58	138.52	138.55	123012.0
2008-05-09 09:25:00	SPY	ETF	138.55	138.59	138.53	138.59	138485.0
2008-05-09 09:30:00	SPY	ETF	138.6	138.67	138.45	138.52	3339150.0
2008-05-09 09:35:00	SPY	ETF	138.52	138.78	138.5	138.78	2762713.0
2008-05-09 09:40:00	SPY	ETF	138.78	138.89	138.69	138.82	3044500.0
2008-05-09 09:45:00	SPY	ETF	138.83	138.92	138.75	138.85	2958480.0
2008-05-09 09:50:00	SPY	ETF	138.85	138.92	138.78	138.79	3185022.0
2008-05-09 09:55:00	SPY	ETF	138.79	138.81	138.59	138.6	2688833.0

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

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