PREVIEW / etf_5min / 2009-07-09

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-09.parquet
  size:    663 KB
  rows:    28,731

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
2009-07-09 04:15:00	SPY	ETF	88.52	88.53	88.52	88.53	800.0
2009-07-09 04:25:00	SPY	ETF	88.54	88.54	88.53	88.53	200.0
2009-07-09 04:30:00	SPY	ETF	88.55	88.63	88.55	88.63	500.0
2009-07-09 04:35:00	SPY	ETF	88.6	88.6	88.6	88.6	100.0
2009-07-09 04:45:00	SPY	ETF	88.62	88.62	88.62	88.62	200.0
2009-07-09 05:25:00	SPY	ETF	88.56	88.57	88.56	88.57	1000.0
2009-07-09 05:30:00	SPY	ETF	88.62	88.65	88.62	88.65	2700.0
2009-07-09 05:35:00	SPY	ETF	88.67	88.67	88.67	88.67	200.0
2009-07-09 05:40:00	SPY	ETF	88.61	88.61	88.61	88.61	100.0
2009-07-09 05:45:00	SPY	ETF	88.63	88.63	88.63	88.63	200.0
2009-07-09 05:50:00	SPY	ETF	88.68	88.69	88.68	88.69	2625.0
2009-07-09 05:55:00	SPY	ETF	88.74	88.75	88.73	88.74	40000.0
2009-07-09 06:05:00	SPY	ETF	88.7	88.73	88.7	88.73	1000.0
2009-07-09 06:10:00	SPY	ETF	88.73	88.75	88.7	88.75	2600.0
2009-07-09 06:15:00	SPY	ETF	88.68	88.68	88.65	88.65	400.0
2009-07-09 06:20:00	SPY	ETF	88.63	88.66	88.62	88.66	10700.0
2009-07-09 06:25:00	SPY	ETF	88.64	88.68	88.61	88.62	6500.0
2009-07-09 06:30:00	SPY	ETF	88.59	88.59	88.55	88.55	10200.0
2009-07-09 06:35:00	SPY	ETF	88.56	88.56	88.56	88.56	100.0
2009-07-09 06:40:00	SPY	ETF	88.56	88.56	88.56	88.56	2500.0
2009-07-09 06:45:00	SPY	ETF	88.59	88.6	88.56	88.56	26700.0
2009-07-09 06:50:00	SPY	ETF	88.57	88.6	88.55	88.6	56500.0
2009-07-09 06:55:00	SPY	ETF	88.6	88.6	88.53	88.53	2900.0
2009-07-09 07:00:00	SPY	ETF	88.52	88.55	88.47	88.49	54600.0
2009-07-09 07:05:00	SPY	ETF	88.46	88.48	88.41	88.43	10500.0
2009-07-09 07:10:00	SPY	ETF	88.41	88.44	88.4	88.44	21650.0
2009-07-09 07:15:00	SPY	ETF	88.44	88.45	88.39	88.4	57100.0
2009-07-09 07:20:00	SPY	ETF	88.4	88.45	88.38	88.4	10700.0
2009-07-09 07:25:00	SPY	ETF	88.36	88.43	88.36	88.41	16413.0
2009-07-09 07:30:00	SPY	ETF	88.42	88.5	88.42	88.46	23050.0
2009-07-09 07:35:00	SPY	ETF	88.46	88.46	88.38	88.43	83700.0
2009-07-09 07:40:00	SPY	ETF	88.44	88.44	88.43	88.44	1750.0
2009-07-09 07:45:00	SPY	ETF	88.44	88.51	88.41	88.51	35462.0
2009-07-09 07:50:00	SPY	ETF	88.51	88.56	88.51	88.56	9100.0
2009-07-09 07:55:00	SPY	ETF	88.55	88.59	88.52	88.57	36414.0
2009-07-09 08:00:00	SPY	ETF	88.57	88.59	88.3	88.53	848256.0
2009-07-09 08:05:00	SPY	ETF	88.54	88.61	88.52	88.58	391673.0
2009-07-09 08:10:00	SPY	ETF	88.44	88.59	88.44	88.59	482054.0
2009-07-09 08:15:00	SPY	ETF	88.59	88.59	88.55	88.55	24340.0
2009-07-09 08:20:00	SPY	ETF	88.54	88.55	88.47	88.52	366992.0
2009-07-09 08:25:00	SPY	ETF	88.52	88.63	88.51	88.53	452713.0
2009-07-09 08:30:00	SPY	ETF	88.61	88.9	88.53	88.59	1684499.0
2009-07-09 08:35:00	SPY	ETF	88.58	88.69	88.53	88.68	535752.0
2009-07-09 08:40:00	SPY	ETF	88.67	88.72	88.65	88.66	353976.0
2009-07-09 08:45:00	SPY	ETF	88.67	88.76	88.67	88.74	605659.0
2009-07-09 08:50:00	SPY	ETF	88.75	88.86	88.75	88.79	521042.0
2009-07-09 08:55:00	SPY	ETF	88.79	88.79	88.71	88.72	114846.0
2009-07-09 09:00:00	SPY	ETF	88.71	88.71	88.59	88.59	208722.0
2009-07-09 09:05:00	SPY	ETF	88.58	88.65	88.58	88.64	197040.0
2009-07-09 09:10:00	SPY	ETF	88.65	88.72	88.63	88.68	492472.0

> showing 50 of 28,731 rows — these rows as CSV

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