PREVIEW / etf_30min / 2010-11-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-23.parquet
  size:    271 KB
  rows:    9,166

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
2010-11-23 04:00:00	SPY	ETF	119.42	119.64	119.38	119.5	7142.0
2010-11-23 04:30:00	SPY	ETF	119.53	119.59	119.38	119.45	14187.0
2010-11-23 05:00:00	SPY	ETF	119.26	119.26	119.25	119.25	7500.0
2010-11-23 05:30:00	SPY	ETF	119.38	119.46	119.25	119.46	900.0
2010-11-23 06:00:00	SPY	ETF	119.46	119.63	119.4	119.4	8680.0
2010-11-23 06:30:00	SPY	ETF	119.43	119.43	119.3	119.38	56400.0
2010-11-23 07:00:00	SPY	ETF	119.38	119.45	118.93	118.98	675629.0
2010-11-23 07:30:00	SPY	ETF	119.0	119.07	118.81	118.9	890136.0
2010-11-23 08:00:00	SPY	ETF	118.89	119.15	118.77	119.0	2274626.0
2010-11-23 08:30:00	SPY	ETF	119.05	119.13	118.85	118.96	3356284.0
2010-11-23 09:00:00	SPY	ETF	118.94	119.11	118.77	118.77	1959746.0
2010-11-23 09:30:00	SPY	ETF	118.77	119.015	118.27	118.3538	28651330.0
2010-11-23 10:00:00	SPY	ETF	118.35	118.67	118.21	118.53	17381721.0
2010-11-23 10:30:00	SPY	ETF	118.53	118.81	118.47	118.73	12862074.0
2010-11-23 11:00:00	SPY	ETF	118.73	118.73	118.13	118.14	14811566.0
2010-11-23 11:30:00	SPY	ETF	118.14	118.37	117.99	118.33	12201961.0
2010-11-23 12:00:00	SPY	ETF	118.3201	118.49	118.17	118.4065	7958251.0
2010-11-23 12:30:00	SPY	ETF	118.41	118.66	118.25	118.6	10062418.0
2010-11-23 13:00:00	SPY	ETF	118.63	118.65	118.43	118.65	9679994.0
2010-11-23 13:30:00	SPY	ETF	118.65	118.72	118.3	118.3799	9013167.0
2010-11-23 14:00:00	SPY	ETF	118.37	118.54	118.17	118.3	17446669.0
2010-11-23 14:30:00	SPY	ETF	118.3	118.45	118.17	118.36	8790684.0
2010-11-23 15:00:00	SPY	ETF	118.35	118.73	118.29	118.39	17735125.0
2010-11-23 15:30:00	SPY	ETF	118.3999	118.54	118.28	118.42	23298403.0
2010-11-23 16:00:00	SPY	ETF	118.43	120.1288	118.205	118.33	12351810.0
2010-11-23 16:30:00	SPY	ETF	118.33	118.36	118.12	118.18	1059909.0
2010-11-23 17:00:00	SPY	ETF	118.18	118.19	118.1	118.18	4226324.0
2010-11-23 17:30:00	SPY	ETF	118.19	118.25	118.17	118.18	41157.0
2010-11-23 18:00:00	SPY	ETF	118.23	118.49	118.23	118.44	139307.0
2010-11-23 18:30:00	SPY	ETF	118.47	118.66	118.4	118.64	122032.0
2010-11-23 19:00:00	SPY	ETF	118.62	118.7	118.58	118.66	87670.0
2010-11-23 19:30:00	SPY	ETF	118.68	118.77	118.66	118.72	110931.0
2010-11-23 05:30:00	QQQ	ETF	52.65	52.72	52.65	52.72	40100.0
2010-11-23 06:00:00	QQQ	ETF	52.75	52.75	52.75	52.75	700.0
2010-11-23 06:30:00	QQQ	ETF	52.67	52.7	52.67	52.7	610.0
2010-11-23 07:00:00	QQQ	ETF	52.7	52.71	52.45	52.48	176722.0
2010-11-23 07:30:00	QQQ	ETF	52.48	52.52	52.41	52.47	240524.0
2010-11-23 08:00:00	QQQ	ETF	52.46	52.55	52.43	52.54	160011.0
2010-11-23 08:30:00	QQQ	ETF	52.52	52.64	52.44	52.5	676976.0
2010-11-23 09:00:00	QQQ	ETF	52.5	52.59	52.39	52.4	188221.0
2010-11-23 09:30:00	QQQ	ETF	52.39	52.45	52.09	52.1	10259410.0
2010-11-23 10:00:00	QQQ	ETF	52.1	52.22	52.0115	52.17	5348938.0
2010-11-23 10:30:00	QQQ	ETF	52.165	52.28	52.12	52.2	3723173.0
2010-11-23 11:00:00	QQQ	ETF	52.2	52.2	51.86	51.87	4415127.0
2010-11-23 11:30:00	QQQ	ETF	51.87	51.91	51.77	51.9	4586070.0
2010-11-23 12:00:00	QQQ	ETF	51.9	51.97	51.81	51.93	3320668.0
2010-11-23 12:30:00	QQQ	ETF	51.9299	52.01	51.8499	52.0	2098608.0
2010-11-23 13:00:00	QQQ	ETF	52.0	52.02	51.93	52.02	2483983.0
2010-11-23 13:30:00	QQQ	ETF	52.02	52.05	51.9	51.92	1876682.0
2010-11-23 14:00:00	QQQ	ETF	51.93	52.01	51.86	51.93	3954322.0

> showing 50 of 9,166 rows — these rows as CSV

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