PREVIEW / etf_5min / 2010-01-22

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-01-22.parquet
  size:    849 KB
  rows:    34,485

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
2010-01-22 04:15:00	SPY	ETF	111.85	111.89	111.85	111.89	3700.0
2010-01-22 04:20:00	SPY	ETF	111.85	111.91	111.85	111.91	650.0
2010-01-22 04:25:00	SPY	ETF	111.92	111.92	111.92	111.92	100.0
2010-01-22 04:35:00	SPY	ETF	111.96	111.96	111.93	111.93	200.0
2010-01-22 04:40:00	SPY	ETF	111.89	111.89	111.89	111.89	100.0
2010-01-22 04:50:00	SPY	ETF	111.88	111.88	111.88	111.88	100.0
2010-01-22 05:00:00	SPY	ETF	111.92	111.92	111.89	111.89	200.0
2010-01-22 05:05:00	SPY	ETF	111.86	111.86	111.86	111.86	2000.0
2010-01-22 05:10:00	SPY	ETF	111.85	111.85	111.85	111.85	200.0
2010-01-22 05:20:00	SPY	ETF	111.75	111.75	111.75	111.75	100.0
2010-01-22 05:25:00	SPY	ETF	111.75	111.77	111.74	111.77	10100.0
2010-01-22 05:45:00	SPY	ETF	111.79	111.79	111.74	111.74	300.0
2010-01-22 05:50:00	SPY	ETF	111.68	111.68	111.65	111.65	1000.0
2010-01-22 05:55:00	SPY	ETF	111.64	111.64	111.64	111.64	200.0
2010-01-22 06:05:00	SPY	ETF	111.74	111.74	111.74	111.74	1600.0
2010-01-22 06:10:00	SPY	ETF	111.7	111.7	111.7	111.7	1000.0
2010-01-22 06:15:00	SPY	ETF	111.66	111.7	111.66	111.7	3500.0
2010-01-22 06:25:00	SPY	ETF	111.64	111.64	111.53	111.55	2500.0
2010-01-22 06:30:00	SPY	ETF	111.62	111.74	111.62	111.68	20500.0
2010-01-22 06:35:00	SPY	ETF	111.65	111.66	111.48	111.53	10300.0
2010-01-22 06:40:00	SPY	ETF	111.58	111.58	111.5	111.5	300.0
2010-01-22 06:45:00	SPY	ETF	111.4	111.42	111.15	111.16	36800.0
2010-01-22 06:50:00	SPY	ETF	111.18	111.18	110.98	111.11	51000.0
2010-01-22 06:55:00	SPY	ETF	111.2	111.2	111.1	111.1	900.0
2010-01-22 07:00:00	SPY	ETF	111.15	111.21	111.14	111.21	21638.0
2010-01-22 07:05:00	SPY	ETF	111.2	111.25	111.18	111.25	71807.0
2010-01-22 07:10:00	SPY	ETF	111.26	111.26	111.2	111.23	27890.0
2010-01-22 07:15:00	SPY	ETF	111.28	111.37	111.28	111.35	48145.0
2010-01-22 07:20:00	SPY	ETF	111.37	111.4	111.29	111.4	40015.0
2010-01-22 07:25:00	SPY	ETF	111.4	111.42	111.34	111.39	10966.0
2010-01-22 07:30:00	SPY	ETF	111.42	111.44	111.39	111.41	8977.0
2010-01-22 07:35:00	SPY	ETF	111.4	111.4	111.31	111.31	16300.0
2010-01-22 07:40:00	SPY	ETF	111.3	111.35	111.27	111.27	41185.0
2010-01-22 07:45:00	SPY	ETF	111.29	111.3	111.2	111.22	260914.0
2010-01-22 07:50:00	SPY	ETF	111.22	111.34	111.21	111.34	125892.0
2010-01-22 07:55:00	SPY	ETF	111.34	111.46	111.31	111.35	201778.0
2010-01-22 08:00:00	SPY	ETF	111.34	111.45	111.21	111.21	120418.0
2010-01-22 08:05:00	SPY	ETF	111.42	111.43	111.24	111.25	169224.0
2010-01-22 08:10:00	SPY	ETF	111.25	111.36	111.23	111.28	141652.0
2010-01-22 08:15:00	SPY	ETF	111.28	111.38	111.28	111.38	681152.0
2010-01-22 08:20:00	SPY	ETF	111.39	111.43	111.33	111.41	203307.0
2010-01-22 08:25:00	SPY	ETF	111.4	111.46	111.38	111.43	108614.0
2010-01-22 08:30:00	SPY	ETF	111.43	111.54	111.43	111.49	733605.0
2010-01-22 08:35:00	SPY	ETF	111.49	111.49	111.37	111.49	319385.0
2010-01-22 08:40:00	SPY	ETF	111.48	111.49	111.36	111.36	762825.0
2010-01-22 08:45:00	SPY	ETF	111.36	111.46	111.36	111.39	182078.0
2010-01-22 08:50:00	SPY	ETF	111.4	111.4	111.28	111.32	331353.0
2010-01-22 08:55:00	SPY	ETF	111.31	111.34	111.1	111.11	622880.0
2010-01-22 09:00:00	SPY	ETF	111.11	111.32	111.11	111.3	374366.0
2010-01-22 09:05:00	SPY	ETF	111.29	111.35	111.24	111.29	265118.0

> showing 50 of 34,485 rows — these rows as CSV

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