PREVIEW / etf_30min / 2007-12-10

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-10.parquet
  size:    136 KB
  rows:    5,196

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-10 04:30:00	SPY	ETF	150.5	150.97	150.5	150.97	3800.0
2007-12-10 05:00:00	SPY	ETF	151.09	151.21	151.09	151.21	3100.0
2007-12-10 05:30:00	SPY	ETF	151.26	151.26	151.14	151.14	8400.0
2007-12-10 06:00:00	SPY	ETF	151.18	151.27	151.18	151.23	7400.0
2007-12-10 06:30:00	SPY	ETF	151.3	151.32	151.2	151.2	15200.0
2007-12-10 07:00:00	SPY	ETF	151.24	151.26	151.08	151.1	74700.0
2007-12-10 07:30:00	SPY	ETF	151.1	151.5	151.1	151.48	406800.0
2007-12-10 08:00:00	SPY	ETF	151.49	151.56	151.41	151.46	1148600.0
2007-12-10 08:30:00	SPY	ETF	151.47	151.51	151.15	151.31	387850.0
2007-12-10 09:00:00	SPY	ETF	151.32	151.35	151.22	151.25	989174.0
2007-12-10 09:30:00	SPY	ETF	151.28	151.52	150.86	151.43	10741160.0
2007-12-10 10:00:00	SPY	ETF	151.42	152.02	151.42	151.81	14805289.0
2007-12-10 10:30:00	SPY	ETF	151.81	152.17	151.81	152.16	10142549.0
2007-12-10 11:00:00	SPY	ETF	152.16	152.23	151.8	151.88	9508874.0
2007-12-10 11:30:00	SPY	ETF	151.8701	152.0	151.75	151.83	6345800.0
2007-12-10 12:00:00	SPY	ETF	151.82	152.01	151.7	151.97	3250500.0
2007-12-10 12:30:00	SPY	ETF	151.96	152.0	151.83	151.83	2888562.0
2007-12-10 13:00:00	SPY	ETF	151.84	152.25	151.84	152.01	4665085.0
2007-12-10 13:30:00	SPY	ETF	152.0	152.07	151.65	151.7	4802116.0
2007-12-10 14:00:00	SPY	ETF	151.7	151.81	151.58	151.79	5227341.0
2007-12-10 14:30:00	SPY	ETF	151.79	151.97	151.48	151.65	8685341.0
2007-12-10 15:00:00	SPY	ETF	151.65	151.94	151.57	151.78	7059284.0
2007-12-10 15:30:00	SPY	ETF	151.77	152.05	151.67	152.03	11557883.0
2007-12-10 16:00:00	SPY	ETF	152.05	152.14	151.8176	152.05	11714500.0
2007-12-10 16:30:00	SPY	ETF	152.04	152.22	152.04	152.21	2181300.0
2007-12-10 17:00:00	SPY	ETF	152.23	152.29	152.08	152.24	3993000.0
2007-12-10 17:30:00	SPY	ETF	152.24	152.33	152.24	152.27	51800.0
2007-12-10 18:00:00	SPY	ETF	152.27	152.27	152.17	152.22	76300.0
2007-12-10 18:30:00	SPY	ETF	152.18	152.26	152.18	152.2	8300.0
2007-12-10 19:00:00	SPY	ETF	152.17	152.25	152.14	152.25	8300.0
2007-12-10 19:30:00	SPY	ETF	152.15	152.18	152.09	152.16	12400.0
2007-12-10 04:00:00	QQQ	ETF	52.31	52.31	52.31	52.31	370.0
2007-12-10 04:30:00	QQQ	ETF	52.41	52.43	52.41	52.43	2900.0
2007-12-10 06:30:00	QQQ	ETF	52.48	52.48	52.48	52.48	1000.0
2007-12-10 07:00:00	QQQ	ETF	52.44	52.44	52.4	52.43	129500.0
2007-12-10 07:30:00	QQQ	ETF	52.43	52.58	52.43	52.58	120012.0
2007-12-10 08:00:00	QQQ	ETF	52.57	52.6	52.51	52.54	1079886.0
2007-12-10 08:30:00	QQQ	ETF	52.55	52.58	52.49	52.5	182627.0
2007-12-10 09:00:00	QQQ	ETF	52.5	52.55	52.37	52.43	1994223.0
2007-12-10 09:30:00	QQQ	ETF	52.44	52.52	52.32	52.38	9909561.0
2007-12-10 10:00:00	QQQ	ETF	52.38	52.55	52.38	52.4301	9278970.0
2007-12-10 10:30:00	QQQ	ETF	52.44	52.68	52.43	52.67	11794557.0
2007-12-10 11:00:00	QQQ	ETF	52.67	52.69	52.52	52.56	5689488.0
2007-12-10 11:30:00	QQQ	ETF	52.56	52.62	52.55	52.5724	2253668.0
2007-12-10 12:00:00	QQQ	ETF	52.57	52.62	52.52	52.59	1989685.0
2007-12-10 12:30:00	QQQ	ETF	52.585	52.61	52.54	52.5401	1555129.0
2007-12-10 13:00:00	QQQ	ETF	52.54	52.67	52.54	52.57	2269279.0
2007-12-10 13:30:00	QQQ	ETF	52.58	52.63	52.43	52.44	4816661.0
2007-12-10 14:00:00	QQQ	ETF	52.44	52.65	52.39	52.51	5009842.0
2007-12-10 14:30:00	QQQ	ETF	52.5	52.65	52.4	52.46	2991531.0

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

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