PREVIEW / etf_30min / 2008-09-11

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-11.parquet
  size:    178 KB
  rows:    6,220

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-11 04:00:00	SPY	ETF	122.99	122.99	122.99	122.99	400.0
2008-09-11 04:30:00	SPY	ETF	123.09	123.09	123.09	123.09	100.0
2008-09-11 05:30:00	SPY	ETF	122.57	122.57	122.47	122.54	600.0
2008-09-11 06:00:00	SPY	ETF	122.28	122.68	122.27	122.59	54300.0
2008-09-11 06:30:00	SPY	ETF	122.65	122.79	122.58	122.77	65400.0
2008-09-11 07:00:00	SPY	ETF	122.79	122.82	122.55	122.55	493620.0
2008-09-11 07:30:00	SPY	ETF	122.55	122.61	122.0	122.22	1462737.0
2008-09-11 08:00:00	SPY	ETF	122.25	122.77	121.75	121.98	3646568.0
2008-09-11 08:30:00	SPY	ETF	121.79	122.14	121.65	121.9	3443932.0
2008-09-11 09:00:00	SPY	ETF	121.9	122.24	121.9	122.11	2839283.0
2008-09-11 09:30:00	SPY	ETF	122.12	122.32	121.6	121.83	41502075.0
2008-09-11 10:00:00	SPY	ETF	121.83	122.82	121.8	122.24	28078642.0
2008-09-11 10:30:00	SPY	ETF	122.24	123.23	122.08	123.06	30425401.0
2008-09-11 11:00:00	SPY	ETF	123.06	123.46	122.69	122.9	20713061.0
2008-09-11 11:30:00	SPY	ETF	122.91	123.83	122.87	123.69	26198866.0
2008-09-11 12:00:00	SPY	ETF	123.69	124.2	123.45	123.55	23292684.0
2008-09-11 12:30:00	SPY	ETF	123.5512	123.75	123.14	123.38	18513735.0
2008-09-11 13:00:00	SPY	ETF	123.38	123.49	122.67	123.02	14853777.0
2008-09-11 13:30:00	SPY	ETF	123.02	123.92	123.02	123.7	17783079.0
2008-09-11 14:00:00	SPY	ETF	123.69	124.51	123.55	124.38	21211597.0
2008-09-11 14:30:00	SPY	ETF	124.39	124.62	123.95	124.15	14638724.0
2008-09-11 15:00:00	SPY	ETF	124.16	124.66	123.57	123.64	24020136.0
2008-09-11 15:30:00	SPY	ETF	123.65	125.55	123.44	125.51	48715188.0
2008-09-11 16:00:00	SPY	ETF	125.57	125.74	123.45	125.5	14694302.0
2008-09-11 16:30:00	SPY	ETF	125.5	125.79	125.45	125.76	1831658.0
2008-09-11 17:00:00	SPY	ETF	125.77	125.77	125.48	125.48	4239297.0
2008-09-11 17:30:00	SPY	ETF	125.6	125.8	125.55	125.64	274268.0
2008-09-11 18:00:00	SPY	ETF	125.64	125.75	125.46	125.53	238819.0
2008-09-11 18:30:00	SPY	ETF	125.54	125.55	125.37	125.45	172274.0
2008-09-11 19:00:00	SPY	ETF	125.45	125.58	125.45	125.5	4450.0
2008-09-11 19:30:00	SPY	ETF	125.48	125.51	125.36	125.36	44806.0
2008-09-11 04:00:00	QQQ	ETF	42.43	42.43	42.43	42.43	400.0
2008-09-11 04:30:00	QQQ	ETF	42.42	42.43	42.39	42.39	300.0
2008-09-11 05:00:00	QQQ	ETF	42.42	42.42	42.4	42.4	400.0
2008-09-11 05:30:00	QQQ	ETF	42.35	42.35	42.21	42.21	1300.0
2008-09-11 06:00:00	QQQ	ETF	42.31	42.31	42.31	42.31	300.0
2008-09-11 06:30:00	QQQ	ETF	42.28	42.33	42.28	42.31	3500.0
2008-09-11 07:00:00	QQQ	ETF	42.3	42.34	42.25	42.25	373111.0
2008-09-11 07:30:00	QQQ	ETF	42.25	42.27	42.15	42.2	501656.0
2008-09-11 08:00:00	QQQ	ETF	42.2	42.37	42.08	42.12	1056241.0
2008-09-11 08:30:00	QQQ	ETF	42.09	42.12	41.99	42.09	2310498.0
2008-09-11 09:00:00	QQQ	ETF	42.09	42.18	42.08	42.17	714943.0
2008-09-11 09:30:00	QQQ	ETF	42.17	42.4	42.17	42.319	24378116.0
2008-09-11 10:00:00	QQQ	ETF	42.32	42.79	42.31	42.62	22000571.0
2008-09-11 10:30:00	QQQ	ETF	42.61	42.92	42.56	42.88	14665502.0
2008-09-11 11:00:00	QQQ	ETF	42.8899	42.97	42.69	42.78	11608422.0
2008-09-11 11:30:00	QQQ	ETF	42.78	43.18	42.77	43.18	14579156.0
2008-09-11 12:00:00	QQQ	ETF	43.18	43.33	43.02	43.05	9366088.0
2008-09-11 12:30:00	QQQ	ETF	43.05	43.14	42.95	43.08	7397153.0
2008-09-11 13:00:00	QQQ	ETF	43.07	43.11	42.76	42.88	12396019.0

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

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