PREVIEW / etf_1hour / 2010-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-28.parquet
  size:    165 KB
  rows:    5,000

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-04-28 04:00:00	SPY	ETF	118.55	118.6	118.23	118.28	11659.0
2010-04-28 05:00:00	SPY	ETF	118.41	118.57	118.2	118.51	56500.0
2010-04-28 06:00:00	SPY	ETF	118.51	118.78	118.4	118.78	140659.0
2010-04-28 07:00:00	SPY	ETF	118.77	119.2	118.77	118.93	1705120.0
2010-04-28 08:00:00	SPY	ETF	118.92	119.4	118.07	119.29	4862232.0
2010-04-28 09:00:00	SPY	ETF	119.3	119.47	118.84	118.97	41474824.0
2010-04-28 10:00:00	SPY	ETF	118.97	119.14	118.66	119.1301	44397513.0
2010-04-28 11:00:00	SPY	ETF	119.14	119.44	118.27	118.85	70398513.0
2010-04-28 12:00:00	SPY	ETF	118.85	119.25	118.5	119.17	23951123.0
2010-04-28 13:00:00	SPY	ETF	119.17	119.3	119.08	119.2199	12374512.0
2010-04-28 14:00:00	SPY	ETF	119.22	119.68	119.1	119.49	43045834.0
2010-04-28 15:00:00	SPY	ETF	119.48	119.63	118.5225	119.33	40320133.0
2010-04-28 16:00:00	SPY	ETF	119.34	119.6	118.64	119.53	14400991.0
2010-04-28 17:00:00	SPY	ETF	119.56	119.65	119.53	119.57	218016.0
2010-04-28 18:00:00	SPY	ETF	119.57	119.67	119.55	119.6	78116.0
2010-04-28 19:00:00	SPY	ETF	119.59	119.63	119.58	119.6	60265.0
2010-04-28 04:00:00	QQQ	ETF	49.35	49.35	49.26	49.29	700.0
2010-04-28 05:00:00	QQQ	ETF	49.34	49.34	49.28	49.34	800.0
2010-04-28 06:00:00	QQQ	ETF	49.41	49.54	49.41	49.53	35201.0
2010-04-28 07:00:00	QQQ	ETF	49.55	49.71	49.55	49.64	301352.0
2010-04-28 08:00:00	QQQ	ETF	49.65	49.79	49.42	49.76	997259.0
2010-04-28 09:00:00	QQQ	ETF	49.76	49.8	49.2805	49.34	16020002.0
2010-04-28 10:00:00	QQQ	ETF	49.34	49.36	49.07	49.25	24446695.0
2010-04-28 11:00:00	QQQ	ETF	49.25	49.36	48.98	49.16	32075712.0
2010-04-28 12:00:00	QQQ	ETF	49.16	49.28	49.035	49.2699	8063566.0
2010-04-28 13:00:00	QQQ	ETF	49.26	49.39	49.23	49.34	7192872.0
2010-04-28 14:00:00	QQQ	ETF	49.33	49.53	49.25	49.48	18336772.0
2010-04-28 15:00:00	QQQ	ETF	49.48	49.54	49.21	49.381	11159860.0
2010-04-28 16:00:00	QQQ	ETF	49.38	49.45	49.25	49.42	6020011.0
2010-04-28 17:00:00	QQQ	ETF	49.41	49.49	49.4	49.47	231712.0
2010-04-28 18:00:00	QQQ	ETF	49.46	49.49	49.46	49.46	26870.0
2010-04-28 19:00:00	QQQ	ETF	49.49	49.49	49.46	49.48	4409.0
2010-04-28 06:00:00	IWM	ETF	72.24	72.29	72.14	72.29	500.0
2010-04-28 07:00:00	IWM	ETF	72.3	72.52	72.3	72.4	175045.0
2010-04-28 08:00:00	IWM	ETF	72.4	72.72	72.11	72.69	641349.0
2010-04-28 09:00:00	IWM	ETF	72.69	72.78	72.13	72.46	11766072.0
2010-04-28 10:00:00	IWM	ETF	72.46	72.63	72.13	72.37	16442679.0
2010-04-28 11:00:00	IWM	ETF	72.37	72.63	71.92	72.19	14843588.0
2010-04-28 12:00:00	IWM	ETF	72.19	72.4	71.98	72.3	4980497.0
2010-04-28 13:00:00	IWM	ETF	72.308	72.47	72.19	72.32	2782442.0
2010-04-28 14:00:00	IWM	ETF	72.32	72.64	72.22	72.57	12626373.0
2010-04-28 15:00:00	IWM	ETF	72.58	72.64	72.019	72.2725	11157498.0
2010-04-28 16:00:00	IWM	ETF	72.27	72.52	72.1411	72.47	2976587.0
2010-04-28 17:00:00	IWM	ETF	72.47	72.53	72.45	72.45	42401.0
2010-04-28 18:00:00	IWM	ETF	72.45	72.52	72.45	72.5	600.0
2010-04-28 19:00:00	IWM	ETF	72.47	72.5	72.45	72.5	1500.0
2010-04-28 06:00:00	DIA	ETF	110.06	110.11	110.04	110.11	400.0
2010-04-28 07:00:00	DIA	ETF	110.43	110.46	110.33	110.33	7350.0
2010-04-28 08:00:00	DIA	ETF	110.33	110.6	110.29	110.55	23615.0
2010-04-28 09:00:00	DIA	ETF	110.58	110.69	110.05	110.15	1497078.0

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

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