PREVIEW / etf_1hour / 2010-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-23.parquet
  size:    159 KB
  rows:    4,880

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-07-23 04:00:00	SPY	ETF	109.71	109.94	109.69	109.85	12900.0
2010-07-23 05:00:00	SPY	ETF	109.64	109.7	109.64	109.7	22350.0
2010-07-23 06:00:00	SPY	ETF	109.67	109.91	109.59	109.7	65025.0
2010-07-23 07:00:00	SPY	ETF	109.81	109.91	109.66	109.72	1100109.0
2010-07-23 08:00:00	SPY	ETF	109.72	109.85	109.58	109.63	2701104.0
2010-07-23 09:00:00	SPY	ETF	109.64	109.71	108.96	109.03	28010201.0
2010-07-23 10:00:00	SPY	ETF	109.04	109.84	108.93	109.52	26119734.0
2010-07-23 11:00:00	SPY	ETF	109.53	109.85	109.37	109.68	19824402.0
2010-07-23 12:00:00	SPY	ETF	109.69	109.97	109.17	109.58	38827306.0
2010-07-23 13:00:00	SPY	ETF	109.58	110.43	109.335	110.2999	28856295.0
2010-07-23 14:00:00	SPY	ETF	110.29	110.57	109.3	110.43	22591211.0
2010-07-23 15:00:00	SPY	ETF	110.42	110.47	109.86	110.41	40477429.0
2010-07-23 16:00:00	SPY	ETF	110.41	110.71	109.145	110.65	10687203.0
2010-07-23 17:00:00	SPY	ETF	110.64	110.77	110.64	110.7	208875.0
2010-07-23 18:00:00	SPY	ETF	110.7	110.71	110.41	110.68	45109.0
2010-07-23 19:00:00	SPY	ETF	110.65	110.79	110.65	110.79	52474.0
2010-07-23 04:00:00	QQQ	ETF	45.86	45.86	45.8	45.8	500.0
2010-07-23 05:00:00	QQQ	ETF	45.75	45.75	45.75	45.75	400.0
2010-07-23 06:00:00	QQQ	ETF	45.76	45.83	45.76	45.76	1000.0
2010-07-23 07:00:00	QQQ	ETF	45.81	45.85	45.72	45.75	463701.0
2010-07-23 08:00:00	QQQ	ETF	45.73	45.8	45.62	45.63	3460559.0
2010-07-23 09:00:00	QQQ	ETF	45.64	45.75	45.41	45.42	14372570.0
2010-07-23 10:00:00	QQQ	ETF	45.42	45.82	45.38	45.67	9346194.0
2010-07-23 11:00:00	QQQ	ETF	45.68	45.75	45.55	45.67	6094617.0
2010-07-23 12:00:00	QQQ	ETF	45.68	45.8	45.38	45.58	12645581.0
2010-07-23 13:00:00	QQQ	ETF	45.59	46.07	45.47	45.94	9683439.0
2010-07-23 14:00:00	QQQ	ETF	45.95	46.09	45.89	46.05	8150399.0
2010-07-23 15:00:00	QQQ	ETF	46.05	46.1	45.88	46.09	11955184.0
2010-07-23 16:00:00	QQQ	ETF	46.08	46.21	45.486	46.2	1591782.0
2010-07-23 17:00:00	QQQ	ETF	46.18	46.2	46.14	46.14	36526.0
2010-07-23 18:00:00	QQQ	ETF	46.14	46.18	46.12	46.15	4810.0
2010-07-23 19:00:00	QQQ	ETF	46.17	46.25	46.13	46.22	38735.0
2010-07-23 04:00:00	IWM	ETF	63.84	63.84	63.84	63.84	700.0
2010-07-23 06:00:00	IWM	ETF	63.7	63.92	63.7	63.92	7700.0
2010-07-23 07:00:00	IWM	ETF	63.93	63.97	63.78	63.8	186250.0
2010-07-23 08:00:00	IWM	ETF	63.87	63.87	63.54	63.58	1692669.0
2010-07-23 09:00:00	IWM	ETF	63.59	63.61	62.94	63.05	6681045.0
2010-07-23 10:00:00	IWM	ETF	63.05	63.95	62.99	63.72	6910906.0
2010-07-23 11:00:00	IWM	ETF	63.72	64.07	63.65	63.98	7381750.0
2010-07-23 12:00:00	IWM	ETF	63.99	64.2	63.63	63.98	8717931.0
2010-07-23 13:00:00	IWM	ETF	63.99	65.05	63.74	64.82	12142106.0
2010-07-23 14:00:00	IWM	ETF	64.82	64.97	64.58	64.85	6746869.0
2010-07-23 15:00:00	IWM	ETF	64.85	65.11	64.62	65.01	15175645.0
2010-07-23 16:00:00	IWM	ETF	65.0	65.18	63.2973	65.15	1933005.0
2010-07-23 17:00:00	IWM	ETF	65.16	65.31	64.98	65.25	102468.0
2010-07-23 18:00:00	IWM	ETF	65.24	65.3	65.22	65.22	2900.0
2010-07-23 19:00:00	IWM	ETF	65.2	65.26	65.15	65.26	1789.0
2010-07-23 04:00:00	DIA	ETF	103.69	103.7	103.69	103.7	200.0
2010-07-23 06:00:00	DIA	ETF	103.68	103.68	103.68	103.68	100.0
2010-07-23 07:00:00	DIA	ETF	103.55	103.55	103.55	103.55	101.0

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

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