PREVIEW / etf_30min / 2007-12-06

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-06.parquet
  size:    146 KB
  rows:    5,312

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
2007-12-06 04:00:00	SPY	ETF	149.1	149.1	149.04	149.04	2100.0
2007-12-06 04:30:00	SPY	ETF	149.14	149.14	149.14	149.14	1000.0
2007-12-06 06:00:00	SPY	ETF	149.36	149.43	149.36	149.43	35000.0
2007-12-06 06:30:00	SPY	ETF	149.49	149.58	149.35	149.45	74600.0
2007-12-06 07:00:00	SPY	ETF	149.66	149.67	149.35	149.36	623400.0
2007-12-06 07:30:00	SPY	ETF	149.36	149.36	149.0	149.17	793100.0
2007-12-06 08:00:00	SPY	ETF	149.17	149.35	148.97	149.01	462400.0
2007-12-06 08:30:00	SPY	ETF	149.05	149.2	148.42	148.43	1393400.0
2007-12-06 09:00:00	SPY	ETF	148.42	148.62	148.38	148.61	1077700.0
2007-12-06 09:30:00	SPY	ETF	148.63	149.34	148.57	149.16	11082117.0
2007-12-06 10:00:00	SPY	ETF	149.16	149.44	149.0	149.11	11907858.0
2007-12-06 10:30:00	SPY	ETF	149.109	149.37	148.91	149.32	8995053.0
2007-12-06 11:00:00	SPY	ETF	149.32	149.57	149.04	149.49	8410648.0
2007-12-06 11:30:00	SPY	ETF	149.49	149.61	149.39	149.53	7187929.0
2007-12-06 12:00:00	SPY	ETF	149.54	149.74	149.46	149.55	4460815.0
2007-12-06 12:30:00	SPY	ETF	149.54	149.87	149.52	149.79	4549609.0
2007-12-06 13:00:00	SPY	ETF	149.79	149.91	149.59	149.63	7189838.0
2007-12-06 13:30:00	SPY	ETF	149.63	149.76	149.4	149.5	7552411.0
2007-12-06 14:00:00	SPY	ETF	149.5	150.06	149.43	150.01	8222567.0
2007-12-06 14:30:00	SPY	ETF	150.02	150.57	149.85	150.4	17039738.0
2007-12-06 15:00:00	SPY	ETF	150.4	150.85	150.39	150.8	16742113.0
2007-12-06 15:30:00	SPY	ETF	150.8	151.21	150.57	151.11	21635215.0
2007-12-06 16:00:00	SPY	ETF	151.071	151.15	149.54	150.9	4506900.0
2007-12-06 16:30:00	SPY	ETF	150.9	150.92	150.6047	150.88	236700.0
2007-12-06 17:00:00	SPY	ETF	150.84	150.94	150.1646	150.83	6375800.0
2007-12-06 17:30:00	SPY	ETF	150.86	150.9	150.86	150.88	15300.0
2007-12-06 18:00:00	SPY	ETF	150.87	150.91	150.84	150.84	17000.0
2007-12-06 18:30:00	SPY	ETF	150.86	150.9	150.82	150.83	12000.0
2007-12-06 19:00:00	SPY	ETF	150.81	150.85	150.8	150.84	10700.0
2007-12-06 19:30:00	SPY	ETF	150.82	150.84	150.79	150.83	5900.0
2007-12-06 04:30:00	QQQ	ETF	51.75	51.75	51.75	51.75	1500.0
2007-12-06 05:30:00	QQQ	ETF	51.86	51.89	51.85	51.89	32262.0
2007-12-06 06:00:00	QQQ	ETF	51.9	51.95	51.9	51.9	40600.0
2007-12-06 06:30:00	QQQ	ETF	51.97	51.97	51.97	51.97	200.0
2007-12-06 07:00:00	QQQ	ETF	51.95	51.97	51.87	51.9	182047.0
2007-12-06 07:30:00	QQQ	ETF	51.86	51.9	51.77	51.8	49900.0
2007-12-06 08:00:00	QQQ	ETF	51.83	51.85	51.75	51.77	348512.0
2007-12-06 08:30:00	QQQ	ETF	51.75	51.81	51.63	51.63	722351.0
2007-12-06 09:00:00	QQQ	ETF	51.63	51.64	51.54	51.62	1212775.0
2007-12-06 09:30:00	QQQ	ETF	51.62	51.95	51.61	51.85	11163812.0
2007-12-06 10:00:00	QQQ	ETF	51.84	51.99	51.75	51.7699	7955077.0
2007-12-06 10:30:00	QQQ	ETF	51.77	51.79	51.65	51.77	8222343.0
2007-12-06 11:00:00	QQQ	ETF	51.7701	51.85	51.65	51.8199	4911536.0
2007-12-06 11:30:00	QQQ	ETF	51.8101	51.83	51.75	51.82	4297682.0
2007-12-06 12:00:00	QQQ	ETF	51.82	51.89	51.78	51.82	4002095.0
2007-12-06 12:30:00	QQQ	ETF	51.82	51.92	51.8	51.91	2778781.0
2007-12-06 13:00:00	QQQ	ETF	51.91	51.94	51.81	51.86	4333373.0
2007-12-06 13:30:00	QQQ	ETF	51.85	51.89	51.72	51.76	5860801.0
2007-12-06 14:00:00	QQQ	ETF	51.76	51.97	51.75	51.942	3982610.0
2007-12-06 14:30:00	QQQ	ETF	51.95	52.16	51.95	52.08	9163291.0

> showing 50 of 5,312 rows — these rows as CSV

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