PREVIEW / etf_5min / 2006-07-06

all etf 5-min files

  file:    by_date/etf_5min/2006/2006-07-06.parquet
  size:    201 KB
  rows:    10,227

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
2006-07-06 04:35:00	SPY	ETF	127.35	127.4	127.35	127.4	400.0
2006-07-06 05:40:00	SPY	ETF	127.39	127.39	127.39	127.39	100.0
2006-07-06 05:45:00	SPY	ETF	127.38	127.38	127.38	127.38	100.0
2006-07-06 06:35:00	SPY	ETF	127.32	127.32	127.32	127.32	100.0
2006-07-06 06:50:00	SPY	ETF	127.34	127.34	127.34	127.34	1000.0
2006-07-06 07:00:00	SPY	ETF	127.29	127.29	127.29	127.29	400.0
2006-07-06 07:05:00	SPY	ETF	127.29	127.3	127.29	127.29	400.0
2006-07-06 07:15:00	SPY	ETF	127.27	127.27	127.27	127.27	500.0
2006-07-06 07:20:00	SPY	ETF	127.22	127.22	127.22	127.22	200.0
2006-07-06 07:25:00	SPY	ETF	127.22	127.22	127.22	127.22	800.0
2006-07-06 07:45:00	SPY	ETF	127.23	127.3	127.23	127.3	7200.0
2006-07-06 07:50:00	SPY	ETF	127.3	127.3	127.25	127.25	8800.0
2006-07-06 07:55:00	SPY	ETF	127.3	127.3	127.3	127.3	4900.0
2006-07-06 08:00:00	SPY	ETF	127.29	127.33	127.19	127.3	42200.0
2006-07-06 08:05:00	SPY	ETF	127.28	127.31	127.28	127.3	9800.0
2006-07-06 08:10:00	SPY	ETF	127.31	127.32	127.28	127.32	12200.0
2006-07-06 08:15:00	SPY	ETF	127.3	127.38	127.3	127.38	274800.0
2006-07-06 08:20:00	SPY	ETF	127.33	127.34	127.33	127.33	6900.0
2006-07-06 08:25:00	SPY	ETF	127.35	127.38	127.35	127.35	61200.0
2006-07-06 08:30:00	SPY	ETF	127.36	127.44	127.3	127.3	67300.0
2006-07-06 08:35:00	SPY	ETF	127.3	127.35	127.25	127.25	53100.0
2006-07-06 08:40:00	SPY	ETF	127.28	127.43	127.26	127.32	450400.0
2006-07-06 08:45:00	SPY	ETF	127.35	127.36	127.32	127.32	5000.0
2006-07-06 08:50:00	SPY	ETF	127.32	127.33	127.27	127.28	38600.0
2006-07-06 08:55:00	SPY	ETF	127.27	127.28	127.27	127.28	11000.0
2006-07-06 09:00:00	SPY	ETF	127.28	127.28	127.25	127.25	8700.0
2006-07-06 09:05:00	SPY	ETF	127.26	127.26	127.22	127.25	16800.0
2006-07-06 09:10:00	SPY	ETF	127.25	127.3	127.25	127.27	36700.0
2006-07-06 09:15:00	SPY	ETF	127.23	127.26	127.22	127.26	20400.0
2006-07-06 09:20:00	SPY	ETF	127.26	127.26	127.22	127.24	9800.0
2006-07-06 09:25:00	SPY	ETF	127.25	127.25	127.2	127.2	22000.0
2006-07-06 09:30:00	SPY	ETF	127.2	127.5	127.17	127.48	652500.0
2006-07-06 09:35:00	SPY	ETF	127.48	127.51	127.33	127.39	566800.0
2006-07-06 09:40:00	SPY	ETF	127.39	127.48	127.24	127.26	514400.0
2006-07-06 09:45:00	SPY	ETF	127.28	127.35	127.24	127.27	483200.0
2006-07-06 09:50:00	SPY	ETF	127.28	127.44	127.26	127.39	507700.0
2006-07-06 09:55:00	SPY	ETF	127.39	127.42	127.34	127.37	720700.0
2006-07-06 10:00:00	SPY	ETF	127.37	127.57	127.33	127.5	1133000.0
2006-07-06 10:05:00	SPY	ETF	127.5	127.58	127.42	127.56	583300.0
2006-07-06 10:10:00	SPY	ETF	127.56	127.6	127.49	127.55	567300.0
2006-07-06 10:15:00	SPY	ETF	127.55	127.67	127.53	127.63	775300.0
2006-07-06 10:20:00	SPY	ETF	127.63	127.76	127.6	127.71	1096200.0
2006-07-06 10:25:00	SPY	ETF	127.7295	127.83	127.7	127.74	1258900.0
2006-07-06 10:30:00	SPY	ETF	127.73	127.8	127.64	127.69	903200.0
2006-07-06 10:35:00	SPY	ETF	127.68	127.72	127.58	127.71	741400.0
2006-07-06 10:40:00	SPY	ETF	127.72	127.8	127.67	127.68	770900.0
2006-07-06 10:45:00	SPY	ETF	127.6894	127.7	127.6	127.6	476400.0
2006-07-06 10:50:00	SPY	ETF	127.6094	127.65	127.52	127.56	757700.0
2006-07-06 10:55:00	SPY	ETF	127.55	127.7	127.52	127.64	1204100.0
2006-07-06 11:00:00	SPY	ETF	127.63	127.69	127.56	127.63	654500.0

> showing 50 of 10,227 rows — these rows as CSV

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