PREVIEW / etf_5min / 2009-08-31

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-31.parquet
  size:    667 KB
  rows:    28,950

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-08-31 04:15:00	SPY	ETF	102.43	102.44	102.43	102.44	33259.0
2009-08-31 04:20:00	SPY	ETF	102.44	102.44	102.44	102.44	2100.0
2009-08-31 04:25:00	SPY	ETF	102.38	102.47	102.38	102.47	1336.0
2009-08-31 04:35:00	SPY	ETF	102.43	102.45	102.43	102.45	600.0
2009-08-31 04:45:00	SPY	ETF	102.58	102.58	102.58	102.58	200.0
2009-08-31 04:50:00	SPY	ETF	102.68	102.68	102.68	102.68	1000.0
2009-08-31 04:55:00	SPY	ETF	102.67	102.67	102.67	102.67	700.0
2009-08-31 05:00:00	SPY	ETF	102.69	102.69	102.69	102.69	300.0
2009-08-31 05:05:00	SPY	ETF	102.79	102.79	102.79	102.79	100.0
2009-08-31 05:20:00	SPY	ETF	102.64	102.64	102.64	102.64	1000.0
2009-08-31 05:30:00	SPY	ETF	102.61	102.61	102.61	102.61	500.0
2009-08-31 06:05:00	SPY	ETF	102.58	102.58	102.58	102.58	4980.0
2009-08-31 06:10:00	SPY	ETF	102.58	102.58	102.58	102.58	4980.0
2009-08-31 06:25:00	SPY	ETF	102.48	102.48	102.47	102.47	5000.0
2009-08-31 06:30:00	SPY	ETF	102.59	102.59	102.59	102.59	500.0
2009-08-31 06:40:00	SPY	ETF	102.64	102.64	102.63	102.63	2000.0
2009-08-31 06:45:00	SPY	ETF	102.63	102.68	102.63	102.68	3000.0
2009-08-31 06:50:00	SPY	ETF	102.71	102.71	102.66	102.66	1036.0
2009-08-31 06:55:00	SPY	ETF	102.53	102.53	102.53	102.53	4202.0
2009-08-31 07:00:00	SPY	ETF	102.52	102.54	102.5	102.52	11121.0
2009-08-31 07:05:00	SPY	ETF	102.52	102.57	102.52	102.57	1300.0
2009-08-31 07:10:00	SPY	ETF	102.59	102.59	102.55	102.55	3300.0
2009-08-31 07:15:00	SPY	ETF	102.55	102.59	102.55	102.57	2698.0
2009-08-31 07:20:00	SPY	ETF	102.59	102.62	102.59	102.62	20400.0
2009-08-31 07:25:00	SPY	ETF	102.64	102.65	102.59	102.65	8088.0
2009-08-31 07:30:00	SPY	ETF	102.63	102.69	102.63	102.63	11832.0
2009-08-31 07:35:00	SPY	ETF	102.62	102.62	102.62	102.62	2630.0
2009-08-31 07:40:00	SPY	ETF	102.61	102.62	102.6	102.6	105130.0
2009-08-31 07:45:00	SPY	ETF	102.6	102.61	102.57	102.59	112645.0
2009-08-31 07:50:00	SPY	ETF	102.56	102.57	102.55	102.55	17570.0
2009-08-31 07:55:00	SPY	ETF	102.55	102.56	102.52	102.55	77369.0
2009-08-31 08:00:00	SPY	ETF	103.5	103.5	102.44	102.45	229700.0
2009-08-31 08:05:00	SPY	ETF	102.44	102.46	102.41	102.45	73153.0
2009-08-31 08:10:00	SPY	ETF	102.45	102.52	102.41	102.43	565327.0
2009-08-31 08:15:00	SPY	ETF	102.52	102.52	102.45	102.47	40929.0
2009-08-31 08:20:00	SPY	ETF	102.47	102.53	102.47	102.53	32123.0
2009-08-31 08:25:00	SPY	ETF	102.53	102.56	102.5	102.5	63279.0
2009-08-31 08:30:00	SPY	ETF	102.5	102.5	102.45	102.49	104125.0
2009-08-31 08:35:00	SPY	ETF	102.49	102.52	102.47	102.52	93003.0
2009-08-31 08:40:00	SPY	ETF	102.51	102.52	102.5	102.52	94071.0
2009-08-31 08:45:00	SPY	ETF	102.52	102.57	102.5	102.57	123754.0
2009-08-31 08:50:00	SPY	ETF	102.57	102.58	102.55	102.55	91332.0
2009-08-31 08:55:00	SPY	ETF	102.55	102.57	102.54	102.57	40946.0
2009-08-31 09:00:00	SPY	ETF	102.56	102.56	102.52	102.52	83005.0
2009-08-31 09:05:00	SPY	ETF	102.52	102.53	102.39	102.43	166721.0
2009-08-31 09:10:00	SPY	ETF	102.43	102.52	102.42	102.51	284860.0
2009-08-31 09:15:00	SPY	ETF	102.52	102.57	102.48	102.54	258805.0
2009-08-31 09:20:00	SPY	ETF	102.54	102.56	102.52	102.52	91966.0
2009-08-31 09:25:00	SPY	ETF	102.52	103.38	102.36	102.37	662482.0
2009-08-31 09:30:00	SPY	ETF	102.37	102.51	102.3	102.36	5987351.0

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

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