PREVIEW / etf_30min / 2010-11-03

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-03.parquet
  size:    266 KB
  rows:    8,810

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-11-03 04:00:00	SPY	ETF	119.76	119.76	119.6	119.7	11250.0
2010-11-03 04:30:00	SPY	ETF	119.61	119.64	119.59	119.64	7500.0
2010-11-03 05:00:00	SPY	ETF	119.7	119.75	119.7	119.75	200.0
2010-11-03 05:30:00	SPY	ETF	119.85	119.85	119.85	119.85	100.0
2010-11-03 06:00:00	SPY	ETF	119.84	119.89	119.84	119.85	1500.0
2010-11-03 06:30:00	SPY	ETF	119.83	119.87	119.83	119.87	21900.0
2010-11-03 07:00:00	SPY	ETF	119.8	119.84	119.76	119.81	144880.0
2010-11-03 07:30:00	SPY	ETF	119.82	119.91	119.78	119.91	146035.0
2010-11-03 08:00:00	SPY	ETF	119.89	119.95	119.81	119.89	887381.0
2010-11-03 08:30:00	SPY	ETF	119.91	119.94	119.79	119.88	358786.0
2010-11-03 09:00:00	SPY	ETF	119.88	119.89	119.63	119.68	896944.0
2010-11-03 09:30:00	SPY	ETF	119.675	119.76	119.5	119.5701	13553924.0
2010-11-03 10:00:00	SPY	ETF	119.58	119.74	119.47	119.62	9745478.0
2010-11-03 10:30:00	SPY	ETF	119.62	119.73	119.38	119.4101	11037838.0
2010-11-03 11:00:00	SPY	ETF	119.42	119.5	119.07	119.18	11983476.0
2010-11-03 11:30:00	SPY	ETF	119.18	119.6774	119.13	119.21	7067003.0
2010-11-03 12:00:00	SPY	ETF	119.2095	119.21	118.94	119.095	7536833.0
2010-11-03 12:30:00	SPY	ETF	119.1	119.25	119.04	119.135	5516767.0
2010-11-03 13:00:00	SPY	ETF	119.14	119.33	119.11	119.13	9256074.0
2010-11-03 13:30:00	SPY	ETF	119.12	119.23	119.06	119.18	4421225.0
2010-11-03 14:00:00	SPY	ETF	119.19	119.86	118.65	118.8	45561805.0
2010-11-03 14:30:00	SPY	ETF	118.79	119.79	118.45	119.65	35284315.0
2010-11-03 15:00:00	SPY	ETF	119.659	120.02	119.59	119.75	23827902.0
2010-11-03 15:30:00	SPY	ETF	119.75	119.97	119.51	119.97	23570594.0
2010-11-03 16:00:00	SPY	ETF	119.96	120.26	119.095	120.22	11388209.0
2010-11-03 16:30:00	SPY	ETF	120.23	120.26	119.5124	120.15	3645076.0
2010-11-03 17:00:00	SPY	ETF	120.15	120.19	120.14	120.18	96856.0
2010-11-03 17:30:00	SPY	ETF	120.16	120.18	120.12	120.13	55538.0
2010-11-03 18:00:00	SPY	ETF	120.14	120.19	120.01	120.13	152143.0
2010-11-03 18:30:00	SPY	ETF	120.11	120.14	120.09	120.13	38539.0
2010-11-03 19:00:00	SPY	ETF	120.15	120.19	120.1	120.13	28558.0
2010-11-03 19:30:00	SPY	ETF	120.14	120.23	120.13	120.19	38687.0
2010-11-03 04:00:00	QQQ	ETF	52.81	52.81	52.8	52.8	244.0
2010-11-03 07:00:00	QQQ	ETF	52.86	52.88	52.86	52.87	5650.0
2010-11-03 07:30:00	QQQ	ETF	52.88	52.92	52.86	52.92	55150.0
2010-11-03 08:00:00	QQQ	ETF	52.91	52.94	52.87	52.91	89974.0
2010-11-03 08:30:00	QQQ	ETF	52.92	52.92	52.84	52.9	55739.0
2010-11-03 09:00:00	QQQ	ETF	52.91	52.91	52.8	52.83	634104.0
2010-11-03 09:30:00	QQQ	ETF	52.84	52.89	52.75	52.77	5756701.0
2010-11-03 10:00:00	QQQ	ETF	52.77	52.85	52.75	52.77	4250017.0
2010-11-03 10:30:00	QQQ	ETF	52.78	52.8201	52.64	52.675	4047276.0
2010-11-03 11:00:00	QQQ	ETF	52.67	52.72	52.51	52.55	4608559.0
2010-11-03 11:30:00	QQQ	ETF	52.542	52.66	52.54	52.61	2522344.0
2010-11-03 12:00:00	QQQ	ETF	52.62	52.62	52.5	52.56	1452426.0
2010-11-03 12:30:00	QQQ	ETF	52.56	52.63	52.53	52.6	2235561.0
2010-11-03 13:00:00	QQQ	ETF	52.6	52.7	52.6	52.63	1800139.0
2010-11-03 13:30:00	QQQ	ETF	52.63	52.67	52.58	52.64	2193357.0
2010-11-03 14:00:00	QQQ	ETF	52.63	52.94	52.44	52.52	19986382.0
2010-11-03 14:30:00	QQQ	ETF	52.51	52.98	52.36	52.9299	14590837.0
2010-11-03 15:00:00	QQQ	ETF	52.93	53.04	52.89	52.92	7653524.0

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

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