PREVIEW / etf_1hour / 2010-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-27.parquet
  size:    155 KB
  rows:    4,759

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-01-27 04:00:00	SPY	ETF	108.97	109.09	108.82	108.96	14265.0
2010-01-27 05:00:00	SPY	ETF	109.12	109.27	109.09	109.12	22822.0
2010-01-27 06:00:00	SPY	ETF	109.15	109.55	109.15	109.42	30835.0
2010-01-27 07:00:00	SPY	ETF	109.49	109.57	109.32	109.35	850729.0
2010-01-27 08:00:00	SPY	ETF	109.45	109.55	108.87	109.22	2762346.0
2010-01-27 09:00:00	SPY	ETF	109.22	109.51	108.83	109.23	37310514.0
2010-01-27 10:00:00	SPY	ETF	109.23	109.31	108.58	109.25	44940141.0
2010-01-27 11:00:00	SPY	ETF	109.25	109.2857	108.89	109.1	26069747.0
2010-01-27 12:00:00	SPY	ETF	109.1	109.18	108.7	108.82	16175044.0
2010-01-27 13:00:00	SPY	ETF	108.82	108.92	108.64	108.81	16882337.0
2010-01-27 14:00:00	SPY	ETF	108.81	109.65	108.33	109.54	55253431.0
2010-01-27 15:00:00	SPY	ETF	109.54	110.08	108.8	109.83	53773074.0
2010-01-27 16:00:00	SPY	ETF	109.84	110.01	108.69	109.97	15982216.0
2010-01-27 17:00:00	SPY	ETF	109.98	110.03	109.8099	109.99	121712.0
2010-01-27 18:00:00	SPY	ETF	109.98	110.23	109.98	110.11	210616.0
2010-01-27 19:00:00	SPY	ETF	110.11	110.18	110.03	110.11	170701.0
2010-01-27 04:00:00	QQQ	ETF	44.08	44.16	44.08	44.16	6600.0
2010-01-27 05:00:00	QQQ	ETF	44.25	44.25	44.25	44.25	100.0
2010-01-27 06:00:00	QQQ	ETF	44.36	44.37	44.33	44.33	20244.0
2010-01-27 07:00:00	QQQ	ETF	44.34	44.38	44.27	44.29	251457.0
2010-01-27 08:00:00	QQQ	ETF	44.28	44.32	44.24	44.24	761424.0
2010-01-27 09:00:00	QQQ	ETF	44.25	44.55	44.15	44.43	22916213.0
2010-01-27 10:00:00	QQQ	ETF	44.43	44.46	44.11	44.4	26252479.0
2010-01-27 11:00:00	QQQ	ETF	44.41	44.44	44.26	44.32	8362140.0
2010-01-27 12:00:00	QQQ	ETF	44.32	44.4	44.25	44.281	7572602.0
2010-01-27 13:00:00	QQQ	ETF	44.28	44.34	44.01	44.1962	11999632.0
2010-01-27 14:00:00	QQQ	ETF	44.19	44.73	44.13	44.65	35515042.0
2010-01-27 15:00:00	QQQ	ETF	44.66	44.85	44.35	44.69	29114784.0
2010-01-27 16:00:00	QQQ	ETF	44.7	44.72	44.1	44.55	12572800.0
2010-01-27 17:00:00	QQQ	ETF	44.54	44.56	44.5	44.53	336596.0
2010-01-27 18:00:00	QQQ	ETF	44.54	44.63	44.54	44.57	190164.0
2010-01-27 19:00:00	QQQ	ETF	44.6	44.61	44.56	44.58	13351.0
2010-01-27 06:00:00	IWM	ETF	61.3	61.3	61.29	61.29	1100.0
2010-01-27 07:00:00	IWM	ETF	61.35	61.35	61.24	61.25	78000.0
2010-01-27 08:00:00	IWM	ETF	61.21	61.4	61.0	61.0	301881.0
2010-01-27 09:00:00	IWM	ETF	61.0	61.52	60.75	61.26	10639126.0
2010-01-27 10:00:00	IWM	ETF	61.26	61.28	60.71	61.2401	12384845.0
2010-01-27 11:00:00	IWM	ETF	61.24	61.42	61.09	61.38	5896418.0
2010-01-27 12:00:00	IWM	ETF	61.38	61.4509	61.05	61.14	3740399.0
2010-01-27 13:00:00	IWM	ETF	61.14	61.25	61.0	61.0822	4154254.0
2010-01-27 14:00:00	IWM	ETF	61.08	61.6	60.85	61.43	11769292.0
2010-01-27 15:00:00	IWM	ETF	61.43	61.935	61.15	61.82	12912852.0
2010-01-27 16:00:00	IWM	ETF	61.82	61.91	61.2086	61.2086	2739306.0
2010-01-27 17:00:00	IWM	ETF	61.87	61.87	61.8	61.84	11841.0
2010-01-27 18:00:00	IWM	ETF	61.86	61.93	61.86	61.93	5847.0
2010-01-27 19:00:00	IWM	ETF	61.89	61.96	61.89	61.95	3825.0
2010-01-27 07:00:00	DIA	ETF	102.05	102.05	101.91	101.91	4100.0
2010-01-27 08:00:00	DIA	ETF	102.07	102.07	101.65	101.78	314300.0
2010-01-27 09:00:00	DIA	ETF	101.64	102.0	101.46	101.79	2882095.0
2010-01-27 10:00:00	DIA	ETF	101.76	101.845	101.23	101.74	4107623.0

> showing 50 of 4,759 rows — these rows as CSV

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