PREVIEW / etf_1hour / 2010-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-05.parquet
  size:    171 KB
  rows:    5,256

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-05 04:00:00	SPY	ETF	114.08	114.41	114.08	114.38	9100.0
2010-10-05 05:00:00	SPY	ETF	114.32	114.32	114.29	114.29	11100.0
2010-10-05 06:00:00	SPY	ETF	114.25	114.25	114.15	114.16	32800.0
2010-10-05 07:00:00	SPY	ETF	114.2	114.27	114.14	114.16	487432.0
2010-10-05 08:00:00	SPY	ETF	114.5	114.88	114.14	114.87	2985235.0
2010-10-05 09:00:00	SPY	ETF	114.87	115.25	114.67	115.2	24599204.0
2010-10-05 10:00:00	SPY	ETF	115.22	115.61	114.68	115.41	50334334.0
2010-10-05 11:00:00	SPY	ETF	115.4173	115.93	115.41	115.73	32279973.0
2010-10-05 12:00:00	SPY	ETF	115.73	115.94	115.69	115.91	11770358.0
2010-10-05 13:00:00	SPY	ETF	115.91	116.1	115.85	116.0	19369095.0
2010-10-05 14:00:00	SPY	ETF	116.0	116.15	115.91	116.09	19227218.0
2010-10-05 15:00:00	SPY	ETF	116.1	116.32	116.02	116.03	43505068.0
2010-10-05 16:00:00	SPY	ETF	116.03	116.185	113.6894	115.95	15460333.0
2010-10-05 17:00:00	SPY	ETF	115.94	116.0953	115.91	115.94	6747320.0
2010-10-05 18:00:00	SPY	ETF	115.94	116.05	115.93	116.0	291267.0
2010-10-05 19:00:00	SPY	ETF	116.02	116.15	116.01	116.15	33458.0
2010-10-05 04:00:00	QQQ	ETF	48.75	48.8	48.75	48.8	400.0
2010-10-05 05:00:00	QQQ	ETF	48.77	48.77	48.77	48.77	100.0
2010-10-05 06:00:00	QQQ	ETF	48.82	48.82	48.73	48.75	5200.0
2010-10-05 07:00:00	QQQ	ETF	48.76	48.76	48.72	48.75	152959.0
2010-10-05 08:00:00	QQQ	ETF	48.73	49.07	48.72	49.06	1246165.0
2010-10-05 09:00:00	QQQ	ETF	49.07	49.36	48.99	49.32	10444032.0
2010-10-05 10:00:00	QQQ	ETF	49.32	49.56	49.2	49.48	22414511.0
2010-10-05 11:00:00	QQQ	ETF	49.48	49.645	49.43	49.57	9427823.0
2010-10-05 12:00:00	QQQ	ETF	49.58	49.64	49.53	49.61	6437144.0
2010-10-05 13:00:00	QQQ	ETF	49.61	49.7	49.52	49.59	9671054.0
2010-10-05 14:00:00	QQQ	ETF	49.59	49.68	49.551	49.655	4116803.0
2010-10-05 15:00:00	QQQ	ETF	49.66	49.76	49.63	49.65	12021927.0
2010-10-05 16:00:00	QQQ	ETF	49.66	49.7242	49.5753	49.61	4753935.0
2010-10-05 17:00:00	QQQ	ETF	49.61	49.705	49.6	49.68	2173668.0
2010-10-05 18:00:00	QQQ	ETF	49.65	49.71	49.64	49.68	833119.0
2010-10-05 19:00:00	QQQ	ETF	49.7	49.75	49.69	49.73	102497.0
2010-10-05 04:00:00	IWM	ETF	67.3	67.39	67.22	67.39	2890.0
2010-10-05 06:00:00	IWM	ETF	67.31	67.32	67.24	67.29	5200.0
2010-10-05 07:00:00	IWM	ETF	67.27	67.3	67.2	67.24	53370.0
2010-10-05 08:00:00	IWM	ETF	67.25	67.71	67.23	67.67	429152.0
2010-10-05 09:00:00	IWM	ETF	67.67	67.83	67.25	67.65	8020655.0
2010-10-05 10:00:00	IWM	ETF	67.64	68.32	67.44	68.1901	15996857.0
2010-10-05 11:00:00	IWM	ETF	68.18	68.61	68.15	68.47	9596688.0
2010-10-05 12:00:00	IWM	ETF	68.48	68.67	68.42	68.6599	4367396.0
2010-10-05 13:00:00	IWM	ETF	68.66	68.945	68.59	68.77	7342973.0
2010-10-05 14:00:00	IWM	ETF	68.76	68.91	68.69	68.86	4276186.0
2010-10-05 15:00:00	IWM	ETF	68.87	69.01	68.79	68.83	11756909.0
2010-10-05 16:00:00	IWM	ETF	68.83	68.9889	66.9383	68.83	4374039.0
2010-10-05 17:00:00	IWM	ETF	66.9383	68.87	66.9382	66.9382	2005795.0
2010-10-05 18:00:00	IWM	ETF	68.84	68.91	68.84	68.89	12941.0
2010-10-05 19:00:00	IWM	ETF	68.88	68.88	68.87	68.87	700.0
2010-10-05 04:00:00	DIA	ETF	107.8	108.1	107.8	108.1	800.0
2010-10-05 07:00:00	DIA	ETF	107.86	107.88	107.86	107.88	950.0
2010-10-05 08:00:00	DIA	ETF	107.87	108.42	107.87	108.34	49390.0

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

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