PREVIEW / etf_5min / 2008-06-27

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-06-27.parquet
  size:    516 KB
  rows:    24,035

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-06-27 04:10:00	SPY	ETF	128.37	128.38	128.34	128.37	5000.0
2008-06-27 04:15:00	SPY	ETF	128.5	128.5	128.4	128.4	500.0
2008-06-27 04:20:00	SPY	ETF	128.49	128.49	128.42	128.42	800.0
2008-06-27 04:25:00	SPY	ETF	128.3	128.3	128.3	128.3	200.0
2008-06-27 04:35:00	SPY	ETF	128.44	128.44	128.44	128.44	500.0
2008-06-27 04:40:00	SPY	ETF	128.44	128.55	128.44	128.55	1000.0
2008-06-27 04:45:00	SPY	ETF	128.66	128.66	128.66	128.66	100.0
2008-06-27 05:00:00	SPY	ETF	128.52	128.52	128.52	128.52	400.0
2008-06-27 05:10:00	SPY	ETF	128.39	128.39	128.39	128.39	100.0
2008-06-27 05:15:00	SPY	ETF	128.27	128.27	128.27	128.27	200.0
2008-06-27 05:20:00	SPY	ETF	128.15	128.15	128.15	128.15	100.0
2008-06-27 05:30:00	SPY	ETF	128.17	128.17	128.17	128.17	200.0
2008-06-27 05:35:00	SPY	ETF	128.28	128.28	128.28	128.28	500.0
2008-06-27 05:40:00	SPY	ETF	128.45	128.45	128.45	128.45	6000.0
2008-06-27 05:45:00	SPY	ETF	128.44	128.45	128.44	128.45	18000.0
2008-06-27 06:05:00	SPY	ETF	128.38	128.38	128.38	128.38	4800.0
2008-06-27 06:10:00	SPY	ETF	128.38	128.38	128.38	128.38	5200.0
2008-06-27 06:15:00	SPY	ETF	128.35	128.35	128.35	128.35	600.0
2008-06-27 06:20:00	SPY	ETF	128.55	128.56	128.55	128.56	32700.0
2008-06-27 06:25:00	SPY	ETF	128.43	128.43	128.43	128.43	2000.0
2008-06-27 06:35:00	SPY	ETF	128.48	128.48	128.48	128.48	25000.0
2008-06-27 06:40:00	SPY	ETF	128.49	128.49	128.4	128.4	75000.0
2008-06-27 06:50:00	SPY	ETF	128.45	128.46	128.45	128.46	1500.0
2008-06-27 06:55:00	SPY	ETF	128.39	128.39	128.33	128.33	7100.0
2008-06-27 07:00:00	SPY	ETF	128.31	128.31	128.12	128.15	81767.0
2008-06-27 07:05:00	SPY	ETF	128.15	128.24	128.12	128.22	43900.0
2008-06-27 07:10:00	SPY	ETF	128.22	128.25	128.12	128.12	12300.0
2008-06-27 07:15:00	SPY	ETF	128.19	128.24	128.19	128.21	7200.0
2008-06-27 07:20:00	SPY	ETF	128.2	128.2	128.07	128.17	60259.0
2008-06-27 07:25:00	SPY	ETF	128.09	128.15	128.0	128.05	183945.0
2008-06-27 07:30:00	SPY	ETF	127.97	128.05	127.9	127.9	102000.0
2008-06-27 07:35:00	SPY	ETF	127.82	127.91	127.58	127.73	363385.0
2008-06-27 07:40:00	SPY	ETF	127.67	127.7	127.59	127.59	137907.0
2008-06-27 07:45:00	SPY	ETF	127.62	127.82	127.62	127.8	116475.0
2008-06-27 07:50:00	SPY	ETF	127.8	127.83	127.73	127.77	102264.0
2008-06-27 07:55:00	SPY	ETF	127.77	127.98	127.76	127.82	105410.0
2008-06-27 08:00:00	SPY	ETF	127.84	127.97	127.81	127.85	865606.0
2008-06-27 08:05:00	SPY	ETF	127.84	128.28	127.74	128.09	258233.0
2008-06-27 08:10:00	SPY	ETF	127.79	127.82	127.74	127.77	490662.0
2008-06-27 08:15:00	SPY	ETF	127.77	127.88	127.74	127.79	140673.0
2008-06-27 08:20:00	SPY	ETF	127.79	127.86	127.73	127.78	131434.0
2008-06-27 08:25:00	SPY	ETF	127.75	127.83	127.75	127.79	123567.0
2008-06-27 08:30:00	SPY	ETF	127.91	128.29	127.86	128.07	1799237.0
2008-06-27 08:35:00	SPY	ETF	128.06	128.19	127.67	128.09	1344793.0
2008-06-27 08:40:00	SPY	ETF	128.08	128.24	128.02	128.17	312308.0
2008-06-27 08:45:00	SPY	ETF	128.17	128.27	127.67	128.09	1023542.0
2008-06-27 08:50:00	SPY	ETF	128.07	128.25	128.07	128.25	580435.0
2008-06-27 08:55:00	SPY	ETF	128.25	128.46	128.24	128.38	1379250.0
2008-06-27 09:00:00	SPY	ETF	128.38	128.53	128.37	128.41	434644.0
2008-06-27 09:05:00	SPY	ETF	128.4	128.5	128.33	128.41	815083.0

> showing 50 of 24,035 rows — these rows as CSV

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