PREVIEW / etf_30min / 2010-09-03

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-03.parquet
  size:    257 KB
  rows:    8,579

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-09-03 04:30:00	SPY	ETF	109.34	109.42	109.34	109.42	800.0
2010-09-03 05:00:00	SPY	ETF	109.47	109.55	109.47	109.55	24900.0
2010-09-03 05:30:00	SPY	ETF	109.6	109.63	109.6	109.63	220.0
2010-09-03 06:00:00	SPY	ETF	109.63	109.74	109.63	109.74	500.0
2010-09-03 06:30:00	SPY	ETF	109.61	109.61	109.6	109.6	200.0
2010-09-03 07:00:00	SPY	ETF	109.6	109.61	109.45	109.47	185719.0
2010-09-03 07:30:00	SPY	ETF	109.5	109.53	109.33	109.35	351800.0
2010-09-03 08:00:00	SPY	ETF	109.36	109.83	109.32	109.65	1652070.0
2010-09-03 08:30:00	SPY	ETF	109.79	110.93	109.76	110.71	12668826.0
2010-09-03 09:00:00	SPY	ETF	110.71	110.79	110.51	110.55	3391649.0
2010-09-03 09:30:00	SPY	ETF	110.54	110.99	110.53	110.91	26319051.0
2010-09-03 10:00:00	SPY	ETF	110.9	110.91	110.13	110.2	28766163.0
2010-09-03 10:30:00	SPY	ETF	110.2	110.32	109.95	110.15	16519296.0
2010-09-03 11:00:00	SPY	ETF	110.15	110.39	110.04	110.25	8605456.0
2010-09-03 11:30:00	SPY	ETF	110.25	110.43	110.14	110.29	9016037.0
2010-09-03 12:00:00	SPY	ETF	110.285	110.4	110.25	110.34	4107565.0
2010-09-03 12:30:00	SPY	ETF	110.34	110.67	110.33	110.595	8080541.0
2010-09-03 13:00:00	SPY	ETF	110.59	110.71	110.55	110.58	7324172.0
2010-09-03 13:30:00	SPY	ETF	110.58	110.84	110.55	110.8	6696567.0
2010-09-03 14:00:00	SPY	ETF	110.795	110.84	110.67	110.77	8003502.0
2010-09-03 14:30:00	SPY	ETF	110.77	110.85	110.5	110.52	9698948.0
2010-09-03 15:00:00	SPY	ETF	110.51	110.73	110.47	110.71	7877037.0
2010-09-03 15:30:00	SPY	ETF	110.71	110.94	110.25	110.91	29356813.0
2010-09-03 16:00:00	SPY	ETF	110.91	110.99	109.4809	110.9	10812146.0
2010-09-03 16:30:00	SPY	ETF	110.89	111.02	110.87	111.0	12199471.0
2010-09-03 17:00:00	SPY	ETF	110.98	111.03	110.91	110.92	121851.0
2010-09-03 17:30:00	SPY	ETF	110.92	110.95	110.92	110.92	11275.0
2010-09-03 18:00:00	SPY	ETF	110.92	110.98	110.92	110.92	25784.0
2010-09-03 18:30:00	SPY	ETF	110.92	110.96	110.92	110.96	12802.0
2010-09-03 19:00:00	SPY	ETF	110.97	110.97	110.93	110.96	3150.0
2010-09-03 19:30:00	SPY	ETF	110.96	110.98	110.92	110.98	29772.0
2010-09-03 06:00:00	QQQ	ETF	45.35	45.38	45.35	45.38	700.0
2010-09-03 06:30:00	QQQ	ETF	45.32	45.32	45.3	45.3	2000.0
2010-09-03 07:00:00	QQQ	ETF	45.3	45.3	45.26	45.26	9876.0
2010-09-03 07:30:00	QQQ	ETF	45.27	45.27	45.18	45.19	382307.0
2010-09-03 08:00:00	QQQ	ETF	45.2	45.44	45.18	45.34	1573001.0
2010-09-03 08:30:00	QQQ	ETF	45.4	45.88	45.4	45.79	2835354.0
2010-09-03 09:00:00	QQQ	ETF	45.79	45.81	45.69	45.74	725494.0
2010-09-03 09:30:00	QQQ	ETF	45.73	46.02	45.73	46.0	8030807.0
2010-09-03 10:00:00	QQQ	ETF	45.99	45.99	45.61	45.65	9418452.0
2010-09-03 10:30:00	QQQ	ETF	45.66	45.71	45.55	45.6419	4130994.0
2010-09-03 11:00:00	QQQ	ETF	45.645	45.74	45.58	45.7	2800778.0
2010-09-03 11:30:00	QQQ	ETF	45.7	45.78	45.65	45.72	1759114.0
2010-09-03 12:00:00	QQQ	ETF	45.72	45.76	45.7	45.73	1438913.0
2010-09-03 12:30:00	QQQ	ETF	45.735	45.91	45.73	45.8691	6064543.0
2010-09-03 13:00:00	QQQ	ETF	45.86	45.93	45.86	45.86	1991058.0
2010-09-03 13:30:00	QQQ	ETF	45.86	45.985	45.85	45.98	2934756.0
2010-09-03 14:00:00	QQQ	ETF	45.98	45.98	45.8901	45.945	2230060.0
2010-09-03 14:30:00	QQQ	ETF	45.9496	46.01	45.84	45.85	3367394.0
2010-09-03 15:00:00	QQQ	ETF	45.845	45.93	45.825	45.92	1545980.0

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

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