PREVIEW / etf_30min / 2010-06-03

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-03.parquet
  size:    252 KB
  rows:    8,422

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-06-03 04:00:00	SPY	ETF	110.87	110.93	110.84	110.84	7600.0
2010-06-03 04:30:00	SPY	ETF	110.84	110.95	110.83	110.9	3700.0
2010-06-03 05:00:00	SPY	ETF	110.83	110.83	110.7	110.8	3000.0
2010-06-03 05:30:00	SPY	ETF	110.8	110.85	110.8	110.83	10700.0
2010-06-03 06:00:00	SPY	ETF	110.83	110.83	110.58	110.59	15676.0
2010-06-03 06:30:00	SPY	ETF	110.62	110.7	110.45	110.45	12220.0
2010-06-03 07:00:00	SPY	ETF	110.47	110.67	110.41	110.45	431452.0
2010-06-03 07:30:00	SPY	ETF	110.45	110.67	110.45	110.59	1198391.0
2010-06-03 08:00:00	SPY	ETF	110.55	110.7	110.35	110.65	2084992.0
2010-06-03 08:30:00	SPY	ETF	110.67	110.8	110.53	110.7	2083805.0
2010-06-03 09:00:00	SPY	ETF	110.71	110.74	110.57	110.65	764428.0
2010-06-03 09:30:00	SPY	ETF	110.65	111.06	110.43	111.01	27817391.0
2010-06-03 10:00:00	SPY	ETF	111.04	111.06	110.3475	110.38	20497767.0
2010-06-03 10:30:00	SPY	ETF	110.37	110.75	110.16	110.61	16611972.0
2010-06-03 11:00:00	SPY	ETF	110.62	110.81	110.33	110.38	11474712.0
2010-06-03 11:30:00	SPY	ETF	110.38	110.63	110.32	110.46	11017281.0
2010-06-03 12:00:00	SPY	ETF	110.45	110.5	109.58	109.78	18652409.0
2010-06-03 12:30:00	SPY	ETF	109.7801	110.1	109.64	109.9	11327577.0
2010-06-03 13:00:00	SPY	ETF	109.91	110.07	109.74	109.86	7864610.0
2010-06-03 13:30:00	SPY	ETF	109.86	110.26	109.74	110.05	10591721.0
2010-06-03 14:00:00	SPY	ETF	110.05	110.49	109.93	110.26	15017704.0
2010-06-03 14:30:00	SPY	ETF	110.26	110.68	110.22	110.57	12652134.0
2010-06-03 15:00:00	SPY	ETF	110.57	110.84	110.24	110.8099	15469279.0
2010-06-03 15:30:00	SPY	ETF	110.8	110.87	110.31	110.71	25897707.0
2010-06-03 16:00:00	SPY	ETF	110.71	110.93	109.92	110.9	6665246.0
2010-06-03 16:30:00	SPY	ETF	110.9	110.94	110.65	110.72	2353966.0
2010-06-03 17:00:00	SPY	ETF	110.71	110.84	110.53	110.63	4724366.0
2010-06-03 17:30:00	SPY	ETF	110.65	110.66	110.59	110.65	17811.0
2010-06-03 18:00:00	SPY	ETF	110.65	110.7	110.58	110.65	70155.0
2010-06-03 18:30:00	SPY	ETF	110.64	110.68	110.59	110.64	33609.0
2010-06-03 19:00:00	SPY	ETF	110.65	110.73	110.63	110.66	29937.0
2010-06-03 19:30:00	SPY	ETF	110.69	110.77	110.66	110.69	35853.0
2010-06-03 04:00:00	QQQ	ETF	46.51	46.51	46.51	46.51	200.0
2010-06-03 04:30:00	QQQ	ETF	46.47	46.47	46.47	46.47	100.0
2010-06-03 05:00:00	QQQ	ETF	46.46	46.46	46.46	46.46	400.0
2010-06-03 05:30:00	QQQ	ETF	46.49	46.49	46.49	46.49	6000.0
2010-06-03 06:00:00	QQQ	ETF	46.48	46.48	46.4	46.4	19100.0
2010-06-03 06:30:00	QQQ	ETF	46.41	46.45	46.39	46.39	25100.0
2010-06-03 07:00:00	QQQ	ETF	46.32	46.39	46.31	46.31	3952.0
2010-06-03 07:30:00	QQQ	ETF	46.32	46.36	46.32	46.32	14263.0
2010-06-03 08:00:00	QQQ	ETF	46.31	46.38	46.28	46.36	838949.0
2010-06-03 08:30:00	QQQ	ETF	46.35	46.41	46.32	46.34	1838116.0
2010-06-03 09:00:00	QQQ	ETF	46.34	46.39	46.32	46.37	907288.0
2010-06-03 09:30:00	QQQ	ETF	46.37	46.66	46.33	46.6401	12542794.0
2010-06-03 10:00:00	QQQ	ETF	46.64	46.645	46.32	46.33	8995224.0
2010-06-03 10:30:00	QQQ	ETF	46.33	46.54	46.26	46.5	5384943.0
2010-06-03 11:00:00	QQQ	ETF	46.5	46.62	46.42	46.44	4445952.0
2010-06-03 11:30:00	QQQ	ETF	46.45	46.58	46.41	46.53	4290212.0
2010-06-03 12:00:00	QQQ	ETF	46.52	46.54	46.08	46.19	7146093.0
2010-06-03 12:30:00	QQQ	ETF	46.19	46.32	46.14	46.29	3906373.0

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

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