PREVIEW / etf_1hour / 2010-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-07.parquet
  size:    162 KB
  rows:    4,978

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-09-07 04:00:00	SPY	ETF	110.66	110.66	110.15	110.41	13143.0
2010-09-07 05:00:00	SPY	ETF	110.33	110.39	110.25	110.35	9700.0
2010-09-07 06:00:00	SPY	ETF	110.3	110.34	110.16	110.33	85814.0
2010-09-07 07:00:00	SPY	ETF	110.33	110.42	110.07	110.38	477056.0
2010-09-07 08:00:00	SPY	ETF	110.38	110.8	110.15	110.26	3164773.0
2010-09-07 09:00:00	SPY	ETF	110.25	110.51	109.86	109.87	21641215.0
2010-09-07 10:00:00	SPY	ETF	109.871	110.11	109.74	110.05	22040455.0
2010-09-07 11:00:00	SPY	ETF	110.05	110.19	109.83	110.15	15359410.0
2010-09-07 12:00:00	SPY	ETF	110.15	110.23	109.88	109.9701	9418377.0
2010-09-07 13:00:00	SPY	ETF	109.975	110.17	109.83	110.1599	10708310.0
2010-09-07 14:00:00	SPY	ETF	110.16	110.23	109.62	109.71	16429600.0
2010-09-07 15:00:00	SPY	ETF	109.7	109.93	109.55	109.67	29674679.0
2010-09-07 16:00:00	SPY	ETF	109.68	110.972	109.61	109.69	10106229.0
2010-09-07 17:00:00	SPY	ETF	109.69	109.74	109.65	109.72	158273.0
2010-09-07 18:00:00	SPY	ETF	109.71	109.71	109.63	109.67	125926.0
2010-09-07 19:00:00	SPY	ETF	109.67	109.76	109.65	109.67	26507.0
2010-09-07 04:00:00	QQQ	ETF	45.83	45.85	45.75	45.85	21002.0
2010-09-07 05:00:00	QQQ	ETF	45.85	45.85	45.8	45.8	11440.0
2010-09-07 06:00:00	QQQ	ETF	45.75	45.8	45.75	45.8	10446.0
2010-09-07 07:00:00	QQQ	ETF	45.8	45.82	45.64	45.72	868998.0
2010-09-07 08:00:00	QQQ	ETF	45.77	45.8	45.68	45.77	2191679.0
2010-09-07 09:00:00	QQQ	ETF	45.78	46.03	45.73	45.73	9990645.0
2010-09-07 10:00:00	QQQ	ETF	45.73	45.85	45.66	45.8201	7869772.0
2010-09-07 11:00:00	QQQ	ETF	45.82	45.87	45.72	45.845	4732988.0
2010-09-07 12:00:00	QQQ	ETF	45.84	45.88	45.7	45.76	3382842.0
2010-09-07 13:00:00	QQQ	ETF	45.76	45.84	45.69	45.84	3922250.0
2010-09-07 14:00:00	QQQ	ETF	45.84	45.89	45.65	45.68	4095952.0
2010-09-07 15:00:00	QQQ	ETF	45.68	45.77	45.625	45.71	9520921.0
2010-09-07 16:00:00	QQQ	ETF	45.7	45.975	45.6532	45.74	2591072.0
2010-09-07 17:00:00	QQQ	ETF	45.74	45.77	45.7	45.7	20943.0
2010-09-07 18:00:00	QQQ	ETF	45.73	45.74	45.72	45.73	13500.0
2010-09-07 19:00:00	QQQ	ETF	45.75	45.75	45.71	45.72	6704.0
2010-09-07 05:00:00	IWM	ETF	64.08	64.08	64.07	64.07	700.0
2010-09-07 06:00:00	IWM	ETF	63.97	64.01	63.97	64.01	4100.0
2010-09-07 07:00:00	IWM	ETF	64.03	64.1	63.91	64.1	43600.0
2010-09-07 08:00:00	IWM	ETF	64.08	64.1	63.92	64.02	86750.0
2010-09-07 09:00:00	IWM	ETF	64.02	64.16	63.41	63.43	6560608.0
2010-09-07 10:00:00	IWM	ETF	63.43	63.65	63.37	63.54	5019046.0
2010-09-07 11:00:00	IWM	ETF	63.54	63.725	63.41	63.589	5805898.0
2010-09-07 12:00:00	IWM	ETF	63.59	63.71	63.24	63.348	3865723.0
2010-09-07 13:00:00	IWM	ETF	63.34	63.45	63.19	63.44	3079285.0
2010-09-07 14:00:00	IWM	ETF	63.45	63.51	63.09	63.16	4518538.0
2010-09-07 15:00:00	IWM	ETF	63.16	63.27	62.91	63.09	10909266.0
2010-09-07 16:00:00	IWM	ETF	63.1	64.4131	63.09	63.12	3272837.0
2010-09-07 17:00:00	IWM	ETF	63.12	63.2	63.1	63.2	24800.0
2010-09-07 18:00:00	IWM	ETF	63.2	63.21	63.15	63.21	6062.0
2010-09-07 19:00:00	IWM	ETF	63.21	63.22	63.18	63.18	600.0
2010-09-07 07:00:00	DIA	ETF	104.0	104.18	103.95	104.18	4200.0
2010-09-07 08:00:00	DIA	ETF	104.14	104.16	103.95	104.02	33130.0
2010-09-07 09:00:00	DIA	ETF	104.04	104.29	103.71	103.72	980878.0

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

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