PREVIEW / etf_30min / 2010-10-21

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-21.parquet
  size:    269 KB
  rows:    8,829

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-10-21 04:00:00	SPY	ETF	118.22	118.3	118.22	118.29	1937.0
2010-10-21 04:30:00	SPY	ETF	118.33	118.33	118.25	118.25	6600.0
2010-10-21 05:00:00	SPY	ETF	118.3	118.3	118.3	118.3	1100.0
2010-10-21 05:30:00	SPY	ETF	118.32	118.35	118.32	118.35	2400.0
2010-10-21 06:30:00	SPY	ETF	118.4	118.5	118.4	118.49	4880.0
2010-10-21 07:00:00	SPY	ETF	118.51	118.59	118.22	118.55	187722.0
2010-10-21 07:30:00	SPY	ETF	118.58	118.7	118.49	118.49	292003.0
2010-10-21 08:00:00	SPY	ETF	118.5	118.54	118.41	118.47	328446.0
2010-10-21 08:30:00	SPY	ETF	118.48	118.65	118.3	118.44	1477327.0
2010-10-21 09:00:00	SPY	ETF	118.41	118.45	118.23	118.41	1330712.0
2010-10-21 09:30:00	SPY	ETF	118.4	118.64	118.2	118.62	18631361.0
2010-10-21 10:00:00	SPY	ETF	118.61	119.02	118.33	118.8211	22647827.0
2010-10-21 10:30:00	SPY	ETF	118.83	119.09	118.822	119.0105	12295034.0
2010-10-21 11:00:00	SPY	ETF	119.02	119.07	118.41	118.56	15955663.0
2010-10-21 11:30:00	SPY	ETF	118.56	118.64	118.07	118.43	20387386.0
2010-10-21 12:00:00	SPY	ETF	118.4379	118.48	118.25	118.42	7928676.0
2010-10-21 12:30:00	SPY	ETF	118.42	118.43	117.93	118.08	14266418.0
2010-10-21 13:00:00	SPY	ETF	118.08	118.33	118.08	118.22	10823162.0
2010-10-21 13:30:00	SPY	ETF	118.215	118.22	117.26	117.35	20917538.0
2010-10-21 14:00:00	SPY	ETF	117.35	117.61	117.21	117.55	18585455.0
2010-10-21 14:30:00	SPY	ETF	117.56	117.87	117.515	117.8	11013772.0
2010-10-21 15:00:00	SPY	ETF	117.8	118.2	117.69	118.095	16207701.0
2010-10-21 15:30:00	SPY	ETF	118.1	118.2	117.88	118.11	20509047.0
2010-10-21 16:00:00	SPY	ETF	118.11	118.965	117.3086	118.06	5577976.0
2010-10-21 16:30:00	SPY	ETF	118.04	118.04	117.91	117.96	683305.0
2010-10-21 17:00:00	SPY	ETF	117.97	118.53	117.95	118.03	163374.0
2010-10-21 17:30:00	SPY	ETF	118.02	118.08	117.9321	117.98	123488.0
2010-10-21 18:00:00	SPY	ETF	118.0	118.12	117.98	118.07	58111.0
2010-10-21 18:30:00	SPY	ETF	118.06	118.06	117.98	118.0	12569.0
2010-10-21 19:00:00	SPY	ETF	118.01	118.02	117.99	118.01	7275.0
2010-10-21 19:30:00	SPY	ETF	118.03	118.05	118.0	118.05	31440.0
2010-10-21 04:30:00	QQQ	ETF	51.41	51.41	51.41	51.41	100.0
2010-10-21 05:00:00	QQQ	ETF	51.44	51.44	51.44	51.44	200.0
2010-10-21 05:30:00	QQQ	ETF	51.47	51.47	51.47	51.47	100.0
2010-10-21 06:30:00	QQQ	ETF	51.49	51.55	51.49	51.54	5700.0
2010-10-21 07:00:00	QQQ	ETF	51.56	51.61	51.53	51.6	92203.0
2010-10-21 07:30:00	QQQ	ETF	51.6	51.66	51.59	51.6	50510.0
2010-10-21 08:00:00	QQQ	ETF	51.6	51.61	51.54	51.55	182851.0
2010-10-21 08:30:00	QQQ	ETF	51.56	51.61	51.45	51.52	453619.0
2010-10-21 09:00:00	QQQ	ETF	51.52	51.53	51.44	51.52	410717.0
2010-10-21 09:30:00	QQQ	ETF	51.51	51.65	51.38	51.61	7922647.0
2010-10-21 10:00:00	QQQ	ETF	51.6	51.69	51.43	51.58	8510027.0
2010-10-21 10:30:00	QQQ	ETF	51.58	51.7	51.58	51.68	3656910.0
2010-10-21 11:00:00	QQQ	ETF	51.6701	51.7101	51.44	51.509	4287628.0
2010-10-21 11:30:00	QQQ	ETF	51.51	51.54	51.25	51.42	9054553.0
2010-10-21 12:00:00	QQQ	ETF	51.42	51.43	51.345	51.415	3059117.0
2010-10-21 12:30:00	QQQ	ETF	51.42	51.425	51.2	51.2762	4206722.0
2010-10-21 13:00:00	QQQ	ETF	51.275	51.4	51.2742	51.34	2299921.0
2010-10-21 13:30:00	QQQ	ETF	51.33	51.3401	50.82	50.89	10331102.0
2010-10-21 14:00:00	QQQ	ETF	50.87	51.0	50.79	50.96	6432634.0

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

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