PREVIEW / etf_30min / 2008-09-17

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-17.parquet
  size:    191 KB
  rows:    6,699

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:00:00	SPY	ETF	121.0	121.12	120.89	121.03	16900.0
2008-09-17 04:30:00	SPY	ETF	121.19	121.63	121.15	121.63	15800.0
2008-09-17 05:00:00	SPY	ETF	121.6	121.75	121.33	121.58	20100.0
2008-09-17 05:30:00	SPY	ETF	121.53	121.75	121.43	121.44	23000.0
2008-09-17 06:00:00	SPY	ETF	121.33	121.55	120.89	121.16	317832.0
2008-09-17 06:30:00	SPY	ETF	121.25	121.55	121.2	121.5	556500.0
2008-09-17 07:00:00	SPY	ETF	121.5	121.8	121.28	121.28	2381182.0
2008-09-17 07:30:00	SPY	ETF	121.27	121.59	121.24	121.26	1435413.0
2008-09-17 08:00:00	SPY	ETF	121.27	122.407	120.21	120.34	9931060.0
2008-09-17 08:30:00	SPY	ETF	120.21	122.7	119.58	119.59	8353195.0
2008-09-17 09:00:00	SPY	ETF	119.59	119.93	119.17	119.62	9097491.0
2008-09-17 09:30:00	SPY	ETF	119.64	120.34	118.94	120.07	50510011.0
2008-09-17 10:00:00	SPY	ETF	120.07	120.38	119.18	119.28	33296230.0
2008-09-17 10:30:00	SPY	ETF	119.26	119.54	118.41	118.73	35338096.0
2008-09-17 11:00:00	SPY	ETF	118.74	118.87	117.14	117.34	40071738.0
2008-09-17 11:30:00	SPY	ETF	117.34	118.45	117.18	117.77	39078235.0
2008-09-17 12:00:00	SPY	ETF	117.77	117.78	116.71	117.02	32509142.0
2008-09-17 12:30:00	SPY	ETF	117.02	121.8517	116.96	117.98	39072025.0
2008-09-17 13:00:00	SPY	ETF	117.98	118.54	117.18	117.24	24801719.0
2008-09-17 13:30:00	SPY	ETF	117.24	117.9	116.0	117.18	40115805.0
2008-09-17 14:00:00	SPY	ETF	117.19	118.67	116.87	118.66	44718571.0
2008-09-17 14:30:00	SPY	ETF	118.65	121.8517	118.06	118.59	52805582.0
2008-09-17 15:00:00	SPY	ETF	118.59	119.69	118.32	118.72	44962214.0
2008-09-17 15:30:00	SPY	ETF	118.72	121.8516	116.02	116.3	61241494.0
2008-09-17 16:00:00	SPY	ETF	116.32	121.75	116.13	116.97	23792486.0
2008-09-17 16:30:00	SPY	ETF	116.9	121.8517	116.61	116.9	8210003.0
2008-09-17 17:00:00	SPY	ETF	116.86	121.8517	116.75	116.76	8348455.0
2008-09-17 17:30:00	SPY	ETF	116.84	117.54	116.65	116.65	9506521.0
2008-09-17 18:00:00	SPY	ETF	116.65	121.8517	116.65	116.78	2294486.0
2008-09-17 18:30:00	SPY	ETF	116.76	117.23	116.21	116.72	209070.0
2008-09-17 19:00:00	SPY	ETF	116.77	116.83	116.65	116.65	53976.0
2008-09-17 19:30:00	SPY	ETF	116.62	116.85	116.62	116.79	181530.0
2008-09-17 04:00:00	QQQ	ETF	42.12	42.13	42.07	42.08	4600.0
2008-09-17 04:30:00	QQQ	ETF	42.16	42.3	42.16	42.3	1600.0
2008-09-17 05:00:00	QQQ	ETF	42.35	42.35	42.27	42.29	2500.0
2008-09-17 05:30:00	QQQ	ETF	42.38	42.38	42.28	42.28	200.0
2008-09-17 06:00:00	QQQ	ETF	42.33	42.33	42.13	42.3	29800.0
2008-09-17 06:30:00	QQQ	ETF	42.26	42.38	42.24	42.37	8500.0
2008-09-17 07:00:00	QQQ	ETF	42.44	42.45	42.17	42.21	316241.0
2008-09-17 07:30:00	QQQ	ETF	42.2	42.38	42.2	42.33	481995.0
2008-09-17 08:00:00	QQQ	ETF	42.32	42.8	42.04	42.05	3205349.0
2008-09-17 08:30:00	QQQ	ETF	42.05	42.4	41.96	41.97	2242217.0
2008-09-17 09:00:00	QQQ	ETF	41.97	42.03	41.77	41.84	2954302.0
2008-09-17 09:30:00	QQQ	ETF	41.85	42.05	41.4999	41.92	37811112.0
2008-09-17 10:00:00	QQQ	ETF	41.92	42.0	41.58	41.62	25353115.0
2008-09-17 10:30:00	QQQ	ETF	41.63	41.72	41.33	41.43	22572747.0
2008-09-17 11:00:00	QQQ	ETF	41.43	41.46	40.87	40.92	24019387.0
2008-09-17 11:30:00	QQQ	ETF	40.91	41.23	40.88	41.12	19423704.0
2008-09-17 12:00:00	QQQ	ETF	41.11	41.12	40.84	40.928	20617252.0
2008-09-17 12:30:00	QQQ	ETF	40.93	41.26	40.9199	41.0599	12995570.0

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

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