PREVIEW / etf_5min / 2008-09-17

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-09-17.parquet
  size:    613 KB
  rows:    28,140

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-09-17 04:10:00	SPY	ETF	121.0	121.0	120.98	120.98	200.0
2008-09-17 04:15:00	SPY	ETF	121.12	121.12	120.91	121.0	1700.0
2008-09-17 04:20:00	SPY	ETF	121.03	121.03	121.03	121.03	2500.0
2008-09-17 04:25:00	SPY	ETF	120.91	121.03	120.89	121.03	12500.0
2008-09-17 04:30:00	SPY	ETF	121.19	121.22	121.15	121.21	5300.0
2008-09-17 04:35:00	SPY	ETF	121.19	121.31	121.19	121.31	3100.0
2008-09-17 04:40:00	SPY	ETF	121.45	121.45	121.45	121.45	1900.0
2008-09-17 04:55:00	SPY	ETF	121.6	121.63	121.6	121.63	5500.0
2008-09-17 05:00:00	SPY	ETF	121.6	121.6	121.5	121.5	2800.0
2008-09-17 05:05:00	SPY	ETF	121.43	121.5	121.43	121.5	200.0
2008-09-17 05:10:00	SPY	ETF	121.33	121.33	121.33	121.33	100.0
2008-09-17 05:15:00	SPY	ETF	121.75	121.75	121.75	121.75	7500.0
2008-09-17 05:20:00	SPY	ETF	121.75	121.75	121.59	121.59	9000.0
2008-09-17 05:25:00	SPY	ETF	121.58	121.58	121.58	121.58	500.0
2008-09-17 05:30:00	SPY	ETF	121.53	121.64	121.43	121.64	7000.0
2008-09-17 05:35:00	SPY	ETF	121.74	121.75	121.74	121.75	15200.0
2008-09-17 05:45:00	SPY	ETF	121.69	121.69	121.6	121.6	400.0
2008-09-17 05:50:00	SPY	ETF	121.49	121.49	121.48	121.48	300.0
2008-09-17 05:55:00	SPY	ETF	121.44	121.44	121.44	121.44	100.0
2008-09-17 06:00:00	SPY	ETF	121.33	121.35	121.29	121.29	1000.0
2008-09-17 06:05:00	SPY	ETF	121.55	121.55	121.4	121.4	8232.0
2008-09-17 06:15:00	SPY	ETF	121.09	121.12	120.9	120.9	132700.0
2008-09-17 06:20:00	SPY	ETF	120.92	121.22	120.89	121.22	43900.0
2008-09-17 06:25:00	SPY	ETF	121.2	121.21	121.11	121.16	132000.0
2008-09-17 06:30:00	SPY	ETF	121.25	121.26	121.2	121.2	29700.0
2008-09-17 06:35:00	SPY	ETF	121.2	121.55	121.2	121.38	99400.0
2008-09-17 06:40:00	SPY	ETF	121.32	121.41	121.28	121.29	171800.0
2008-09-17 06:45:00	SPY	ETF	121.25	121.44	121.25	121.4	162000.0
2008-09-17 06:50:00	SPY	ETF	121.38	121.53	121.38	121.53	83600.0
2008-09-17 06:55:00	SPY	ETF	121.5	121.51	121.5	121.5	10000.0
2008-09-17 07:00:00	SPY	ETF	121.5	121.8	121.5	121.72	221619.0
2008-09-17 07:05:00	SPY	ETF	121.73	121.75	121.53	121.58	650165.0
2008-09-17 07:10:00	SPY	ETF	121.6	121.75	121.57	121.72	350914.0
2008-09-17 07:15:00	SPY	ETF	121.72	121.73	121.62	121.66	559344.0
2008-09-17 07:20:00	SPY	ETF	121.65	121.66	121.3	121.38	333257.0
2008-09-17 07:25:00	SPY	ETF	121.33	121.5	121.28	121.28	265883.0
2008-09-17 07:30:00	SPY	ETF	121.27	121.44	121.24	121.4	230665.0
2008-09-17 07:35:00	SPY	ETF	121.44	121.59	121.42	121.59	249788.0
2008-09-17 07:40:00	SPY	ETF	121.54	121.54	121.46	121.48	200869.0
2008-09-17 07:45:00	SPY	ETF	121.49	121.51	121.29	121.29	317010.0
2008-09-17 07:50:00	SPY	ETF	121.31	121.5	121.28	121.43	221961.0
2008-09-17 07:55:00	SPY	ETF	121.42	121.44	121.25	121.26	215120.0
2008-09-17 08:00:00	SPY	ETF	121.27	122.407	121.25	121.41	1787458.0
2008-09-17 08:05:00	SPY	ETF	121.42	121.44	121.25	121.28	208635.0
2008-09-17 08:10:00	SPY	ETF	121.27	121.68	121.07	121.09	1290203.0
2008-09-17 08:15:00	SPY	ETF	121.1	121.14	120.49	120.55	2424436.0
2008-09-17 08:20:00	SPY	ETF	120.55	120.76	120.43	120.54	2328731.0
2008-09-17 08:25:00	SPY	ETF	120.53	121.46	120.21	120.34	1891597.0
2008-09-17 08:30:00	SPY	ETF	120.21	122.7	120.15	120.16	2361393.0
2008-09-17 08:35:00	SPY	ETF	120.16	120.41	119.99	120.14	1199400.0

> showing 50 of 28,140 rows — these rows as CSV

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