PREVIEW / etf_1hour / 2010-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-13.parquet
  size:    173 KB
  rows:    5,306

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-12-13 04:00:00	SPY	ETF	124.6	124.66	124.58	124.58	15200.0
2010-12-13 05:00:00	SPY	ETF	124.63	124.68	124.63	124.68	7900.0
2010-12-13 06:00:00	SPY	ETF	124.69	124.71	124.58	124.71	70900.0
2010-12-13 07:00:00	SPY	ETF	124.73	125.01	124.7	124.93	245193.0
2010-12-13 08:00:00	SPY	ETF	124.93	125.15	124.9	125.05	1386867.0
2010-12-13 09:00:00	SPY	ETF	125.05	125.13	124.67	124.74	14741216.0
2010-12-13 10:00:00	SPY	ETF	124.73	125.14	124.73	125.125	17107757.0
2010-12-13 11:00:00	SPY	ETF	125.12	125.12	124.9	125.06	13490669.0
2010-12-13 12:00:00	SPY	ETF	125.05	125.0999	124.93	125.04	7707629.0
2010-12-13 13:00:00	SPY	ETF	125.03	125.12	124.96	125.1	9139984.0
2010-12-13 14:00:00	SPY	ETF	125.09	125.2	125.05	125.065	11459078.0
2010-12-13 15:00:00	SPY	ETF	125.07	125.1	124.52	124.55	34134812.0
2010-12-13 16:00:00	SPY	ETF	124.57	125.09	124.5106	124.62	19381608.0
2010-12-13 17:00:00	SPY	ETF	124.61	124.7	124.6	124.66	458934.0
2010-12-13 18:00:00	SPY	ETF	124.65	124.65	124.51	124.53	117524.0
2010-12-13 19:00:00	SPY	ETF	124.53	124.54	124.47	124.52	79512.0
2010-12-13 04:00:00	QQQ	ETF	54.56	54.58	54.54	54.58	108200.0
2010-12-13 05:00:00	QQQ	ETF	54.52	54.57	54.52	54.57	10100.0
2010-12-13 06:00:00	QQQ	ETF	54.57	54.58	54.53	54.55	20659.0
2010-12-13 07:00:00	QQQ	ETF	54.56	54.66	54.56	54.65	97125.0
2010-12-13 08:00:00	QQQ	ETF	54.66	54.74	54.65	54.71	411877.0
2010-12-13 09:00:00	QQQ	ETF	54.72	54.76	54.51	54.5282	8698549.0
2010-12-13 10:00:00	QQQ	ETF	54.53	54.74	54.525	54.73	6366927.0
2010-12-13 11:00:00	QQQ	ETF	54.72	54.73	54.59	54.615	4032590.0
2010-12-13 12:00:00	QQQ	ETF	54.62	54.63	54.55	54.609	2914653.0
2010-12-13 13:00:00	QQQ	ETF	54.6038	54.63	54.54	54.595	2437346.0
2010-12-13 14:00:00	QQQ	ETF	54.6	54.64	54.58	54.595	2274310.0
2010-12-13 15:00:00	QQQ	ETF	54.59	54.6	54.27	54.29	11499689.0
2010-12-13 16:00:00	QQQ	ETF	54.3	54.4861	54.28	54.36	9743906.0
2010-12-13 17:00:00	QQQ	ETF	54.36	54.39	54.34	54.37	19227.0
2010-12-13 18:00:00	QQQ	ETF	54.37	54.38	54.32	54.32	14765.0
2010-12-13 19:00:00	QQQ	ETF	54.31	54.34	54.3	54.33	9266.0
2010-12-13 04:00:00	IWM	ETF	77.79	77.8	77.74	77.74	712.0
2010-12-13 06:00:00	IWM	ETF	77.76	77.81	77.75	77.81	3504.0
2010-12-13 07:00:00	IWM	ETF	77.84	78.04	77.84	78.04	41622.0
2010-12-13 08:00:00	IWM	ETF	78.03	78.18	78.01	78.08	239757.0
2010-12-13 09:00:00	IWM	ETF	78.08	78.12	77.78	77.99	4977564.0
2010-12-13 10:00:00	IWM	ETF	77.99	78.19	77.99	78.16	4720459.0
2010-12-13 11:00:00	IWM	ETF	78.15	78.16	77.8999	77.96	4101641.0
2010-12-13 12:00:00	IWM	ETF	77.97	77.97	77.77	77.89	2541045.0
2010-12-13 13:00:00	IWM	ETF	77.889	77.96	77.8	77.855	2030620.0
2010-12-13 14:00:00	IWM	ETF	77.86	77.92	77.79	77.79	2648971.0
2010-12-13 15:00:00	IWM	ETF	77.8	77.82	77.33	77.33	9891186.0
2010-12-13 16:00:00	IWM	ETF	77.33	77.8112	77.32	77.47	5549194.0
2010-12-13 17:00:00	IWM	ETF	77.48	77.54	77.44	77.44	5800.0
2010-12-13 18:00:00	IWM	ETF	77.52	77.54	77.47	77.47	2800.0
2010-12-13 19:00:00	IWM	ETF	77.45	77.45	77.41	77.41	1100.0
2010-12-13 07:00:00	DIA	ETF	114.7	114.7	114.62	114.62	3000.0
2010-12-13 08:00:00	DIA	ETF	114.65	114.78	114.65	114.69	16400.0
2010-12-13 09:00:00	DIA	ETF	114.71	114.72	114.43	114.45	409344.0

> showing 50 of 5,306 rows — these rows as CSV

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