PREVIEW / etf_30min / 2010-03-03

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-03.parquet
  size:    246 KB
  rows:    8,227

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-03-03 04:00:00	SPY	ETF	112.01	112.01	112.01	112.01	1000.0
2010-03-03 05:30:00	SPY	ETF	112.24	112.24	112.24	112.24	500.0
2010-03-03 06:00:00	SPY	ETF	112.25	112.3	112.17	112.3	7216.0
2010-03-03 06:30:00	SPY	ETF	112.3	112.39	112.25	112.25	52884.0
2010-03-03 07:00:00	SPY	ETF	112.26	112.27	112.09	112.14	646790.0
2010-03-03 07:30:00	SPY	ETF	112.17	112.22	112.02	112.11	356151.0
2010-03-03 08:00:00	SPY	ETF	112.12	112.32	112.03	112.32	2433773.0
2010-03-03 08:30:00	SPY	ETF	112.32	112.53	112.27	112.42	906074.0
2010-03-03 09:00:00	SPY	ETF	112.43	112.52	112.39	112.49	709858.0
2010-03-03 09:30:00	SPY	ETF	112.49	112.74	112.3	112.63	14021946.0
2010-03-03 10:00:00	SPY	ETF	112.64	112.8	112.5	112.6	14726560.0
2010-03-03 10:30:00	SPY	ETF	112.6	112.92	112.4	112.85	12570477.0
2010-03-03 11:00:00	SPY	ETF	112.85	112.97	112.81	112.94	11520808.0
2010-03-03 11:30:00	SPY	ETF	112.94	112.96	112.79	112.84	5854877.0
2010-03-03 12:00:00	SPY	ETF	112.84	112.84	112.7	112.76	4704132.0
2010-03-03 12:30:00	SPY	ETF	112.77	112.79	112.53	112.585	6509197.0
2010-03-03 13:00:00	SPY	ETF	112.59	112.74	112.57	112.58	4731138.0
2010-03-03 13:30:00	SPY	ETF	112.58	112.7	112.53	112.68	3880500.0
2010-03-03 14:00:00	SPY	ETF	112.68	112.73	112.29	112.38	10858204.0
2010-03-03 14:30:00	SPY	ETF	112.38	112.45	112.02	112.19	16677676.0
2010-03-03 15:00:00	SPY	ETF	112.19	112.39	112.15	112.28	11158204.0
2010-03-03 15:30:00	SPY	ETF	112.28	112.47	112.2	112.28	16843945.0
2010-03-03 16:00:00	SPY	ETF	112.29	112.7	112.1307	112.32	7642838.0
2010-03-03 16:30:00	SPY	ETF	112.32	112.33	112.27	112.3	1360357.0
2010-03-03 17:00:00	SPY	ETF	112.29	112.31	112.24	112.28	40450.0
2010-03-03 17:30:00	SPY	ETF	112.28	112.3	112.28	112.3	30063.0
2010-03-03 18:00:00	SPY	ETF	112.3	112.4499	112.2301	112.26	122321.0
2010-03-03 18:30:00	SPY	ETF	112.24	112.29	112.22	112.22	20700.0
2010-03-03 19:00:00	SPY	ETF	112.23	112.27	112.22	112.27	15750.0
2010-03-03 19:30:00	SPY	ETF	112.25	112.29	112.21	112.23	73706.0
2010-03-03 05:30:00	QQQ	ETF	45.59	45.59	45.59	45.59	400.0
2010-03-03 06:00:00	QQQ	ETF	45.61	45.61	45.58	45.59	700.0
2010-03-03 06:30:00	QQQ	ETF	45.64	45.65	45.64	45.65	300.0
2010-03-03 07:00:00	QQQ	ETF	45.59	45.6	45.52	45.54	375936.0
2010-03-03 07:30:00	QQQ	ETF	45.53	45.55	45.48	45.51	169287.0
2010-03-03 08:00:00	QQQ	ETF	45.53	45.6	45.51	45.6	981023.0
2010-03-03 08:30:00	QQQ	ETF	45.6	45.68	45.58	45.65	257709.0
2010-03-03 09:00:00	QQQ	ETF	45.64	45.67	45.62	45.66	472760.0
2010-03-03 09:30:00	QQQ	ETF	45.66	45.76	45.57	45.705	5641713.0
2010-03-03 10:00:00	QQQ	ETF	45.71	45.78	45.62	45.699	6989740.0
2010-03-03 10:30:00	QQQ	ETF	45.69	45.81	45.66	45.775	5270932.0
2010-03-03 11:00:00	QQQ	ETF	45.78	45.82	45.745	45.7999	4311351.0
2010-03-03 11:30:00	QQQ	ETF	45.8	45.8	45.73	45.78	2338540.0
2010-03-03 12:00:00	QQQ	ETF	45.77	45.775	45.7	45.7299	2065543.0
2010-03-03 12:30:00	QQQ	ETF	45.73	45.73	45.6	45.64	3635656.0
2010-03-03 13:00:00	QQQ	ETF	45.64	45.71	45.62	45.63	3283294.0
2010-03-03 13:30:00	QQQ	ETF	45.63	45.69	45.63	45.69	2217187.0
2010-03-03 14:00:00	QQQ	ETF	45.69	45.71	45.55	45.6	3700363.0
2010-03-03 14:30:00	QQQ	ETF	45.6	45.625	45.43	45.48	6370517.0
2010-03-03 15:00:00	QQQ	ETF	45.48	45.6	45.43	45.53	6586508.0

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

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