PREVIEW / etf_30min / 2008-09-16

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-16.parquet
  size:    190 KB
  rows:    6,665

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-16 04:00:00	SPY	ETF	119.45	119.45	119.33	119.45	300.0
2008-09-16 05:00:00	SPY	ETF	119.88	120.0	119.79	120.0	1200.0
2008-09-16 05:30:00	SPY	ETF	120.16	120.25	119.9	120.22	7200.0
2008-09-16 06:00:00	SPY	ETF	120.22	120.22	119.21	119.21	739590.0
2008-09-16 06:30:00	SPY	ETF	119.2	119.23	118.95	119.01	581439.0
2008-09-16 07:00:00	SPY	ETF	118.99	119.01	118.37	118.76	1801378.0
2008-09-16 07:30:00	SPY	ETF	118.79	119.06	118.42	118.87	2941198.0
2008-09-16 08:00:00	SPY	ETF	118.87	119.3	118.1	118.27	11262953.0
2008-09-16 08:30:00	SPY	ETF	118.45	118.55	117.34	117.61	12622537.0
2008-09-16 09:00:00	SPY	ETF	117.61	117.77	116.71	117.22	8720368.0
2008-09-16 09:30:00	SPY	ETF	117.2	118.92	117.0	117.79	64112360.0
2008-09-16 10:00:00	SPY	ETF	117.79	119.51	117.79	119.45	47525443.0
2008-09-16 10:30:00	SPY	ETF	119.45	120.58	118.69	120.03	47889330.0
2008-09-16 11:00:00	SPY	ETF	120.0299	121.0	118.68	118.78	49309349.0
2008-09-16 11:30:00	SPY	ETF	118.78	119.98	118.66	119.82	18548180.0
2008-09-16 12:00:00	SPY	ETF	119.82	120.41	119.37	120.13	28663100.0
2008-09-16 12:30:00	SPY	ETF	120.13	120.21	119.59	120.16	17255880.0
2008-09-16 13:00:00	SPY	ETF	120.16	120.45	119.86	120.198	17279007.0
2008-09-16 13:30:00	SPY	ETF	120.19	120.25	119.47	119.7	14374254.0
2008-09-16 14:00:00	SPY	ETF	119.7	120.54	117.97	118.72	55837248.0
2008-09-16 14:30:00	SPY	ETF	118.74	121.49	118.39	121.18	68667271.0
2008-09-16 15:00:00	SPY	ETF	121.19	122.09	120.71	120.86	33703665.0
2008-09-16 15:30:00	SPY	ETF	120.86	121.97	120.79	121.88	35537473.0
2008-09-16 16:00:00	SPY	ETF	121.9	123.35	119.7612	122.43	16963428.0
2008-09-16 16:30:00	SPY	ETF	122.43	122.43	120.13	120.29	9136389.0
2008-09-16 17:00:00	SPY	ETF	120.32	121.27	120.32	120.98	1716484.0
2008-09-16 17:30:00	SPY	ETF	120.74	121.5	120.62	120.8	693263.0
2008-09-16 18:00:00	SPY	ETF	120.76	120.8	120.39	120.47	916525.0
2008-09-16 18:30:00	SPY	ETF	120.5	122.1	118.6218	120.88	11285132.0
2008-09-16 19:00:00	SPY	ETF	120.87	123.12	120.87	122.83	2180255.0
2008-09-16 19:30:00	SPY	ETF	122.83	123.25	122.39	122.63	721857.0
2008-09-16 20:00:00	SPY	ETF	122.64	122.64	122.64	122.64	500.0
2008-09-16 04:00:00	QQQ	ETF	42.1	42.1	42.1	42.1	200.0
2008-09-16 05:00:00	QQQ	ETF	42.2	42.49	42.2	42.49	5200.0
2008-09-16 05:30:00	QQQ	ETF	42.53	42.56	42.38	42.42	4700.0
2008-09-16 06:00:00	QQQ	ETF	42.47	42.47	42.3	42.3	2700.0
2008-09-16 06:30:00	QQQ	ETF	42.24	42.26	42.22	42.24	4100.0
2008-09-16 07:00:00	QQQ	ETF	42.2	42.2	41.84	41.99	1182759.0
2008-09-16 07:30:00	QQQ	ETF	41.98	42.17	41.94	42.1	1017773.0
2008-09-16 08:00:00	QQQ	ETF	42.11	42.11	41.81	41.93	2979161.0
2008-09-16 08:30:00	QQQ	ETF	41.93	41.98	41.52	41.61	4716513.0
2008-09-16 09:00:00	QQQ	ETF	41.61	42.21	41.41	41.47	6708939.0
2008-09-16 09:30:00	QQQ	ETF	41.47	41.77	41.43	41.51	41886745.0
2008-09-16 10:00:00	QQQ	ETF	41.5	42.18	41.49	42.09	30320706.0
2008-09-16 10:30:00	QQQ	ETF	42.09	42.31	41.73	42.25	32893477.0
2008-09-16 11:00:00	QQQ	ETF	42.25	42.5	41.74	41.81	26824784.0
2008-09-16 11:30:00	QQQ	ETF	41.81	42.13	41.77	42.07	11582612.0
2008-09-16 12:00:00	QQQ	ETF	42.08	42.35	42.01	42.26	16959535.0
2008-09-16 12:30:00	QQQ	ETF	42.26	42.29	42.0	42.24	7684658.0
2008-09-16 13:00:00	QQQ	ETF	42.23	42.26	42.055	42.07	6112061.0

> showing 50 of 6,665 rows — these rows as CSV

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