PREVIEW / etf_30min / 2009-12-11

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-11.parquet
  size:    228 KB
  rows:    7,698

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-11 04:00:00	SPY	ETF	111.12	111.33	111.12	111.33	600.0
2009-12-11 04:30:00	SPY	ETF	111.41	111.45	111.34	111.42	1000.0
2009-12-11 05:00:00	SPY	ETF	111.36	111.4	111.36	111.4	5300.0
2009-12-11 05:30:00	SPY	ETF	111.4	111.4	111.32	111.32	200.0
2009-12-11 06:00:00	SPY	ETF	111.34	111.34	111.34	111.34	150.0
2009-12-11 06:30:00	SPY	ETF	111.3	111.3	111.22	111.22	2700.0
2009-12-11 07:00:00	SPY	ETF	111.17	111.35	111.14	111.35	51609.0
2009-12-11 07:30:00	SPY	ETF	111.35	111.35	111.24	111.33	143454.0
2009-12-11 08:00:00	SPY	ETF	111.3	111.34	110.64	111.18	951818.0
2009-12-11 08:30:00	SPY	ETF	111.25	111.79	111.17	111.22	1924884.0
2009-12-11 09:00:00	SPY	ETF	111.21	111.26	110.97	111.12	1331093.0
2009-12-11 09:30:00	SPY	ETF	111.11	111.36	110.83	111.25	20171238.0
2009-12-11 10:00:00	SPY	ETF	111.25	111.31	110.95	111.15	11706587.0
2009-12-11 10:30:00	SPY	ETF	111.15	111.35	111.09	111.25	7843681.0
2009-12-11 11:00:00	SPY	ETF	111.2501	111.26	110.68	110.79	12289729.0
2009-12-11 11:30:00	SPY	ETF	110.78	110.87	110.61	110.771	7995118.0
2009-12-11 12:00:00	SPY	ETF	110.78	110.98	110.77	110.87	4606424.0
2009-12-11 12:30:00	SPY	ETF	110.87	111.1	110.84	111.09	5840392.0
2009-12-11 13:00:00	SPY	ETF	111.09	111.12	110.92	111.019	5129592.0
2009-12-11 13:30:00	SPY	ETF	111.02	111.12	111.0	111.04	3082784.0
2009-12-11 14:00:00	SPY	ETF	111.04	111.24	111.0	111.12	5362530.0
2009-12-11 14:30:00	SPY	ETF	111.13	111.19	110.98	111.03	4655426.0
2009-12-11 15:00:00	SPY	ETF	111.035	111.23	111.0	111.2201	4727323.0
2009-12-11 15:30:00	SPY	ETF	111.22	111.3	110.94	111.2	14546506.0
2009-12-11 16:00:00	SPY	ETF	111.2	111.34	110.7217	111.32	11968855.0
2009-12-11 16:30:00	SPY	ETF	111.35	111.36	111.24	111.35	245484.0
2009-12-11 17:00:00	SPY	ETF	111.35	111.4	111.34	111.39	74120.0
2009-12-11 17:30:00	SPY	ETF	111.4	111.4	111.32	111.33	21988.0
2009-12-11 18:00:00	SPY	ETF	111.32	111.32	111.26	111.27	16776.0
2009-12-11 18:30:00	SPY	ETF	111.27	111.33	111.26	111.3	17730.0
2009-12-11 19:00:00	SPY	ETF	111.3	111.37	111.3	111.3	11590.0
2009-12-11 19:30:00	SPY	ETF	111.32	111.38	111.31	111.38	9770.0
2009-12-11 04:30:00	QQQ	ETF	44.59	44.59	44.59	44.59	200.0
2009-12-11 06:00:00	QQQ	ETF	44.57	44.58	44.57	44.58	266.0
2009-12-11 06:30:00	QQQ	ETF	44.53	44.53	44.5	44.5	300.0
2009-12-11 07:00:00	QQQ	ETF	44.53	44.55	44.49	44.55	4053.0
2009-12-11 07:30:00	QQQ	ETF	44.55	44.57	44.53	44.55	107107.0
2009-12-11 08:00:00	QQQ	ETF	44.55	44.58	44.51	44.58	393585.0
2009-12-11 08:30:00	QQQ	ETF	44.58	44.63	44.51	44.52	1685106.0
2009-12-11 09:00:00	QQQ	ETF	44.51	44.54	44.43	44.52	846812.0
2009-12-11 09:30:00	QQQ	ETF	44.52	44.59	44.32	44.49	10065476.0
2009-12-11 10:00:00	QQQ	ETF	44.5	44.52	44.29	44.3601	5581892.0
2009-12-11 10:30:00	QQQ	ETF	44.37	44.44	44.34	44.38	3276124.0
2009-12-11 11:00:00	QQQ	ETF	44.37	44.375	44.03	44.07	9279296.0
2009-12-11 11:30:00	QQQ	ETF	44.07	44.09	43.95	44.0224	5537135.0
2009-12-11 12:00:00	QQQ	ETF	44.0201	44.1	44.02	44.065	2990579.0
2009-12-11 12:30:00	QQQ	ETF	44.069	44.2016	44.05	44.18	4823195.0
2009-12-11 13:00:00	QQQ	ETF	44.18	44.195	44.11	44.13	1055745.0
2009-12-11 13:30:00	QQQ	ETF	44.13	44.17	44.11	44.13	1064323.0
2009-12-11 14:00:00	QQQ	ETF	44.14	44.2	44.12	44.16	2607628.0

> showing 50 of 7,698 rows — these rows as CSV

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