PREVIEW / etf_30min / 2010-07-29

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-29.parquet
  size:    251 KB
  rows:    8,318

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-07-29 04:00:00	SPY	ETF	110.92	111.38	110.92	111.35	1000.0
2010-07-29 04:30:00	SPY	ETF	111.43	111.43	111.36	111.36	229.0
2010-07-29 05:00:00	SPY	ETF	111.38	111.38	111.36	111.36	1600.0
2010-07-29 05:30:00	SPY	ETF	111.26	111.31	111.26	111.29	14250.0
2010-07-29 06:00:00	SPY	ETF	111.34	111.35	111.31	111.35	5400.0
2010-07-29 06:30:00	SPY	ETF	111.34	111.37	111.26	111.26	54300.0
2010-07-29 07:00:00	SPY	ETF	111.26	111.4	111.26	111.4	34850.0
2010-07-29 07:30:00	SPY	ETF	111.38	111.46	111.23	111.27	282325.0
2010-07-29 08:00:00	SPY	ETF	111.24	111.35	111.11	111.16	869447.0
2010-07-29 08:30:00	SPY	ETF	111.2	111.58	111.18	111.56	2337968.0
2010-07-29 09:00:00	SPY	ETF	111.57	111.59	111.42	111.52	711221.0
2010-07-29 09:30:00	SPY	ETF	111.52	111.82	111.31	111.41	18859525.0
2010-07-29 10:00:00	SPY	ETF	111.42	111.42	110.96	111.07	13753880.0
2010-07-29 10:30:00	SPY	ETF	111.07	111.19	110.87	111.08	10565428.0
2010-07-29 11:00:00	SPY	ETF	111.08	111.09	110.07	110.1	16680320.0
2010-07-29 11:30:00	SPY	ETF	110.1	110.1	109.69	109.79	17368513.0
2010-07-29 12:00:00	SPY	ETF	109.79	109.92	109.41	109.87	13731798.0
2010-07-29 12:30:00	SPY	ETF	109.8656	109.97	109.53	109.94	11142334.0
2010-07-29 13:00:00	SPY	ETF	109.94	110.2	109.88	110.199	9010897.0
2010-07-29 13:30:00	SPY	ETF	110.19	110.45	110.17	110.251	8678239.0
2010-07-29 14:00:00	SPY	ETF	110.251	110.52	110.01	110.5	9723959.0
2010-07-29 14:30:00	SPY	ETF	110.5	110.87	110.35	110.72	17994228.0
2010-07-29 15:00:00	SPY	ETF	110.73	110.98	110.54	110.8199	18585863.0
2010-07-29 15:30:00	SPY	ETF	110.811	110.86	110.27	110.28	29829792.0
2010-07-29 16:00:00	SPY	ETF	110.29	111.285	109.805	110.2	12961245.0
2010-07-29 16:30:00	SPY	ETF	110.18	110.3397	110.17	110.21	567649.0
2010-07-29 17:00:00	SPY	ETF	110.2	110.32	110.15	110.17	301985.0
2010-07-29 17:30:00	SPY	ETF	110.16	110.21	110.15	110.15	61690.0
2010-07-29 18:00:00	SPY	ETF	110.19	110.29	110.17	110.2	77435.0
2010-07-29 18:30:00	SPY	ETF	110.2	110.21	110.18	110.18	7055.0
2010-07-29 19:00:00	SPY	ETF	110.19	110.19	110.16	110.19	20499.0
2010-07-29 19:30:00	SPY	ETF	110.19	110.21	110.15	110.2	31431.0
2010-07-29 06:00:00	QQQ	ETF	46.16	46.17	46.16	46.17	2900.0
2010-07-29 06:30:00	QQQ	ETF	46.14	46.14	46.14	46.14	5000.0
2010-07-29 07:00:00	QQQ	ETF	46.15	46.2	46.15	46.2	2517.0
2010-07-29 07:30:00	QQQ	ETF	46.22	46.24	46.14	46.14	44900.0
2010-07-29 08:00:00	QQQ	ETF	46.16	46.2	46.12	46.13	118382.0
2010-07-29 08:30:00	QQQ	ETF	46.14	46.3	46.13	46.29	847978.0
2010-07-29 09:00:00	QQQ	ETF	46.29	46.3	46.24	46.3	335629.0
2010-07-29 09:30:00	QQQ	ETF	46.31	46.41	46.13	46.19	7296508.0
2010-07-29 10:00:00	QQQ	ETF	46.19	46.2	46.0	46.06	5254128.0
2010-07-29 10:30:00	QQQ	ETF	46.06	46.08	45.9	46.0	4627902.0
2010-07-29 11:00:00	QQQ	ETF	45.99	45.99	45.56	45.58	6674517.0
2010-07-29 11:30:00	QQQ	ETF	45.58	45.58	45.38	45.45	6855715.0
2010-07-29 12:00:00	QQQ	ETF	45.46	45.46	45.25	45.41	6753107.0
2010-07-29 12:30:00	QQQ	ETF	45.41	45.48	45.27	45.47	5097861.0
2010-07-29 13:00:00	QQQ	ETF	45.47	45.61	45.43	45.6001	2853241.0
2010-07-29 13:30:00	QQQ	ETF	45.61	45.8041	45.59	45.71	6126246.0
2010-07-29 14:00:00	QQQ	ETF	45.71	45.87	45.61	45.84	4289829.0
2010-07-29 14:30:00	QQQ	ETF	45.85	46.1	45.83	46.03	6919998.0

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

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