PREVIEW / etf_30min / 2009-12-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-17.parquet
  size:    238 KB
  rows:    8,035

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
2009-12-17 04:30:00	SPY	ETF	111.17	111.17	111.17	111.17	200.0
2009-12-17 05:00:00	SPY	ETF	111.11	111.11	111.04	111.06	11000.0
2009-12-17 05:30:00	SPY	ETF	111.01	111.04	110.89	110.89	14200.0
2009-12-17 06:00:00	SPY	ETF	110.9	110.9	110.66	110.7	6600.0
2009-12-17 06:30:00	SPY	ETF	110.76	110.91	110.76	110.88	6800.0
2009-12-17 07:00:00	SPY	ETF	110.9	110.96	110.89	110.93	33170.0
2009-12-17 07:30:00	SPY	ETF	110.93	110.95	110.54	110.62	506341.0
2009-12-17 08:00:00	SPY	ETF	110.62	110.95	110.58	110.72	843744.0
2009-12-17 08:30:00	SPY	ETF	110.71	110.75	110.52	110.67	1385401.0
2009-12-17 09:00:00	SPY	ETF	110.66	110.73	110.59	110.72	665717.0
2009-12-17 09:30:00	SPY	ETF	110.72	110.93	110.35	110.37	23353373.0
2009-12-17 10:00:00	SPY	ETF	110.36	110.71	110.3	110.535	14940714.0
2009-12-17 10:30:00	SPY	ETF	110.54	110.8	110.44	110.77	10704909.0
2009-12-17 11:00:00	SPY	ETF	110.76	110.84	110.62	110.635	11054218.0
2009-12-17 11:30:00	SPY	ETF	110.6501	110.76	110.33	110.43	10137743.0
2009-12-17 12:00:00	SPY	ETF	110.43	110.47	110.3	110.37	11239977.0
2009-12-17 12:30:00	SPY	ETF	110.37	110.49	110.08	110.22	9946431.0
2009-12-17 13:00:00	SPY	ETF	110.23	110.38	110.22	110.37	6620823.0
2009-12-17 13:30:00	SPY	ETF	110.36	110.41	110.19	110.37	6445619.0
2009-12-17 14:00:00	SPY	ETF	110.37	110.84	110.349	110.42	9335706.0
2009-12-17 14:30:00	SPY	ETF	110.42	110.62	110.37	110.4383	7314500.0
2009-12-17 15:00:00	SPY	ETF	110.43	110.52	110.27	110.28	12380532.0
2009-12-17 15:30:00	SPY	ETF	110.28	110.51	110.15	110.16	23278139.0
2009-12-17 16:00:00	SPY	ETF	110.15	110.84	110.08	110.42	20708734.0
2009-12-17 16:30:00	SPY	ETF	110.41	110.41	110.35	110.38	463739.0
2009-12-17 17:00:00	SPY	ETF	110.39	110.47	110.37	110.44	97194.0
2009-12-17 17:30:00	SPY	ETF	110.43	110.81	110.43	110.45	57100.0
2009-12-17 18:00:00	SPY	ETF	110.44	110.44	110.38	110.41	76536.0
2009-12-17 18:30:00	SPY	ETF	110.44	110.45	110.42	110.42	8754.0
2009-12-17 19:00:00	SPY	ETF	110.41	110.41	110.35	110.4	4270.0
2009-12-17 19:30:00	SPY	ETF	110.39	110.44	110.39	110.43	22900.0
2009-12-17 05:00:00	QQQ	ETF	44.18	44.18	44.18	44.18	100.0
2009-12-17 05:30:00	QQQ	ETF	44.14	44.14	44.1	44.1	4870.0
2009-12-17 06:00:00	QQQ	ETF	44.05	44.05	43.98	44.01	32905.0
2009-12-17 06:30:00	QQQ	ETF	44.03	44.09	44.03	44.09	2500.0
2009-12-17 07:00:00	QQQ	ETF	44.1	44.16	44.1	44.15	17415.0
2009-12-17 07:30:00	QQQ	ETF	44.14	44.16	44.02	44.04	67484.0
2009-12-17 08:00:00	QQQ	ETF	44.05	44.16	44.03	44.11	742495.0
2009-12-17 08:30:00	QQQ	ETF	44.08	44.13	44.03	44.1	361972.0
2009-12-17 09:00:00	QQQ	ETF	44.1	44.17	44.07	44.17	637940.0
2009-12-17 09:30:00	QQQ	ETF	44.17	44.21	43.8995	43.91	12366393.0
2009-12-17 10:00:00	QQQ	ETF	43.9	44.01	43.78	43.88	10585759.0
2009-12-17 10:30:00	QQQ	ETF	43.89	44.02	43.815	44.01	4875530.0
2009-12-17 11:00:00	QQQ	ETF	44.01	44.08	43.99	43.99	4525029.0
2009-12-17 11:30:00	QQQ	ETF	43.9901	44.01	43.88	43.91	5417396.0
2009-12-17 12:00:00	QQQ	ETF	43.92	43.93	43.84	43.87	2516235.0
2009-12-17 12:30:00	QQQ	ETF	43.87	43.9032	43.76	43.8299	3707362.0
2009-12-17 13:00:00	QQQ	ETF	43.82	43.88	43.81	43.86	3553870.0
2009-12-17 13:30:00	QQQ	ETF	43.862	43.9	43.84	43.89	1791788.0
2009-12-17 14:00:00	QQQ	ETF	43.9	43.96	43.87	43.94	2910019.0

> showing 50 of 8,035 rows — these rows as CSV

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