PREVIEW / etf_1hour / 2010-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-06.parquet
  size:    166 KB
  rows:    5,036

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-06 04:00:00	SPY	ETF	102.7	102.85	102.67	102.79	9044.0
2010-07-06 05:00:00	SPY	ETF	102.83	103.08	102.83	103.06	44800.0
2010-07-06 06:00:00	SPY	ETF	102.99	103.22	102.98	103.18	242550.0
2010-07-06 07:00:00	SPY	ETF	103.17	103.2	102.92	103.03	1043253.0
2010-07-06 08:00:00	SPY	ETF	103.0	103.46	101.57	103.42	3956103.0
2010-07-06 09:00:00	SPY	ETF	103.42	103.91	103.39	103.74	26626908.0
2010-07-06 10:00:00	SPY	ETF	103.74	104.37	103.51	103.96	41523713.0
2010-07-06 11:00:00	SPY	ETF	103.96	104.1399	103.65	103.901	22290430.0
2010-07-06 12:00:00	SPY	ETF	103.9	104.05	102.98	103.078	22506042.0
2010-07-06 13:00:00	SPY	ETF	103.09	103.31	102.37	102.48	28664711.0
2010-07-06 14:00:00	SPY	ETF	102.48	102.79	102.1	102.34	29242360.0
2010-07-06 15:00:00	SPY	ETF	102.3399	102.91	101.88	102.87	53711800.0
2010-07-06 16:00:00	SPY	ETF	102.87	106.2033	102.7131	103.0	20169572.0
2010-07-06 17:00:00	SPY	ETF	102.99	103.08	102.3359	103.02	1264759.0
2010-07-06 18:00:00	SPY	ETF	103.02	103.03	102.2	102.91	96069.0
2010-07-06 19:00:00	SPY	ETF	102.91	103.0	102.91	102.95	47940.0
2010-07-06 04:00:00	QQQ	ETF	42.76	42.8	42.76	42.8	1200.0
2010-07-06 05:00:00	QQQ	ETF	42.82	42.89	42.81	42.87	31900.0
2010-07-06 06:00:00	QQQ	ETF	42.93	43.04	42.89	43.03	36723.0
2010-07-06 07:00:00	QQQ	ETF	43.02	43.03	42.9	42.97	389932.0
2010-07-06 08:00:00	QQQ	ETF	42.97	43.1	42.95	43.1	1414168.0
2010-07-06 09:00:00	QQQ	ETF	43.08	43.2	42.96	43.08	11073752.0
2010-07-06 10:00:00	QQQ	ETF	43.08	43.37	42.97	43.22	11421966.0
2010-07-06 11:00:00	QQQ	ETF	43.21	43.27	43.07	43.16	7613622.0
2010-07-06 12:00:00	QQQ	ETF	43.16	43.22	42.67	42.73	11170685.0
2010-07-06 13:00:00	QQQ	ETF	42.72	42.83	42.43	42.49	8674701.0
2010-07-06 14:00:00	QQQ	ETF	42.49	42.64	42.32	42.47	10612641.0
2010-07-06 15:00:00	QQQ	ETF	42.47	42.61	42.25	42.6	15397183.0
2010-07-06 16:00:00	QQQ	ETF	42.61	43.026	42.3775	42.68	7444774.0
2010-07-06 17:00:00	QQQ	ETF	42.68	42.74	42.68	42.72	162582.0
2010-07-06 18:00:00	QQQ	ETF	42.72	42.73	42.68	42.68	9649.0
2010-07-06 19:00:00	QQQ	ETF	42.68	42.72	42.68	42.7	8129.0
2010-07-06 05:00:00	IWM	ETF	60.44	60.44	60.41	60.41	600.0
2010-07-06 06:00:00	IWM	ETF	60.5	60.61	60.5	60.59	7900.0
2010-07-06 07:00:00	IWM	ETF	60.6	60.64	60.49	60.56	17700.0
2010-07-06 08:00:00	IWM	ETF	60.54	60.77	60.52	60.74	176951.0
2010-07-06 09:00:00	IWM	ETF	60.73	61.13	60.71	60.93	10144987.0
2010-07-06 10:00:00	IWM	ETF	60.94	61.4	60.76	60.84	11387972.0
2010-07-06 11:00:00	IWM	ETF	60.83	61.5	60.42	60.611	7585256.0
2010-07-06 12:00:00	IWM	ETF	60.62	60.78	59.78	59.88	9441519.0
2010-07-06 13:00:00	IWM	ETF	59.89	60.09	59.18	59.22	7434103.0
2010-07-06 14:00:00	IWM	ETF	59.23	59.55	58.91	59.09	9691428.0
2010-07-06 15:00:00	IWM	ETF	59.09	59.25	58.66	59.01	17836332.0
2010-07-06 16:00:00	IWM	ETF	59.02	59.9	58.9026	59.16	7169146.0
2010-07-06 17:00:00	IWM	ETF	59.15	59.22	59.15	59.22	35800.0
2010-07-06 18:00:00	IWM	ETF	59.2	59.23	59.2	59.2	7300.0
2010-07-06 19:00:00	IWM	ETF	59.24	59.3	59.24	59.3	2700.0
2010-07-06 04:00:00	DIA	ETF	97.23	97.27	97.23	97.27	1500.0
2010-07-06 05:00:00	DIA	ETF	97.31	97.43	97.31	97.43	4412.0
2010-07-06 06:00:00	DIA	ETF	97.41	97.59	97.39	97.59	4348.0

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

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