PREVIEW / etf_1hour / 2010-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-09.parquet
  size:    156 KB
  rows:    4,818

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-03-09 04:00:00	SPY	ETF	113.82	113.93	113.79	113.79	4600.0
2010-03-09 05:00:00	SPY	ETF	113.86	113.86	113.74	113.74	8800.0
2010-03-09 06:00:00	SPY	ETF	113.75	113.8	113.64	113.7	83400.0
2010-03-09 07:00:00	SPY	ETF	113.71	113.92	113.67	113.83	306731.0
2010-03-09 08:00:00	SPY	ETF	113.83	113.89	113.65	113.85	1429502.0
2010-03-09 09:00:00	SPY	ETF	113.84	114.29	113.77	114.1983	14678334.0
2010-03-09 10:00:00	SPY	ETF	114.2	114.6	114.08	114.54	24420880.0
2010-03-09 11:00:00	SPY	ETF	114.54	114.7	114.3	114.67	17830194.0
2010-03-09 12:00:00	SPY	ETF	114.66	114.93	114.59	114.92	11713509.0
2010-03-09 13:00:00	SPY	ETF	114.92	114.99	114.75	114.8	13162557.0
2010-03-09 14:00:00	SPY	ETF	114.8099	114.95	114.51	114.57	18183670.0
2010-03-09 15:00:00	SPY	ETF	114.5699	114.64	114.08	114.45	41744993.0
2010-03-09 16:00:00	SPY	ETF	114.44	114.84	114.07	114.51	10168249.0
2010-03-09 17:00:00	SPY	ETF	114.51	114.51	114.41	114.49	418591.0
2010-03-09 18:00:00	SPY	ETF	114.48	114.53	114.44	114.44	80498.0
2010-03-09 19:00:00	SPY	ETF	114.45	114.45	114.37	114.44	99408.0
2010-03-09 05:00:00	QQQ	ETF	46.41	46.41	46.41	46.41	100.0
2010-03-09 06:00:00	QQQ	ETF	46.33	46.33	46.32	46.32	5400.0
2010-03-09 07:00:00	QQQ	ETF	46.35	46.39	46.33	46.38	21465.0
2010-03-09 08:00:00	QQQ	ETF	46.38	46.4	46.32	46.38	268850.0
2010-03-09 09:00:00	QQQ	ETF	46.38	46.63	46.36	46.61	10207826.0
2010-03-09 10:00:00	QQQ	ETF	46.61	46.92	46.57	46.89	14863915.0
2010-03-09 11:00:00	QQQ	ETF	46.885	46.92	46.73	46.889	12097854.0
2010-03-09 12:00:00	QQQ	ETF	46.88	47.03	46.84	47.02	6536114.0
2010-03-09 13:00:00	QQQ	ETF	47.025	47.05	46.925	46.9817	9871225.0
2010-03-09 14:00:00	QQQ	ETF	46.9801	47.04	46.81	46.82	9823076.0
2010-03-09 15:00:00	QQQ	ETF	46.8201	46.86	46.61	46.7939	19993485.0
2010-03-09 16:00:00	QQQ	ETF	46.82	46.98	46.5402	46.81	10707606.0
2010-03-09 17:00:00	QQQ	ETF	46.8	46.83	46.5402	46.82	1029449.0
2010-03-09 18:00:00	QQQ	ETF	46.8	46.82	46.79	46.79	19900.0
2010-03-09 19:00:00	QQQ	ETF	46.81	46.83	46.8	46.83	33300.0
2010-03-09 05:00:00	IWM	ETF	66.77	66.77	66.5	66.5	600.0
2010-03-09 07:00:00	IWM	ETF	66.49	66.54	66.45	66.52	99305.0
2010-03-09 08:00:00	IWM	ETF	66.53	66.54	66.35	66.51	446422.0
2010-03-09 09:00:00	IWM	ETF	66.5	66.87	66.48	66.83	5588012.0
2010-03-09 10:00:00	IWM	ETF	66.83	67.11	66.78	67.08	9822997.0
2010-03-09 11:00:00	IWM	ETF	67.099	67.18	66.9	67.15	6888798.0
2010-03-09 12:00:00	IWM	ETF	67.14	67.46	67.12	67.45	5914665.0
2010-03-09 13:00:00	IWM	ETF	67.45	67.49	67.28	67.31	5866859.0
2010-03-09 14:00:00	IWM	ETF	67.3	67.4	67.08	67.08	7479114.0
2010-03-09 15:00:00	IWM	ETF	67.09	67.17	66.68	66.9675	20489517.0
2010-03-09 16:00:00	IWM	ETF	66.99	67.0948	66.7815	67.05	5905337.0
2010-03-09 17:00:00	IWM	ETF	66.7805	67.08	66.7805	67.02	1045935.0
2010-03-09 18:00:00	IWM	ETF	66.97	67.15	66.97	67.11	42831.0
2010-03-09 19:00:00	IWM	ETF	67.05	67.05	66.97	67.05	3100.0
2010-03-09 06:00:00	DIA	ETF	105.24	105.24	105.24	105.24	500.0
2010-03-09 07:00:00	DIA	ETF	105.27	105.37	105.22	105.37	10800.0
2010-03-09 08:00:00	DIA	ETF	105.34	105.4	105.26	105.37	30909.0
2010-03-09 09:00:00	DIA	ETF	105.37	105.73	105.33	105.69	675278.0
2010-03-09 10:00:00	DIA	ETF	105.69	105.89	105.6	105.85	1247622.0

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

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