PREVIEW / etf_5min / 2008-04-23

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-04-23.parquet
  size:    462 KB
  rows:    21,581

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-04-23 04:40:00	SPY	ETF	138.41	138.41	138.41	138.41	200.0
2008-04-23 04:45:00	SPY	ETF	138.34	138.34	138.34	138.34	100.0
2008-04-23 06:00:00	SPY	ETF	138.2	138.2	138.18	138.18	10000.0
2008-04-23 06:10:00	SPY	ETF	138.18	138.18	138.18	138.18	5000.0
2008-04-23 06:30:00	SPY	ETF	138.1	138.1	138.1	138.1	100.0
2008-04-23 06:35:00	SPY	ETF	138.05	138.05	137.96	137.98	75100.0
2008-04-23 06:40:00	SPY	ETF	137.9	137.9	137.83	137.9	26000.0
2008-04-23 06:45:00	SPY	ETF	137.86	137.9	137.86	137.9	35000.0
2008-04-23 06:50:00	SPY	ETF	137.79	137.79	137.74	137.74	1200.0
2008-04-23 06:55:00	SPY	ETF	137.72	137.72	137.6	137.64	2300.0
2008-04-23 07:00:00	SPY	ETF	137.64	137.68	137.57	137.62	134000.0
2008-04-23 07:05:00	SPY	ETF	137.62	137.62	137.5	137.54	174954.0
2008-04-23 07:10:00	SPY	ETF	137.5	137.56	137.43	137.43	61700.0
2008-04-23 07:15:00	SPY	ETF	137.42	137.44	137.26	137.38	130640.0
2008-04-23 07:20:00	SPY	ETF	137.38	137.55	137.38	137.55	35000.0
2008-04-23 07:25:00	SPY	ETF	137.55	137.6	137.48	137.48	38614.0
2008-04-23 07:30:00	SPY	ETF	137.46	137.6	137.45	137.55	60550.0
2008-04-23 07:35:00	SPY	ETF	137.58	137.6	137.55	137.55	64700.0
2008-04-23 07:40:00	SPY	ETF	137.58	137.7	137.56	137.57	52500.0
2008-04-23 07:45:00	SPY	ETF	137.62	137.7	137.6	137.64	255800.0
2008-04-23 07:50:00	SPY	ETF	137.62	137.62	137.49	137.56	122260.0
2008-04-23 07:55:00	SPY	ETF	137.58	137.64	137.58	137.64	3865.0
2008-04-23 08:00:00	SPY	ETF	137.64	137.75	137.6	137.7	102600.0
2008-04-23 08:05:00	SPY	ETF	137.7	137.79	137.7	137.73	114800.0
2008-04-23 08:10:00	SPY	ETF	137.75	137.79	137.7	137.71	514005.0
2008-04-23 08:15:00	SPY	ETF	137.71	137.77	137.66	137.7	211593.0
2008-04-23 08:20:00	SPY	ETF	137.71	137.76	137.7	137.73	75193.0
2008-04-23 08:25:00	SPY	ETF	137.74	137.74	137.6	137.62	45438.0
2008-04-23 08:30:00	SPY	ETF	137.63	137.7	137.63	137.68	105407.0
2008-04-23 08:35:00	SPY	ETF	137.68	137.77	137.63	137.76	132978.0
2008-04-23 08:40:00	SPY	ETF	137.77	137.85	137.77	137.84	220043.0
2008-04-23 08:45:00	SPY	ETF	137.82	137.9	137.79	137.89	37742.0
2008-04-23 08:50:00	SPY	ETF	137.89	137.92	137.88	137.89	199822.0
2008-04-23 08:55:00	SPY	ETF	137.87	137.93	137.81	137.82	207989.0
2008-04-23 09:00:00	SPY	ETF	137.79	137.83	137.75	137.83	76100.0
2008-04-23 09:05:00	SPY	ETF	137.83	138.03	137.83	138.02	618672.0
2008-04-23 09:10:00	SPY	ETF	138.01	138.14	138.01	138.12	877873.0
2008-04-23 09:15:00	SPY	ETF	138.11	138.16	138.07	138.09	143530.0
2008-04-23 09:20:00	SPY	ETF	138.08	138.12	138.05	138.09	307917.0
2008-04-23 09:25:00	SPY	ETF	138.1	138.14	138.07	138.1	510413.0
2008-04-23 09:30:00	SPY	ETF	138.09	138.17	137.91	137.92	2604375.0
2008-04-23 09:35:00	SPY	ETF	137.92	138.14	137.7	137.78	4228474.0
2008-04-23 09:40:00	SPY	ETF	137.78	137.8201	137.58	137.7	2246281.0
2008-04-23 09:45:00	SPY	ETF	137.7	137.71	137.44	137.59	4326498.0
2008-04-23 09:50:00	SPY	ETF	137.59	137.73	137.5	137.7	2115979.0
2008-04-23 09:55:00	SPY	ETF	137.7	137.77	137.53	137.61	2092683.0
2008-04-23 10:00:00	SPY	ETF	137.62	137.63	137.45	137.49	2460899.0
2008-04-23 10:05:00	SPY	ETF	137.49	137.65	137.42	137.57	1805820.0
2008-04-23 10:10:00	SPY	ETF	137.57	137.58	137.42	137.57	1780110.0
2008-04-23 10:15:00	SPY	ETF	137.57	137.8	137.57	137.72	2247105.0

> showing 50 of 21,581 rows — these rows as CSV

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