PREVIEW / etf_5min / 2008-08-28

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-08-28.parquet
  size:    462 KB
  rows:    22,245

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-08-28 04:15:00	SPY	ETF	128.0	128.0	128.0	128.0	300.0
2008-08-28 06:30:00	SPY	ETF	128.51	128.51	128.5	128.5	6000.0
2008-08-28 07:00:00	SPY	ETF	128.51	128.51	128.46	128.46	5100.0
2008-08-28 07:05:00	SPY	ETF	128.43	128.45	128.43	128.45	200.0
2008-08-28 07:10:00	SPY	ETF	128.46	128.46	128.45	128.46	1400.0
2008-08-28 07:15:00	SPY	ETF	128.44	128.44	128.44	128.44	369.0
2008-08-28 07:20:00	SPY	ETF	128.46	128.46	128.46	128.46	1300.0
2008-08-28 07:25:00	SPY	ETF	128.5	128.59	128.5	128.59	30000.0
2008-08-28 07:30:00	SPY	ETF	128.59	128.59	128.59	128.59	5000.0
2008-08-28 07:35:00	SPY	ETF	128.56	128.64	128.56	128.64	49900.0
2008-08-28 07:40:00	SPY	ETF	128.62	128.63	128.53	128.58	83738.0
2008-08-28 07:45:00	SPY	ETF	128.58	128.58	128.54	128.54	88138.0
2008-08-28 07:50:00	SPY	ETF	128.55	128.56	128.5	128.5	30507.0
2008-08-28 07:55:00	SPY	ETF	128.5	128.52	128.5	128.5	23200.0
2008-08-28 08:00:00	SPY	ETF	128.5	128.57	128.5	128.55	110684.0
2008-08-28 08:05:00	SPY	ETF	128.56	128.6	128.48	128.53	42864.0
2008-08-28 08:10:00	SPY	ETF	128.51	128.52	128.44	128.5	41737.0
2008-08-28 08:15:00	SPY	ETF	128.49	128.59	128.43	128.59	98742.0
2008-08-28 08:20:00	SPY	ETF	128.58	128.68	128.5	128.66	210007.0
2008-08-28 08:25:00	SPY	ETF	128.67	129.1	128.65	128.89	243070.0
2008-08-28 08:30:00	SPY	ETF	128.91	129.23	128.91	129.04	1764615.0
2008-08-28 08:35:00	SPY	ETF	129.04	129.33	129.03	129.28	902866.0
2008-08-28 08:40:00	SPY	ETF	129.28	129.39	129.27	129.28	708698.0
2008-08-28 08:45:00	SPY	ETF	129.28	129.31	129.23	129.3	239703.0
2008-08-28 08:50:00	SPY	ETF	129.29	129.5	129.28	129.41	396308.0
2008-08-28 08:55:00	SPY	ETF	129.4	129.44	129.24	129.42	617791.0
2008-08-28 09:00:00	SPY	ETF	129.42	129.44	129.35	129.36	289363.0
2008-08-28 09:05:00	SPY	ETF	129.37	129.4	129.27	129.37	423367.0
2008-08-28 09:10:00	SPY	ETF	129.38	129.42	129.31	129.35	205833.0
2008-08-28 09:15:00	SPY	ETF	129.34	129.38	129.3	129.31	374950.0
2008-08-28 09:20:00	SPY	ETF	129.3	129.34	129.27	129.28	347064.0
2008-08-28 09:25:00	SPY	ETF	129.28	129.32	129.2	129.2	342359.0
2008-08-28 09:30:00	SPY	ETF	129.19	129.4	129.11	129.38	3976224.0
2008-08-28 09:35:00	SPY	ETF	129.37	129.5	129.34	129.42	3743363.0
2008-08-28 09:40:00	SPY	ETF	129.425	129.5	129.21	129.3	4516912.0
2008-08-28 09:45:00	SPY	ETF	129.29	129.37	129.17	129.28	3332269.0
2008-08-28 09:50:00	SPY	ETF	129.28	129.3	129.13	129.24	2347237.0
2008-08-28 09:55:00	SPY	ETF	129.25	129.41	129.23	129.34	2507626.0
2008-08-28 10:00:00	SPY	ETF	129.34	129.47	129.17	129.21	3651243.0
2008-08-28 10:05:00	SPY	ETF	129.21	129.3	129.17	129.28	1671665.0
2008-08-28 10:10:00	SPY	ETF	129.29	129.45	129.24	129.45	1536356.0
2008-08-28 10:15:00	SPY	ETF	129.45	129.5	129.3	129.32	1963567.0
2008-08-28 10:20:00	SPY	ETF	129.33	129.35	129.15	129.27	2157621.0
2008-08-28 10:25:00	SPY	ETF	129.27	129.33	129.21	129.32	1195717.0
2008-08-28 10:30:00	SPY	ETF	129.32	129.35	129.21	129.24	1224918.0
2008-08-28 10:35:00	SPY	ETF	129.24	129.41	129.24	129.35	3621381.0
2008-08-28 10:40:00	SPY	ETF	129.34	129.62	129.29	129.6	2851095.0
2008-08-28 10:45:00	SPY	ETF	129.6	129.66	129.548	129.6	2680362.0
2008-08-28 10:50:00	SPY	ETF	129.6	129.68	129.56	129.62	2879457.0
2008-08-28 10:55:00	SPY	ETF	129.61	129.62	129.51	129.56	1446267.0

> showing 50 of 22,245 rows — these rows as CSV

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