PREVIEW / etf_5min / 2009-07-01

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-01.parquet
  size:    643 KB
  rows:    27,978

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-01 04:15:00	SPY	ETF	92.53	92.59	92.53	92.59	1374.0
2009-07-01 04:20:00	SPY	ETF	92.58	92.58	92.58	92.58	500.0
2009-07-01 04:45:00	SPY	ETF	92.59	92.59	92.59	92.59	100.0
2009-07-01 04:50:00	SPY	ETF	92.67	92.67	92.67	92.67	100.0
2009-07-01 05:05:00	SPY	ETF	92.62	92.62	92.62	92.62	2000.0
2009-07-01 05:35:00	SPY	ETF	92.62	92.66	92.62	92.66	60000.0
2009-07-01 05:45:00	SPY	ETF	92.6	92.6	92.6	92.6	100.0
2009-07-01 06:10:00	SPY	ETF	92.58	92.62	92.58	92.62	300.0
2009-07-01 06:15:00	SPY	ETF	92.7	92.7	92.7	92.7	100.0
2009-07-01 06:20:00	SPY	ETF	92.7	92.7	92.67	92.68	5600.0
2009-07-01 06:25:00	SPY	ETF	92.74	92.8	92.73	92.73	1500.0
2009-07-01 06:30:00	SPY	ETF	92.73	92.74	92.73	92.73	400.0
2009-07-01 06:35:00	SPY	ETF	92.68	92.7	92.68	92.7	2200.0
2009-07-01 06:40:00	SPY	ETF	92.67	92.67	92.61	92.61	6700.0
2009-07-01 06:45:00	SPY	ETF	92.57	92.62	92.57	92.62	2800.0
2009-07-01 06:50:00	SPY	ETF	92.62	92.62	92.62	92.62	200.0
2009-07-01 06:55:00	SPY	ETF	92.51	92.51	92.5	92.5	300.0
2009-07-01 07:00:00	SPY	ETF	92.5	92.52	92.48	92.5	88770.0
2009-07-01 07:05:00	SPY	ETF	92.5	92.51	92.46	92.46	12000.0
2009-07-01 07:10:00	SPY	ETF	92.48	92.52	92.41	92.43	33400.0
2009-07-01 07:15:00	SPY	ETF	92.42	92.42	92.35	92.36	15710.0
2009-07-01 07:20:00	SPY	ETF	92.37	92.42	92.37	92.42	3960.0
2009-07-01 07:25:00	SPY	ETF	92.42	92.43	92.37	92.42	111900.0
2009-07-01 07:30:00	SPY	ETF	92.39	92.47	92.39	92.46	144195.0
2009-07-01 07:35:00	SPY	ETF	92.47	92.52	92.46	92.52	198955.0
2009-07-01 07:40:00	SPY	ETF	92.52	92.55	92.51	92.54	72837.0
2009-07-01 07:45:00	SPY	ETF	92.54	92.54	92.46	92.5	135732.0
2009-07-01 07:50:00	SPY	ETF	92.49	92.6	92.49	92.55	42995.0
2009-07-01 07:55:00	SPY	ETF	92.55	92.63	92.55	92.63	177117.0
2009-07-01 08:00:00	SPY	ETF	92.63	92.64	92.4	92.55	1233687.0
2009-07-01 08:05:00	SPY	ETF	92.54	92.56	92.51	92.53	66400.0
2009-07-01 08:10:00	SPY	ETF	92.53	92.62	92.52	92.58	150104.0
2009-07-01 08:15:00	SPY	ETF	92.58	92.68	92.21	92.3	1026014.0
2009-07-01 08:20:00	SPY	ETF	92.3	92.45	92.05	92.34	898740.0
2009-07-01 08:25:00	SPY	ETF	92.33	92.54	92.0	92.53	755488.0
2009-07-01 08:30:00	SPY	ETF	92.53	92.58	92.52	92.57	300136.0
2009-07-01 08:35:00	SPY	ETF	92.57	92.67	92.32	92.32	1026284.0
2009-07-01 08:40:00	SPY	ETF	92.32	92.34	92.27	92.32	142642.0
2009-07-01 08:45:00	SPY	ETF	92.32	92.38	92.32	92.38	80389.0
2009-07-01 08:50:00	SPY	ETF	92.37	92.38	92.33	92.37	115164.0
2009-07-01 08:55:00	SPY	ETF	92.37	92.44	92.35	92.44	149800.0
2009-07-01 09:00:00	SPY	ETF	92.43	92.54	92.41	92.53	115816.0
2009-07-01 09:05:00	SPY	ETF	92.53	92.54	92.47	92.49	1609264.0
2009-07-01 09:10:00	SPY	ETF	92.5	92.53	92.49	92.52	281106.0
2009-07-01 09:15:00	SPY	ETF	92.52	92.54	92.49	92.49	195272.0
2009-07-01 09:20:00	SPY	ETF	92.5	92.53	92.45	92.51	947571.0
2009-07-01 09:25:00	SPY	ETF	92.51	92.54	92.33	92.35	1805877.0
2009-07-01 09:30:00	SPY	ETF	92.34	92.57	92.33	92.45	4223383.0
2009-07-01 09:35:00	SPY	ETF	92.46	92.69	92.43	92.59	4820325.0
2009-07-01 09:40:00	SPY	ETF	92.6	92.68	92.54	92.62	2625853.0

> showing 50 of 27,978 rows — these rows as CSV

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