PREVIEW / etf_1hour / 2010-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-22.parquet
  size:    158 KB
  rows:    4,861

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-22 04:00:00	SPY	ETF	115.41	115.53	115.31	115.49	18324.0
2010-03-22 05:00:00	SPY	ETF	115.41	115.41	115.2	115.2	40356.0
2010-03-22 06:00:00	SPY	ETF	115.24	115.32	115.19	115.31	14337.0
2010-03-22 07:00:00	SPY	ETF	115.36	115.39	115.21	115.25	872556.0
2010-03-22 08:00:00	SPY	ETF	115.26	116.1	115.24	115.28	2231867.0
2010-03-22 09:00:00	SPY	ETF	115.29	116.02	115.24	115.91	27863222.0
2010-03-22 10:00:00	SPY	ETF	115.9001	116.48	115.83	116.3301	37863285.0
2010-03-22 11:00:00	SPY	ETF	116.34	116.49	116.23	116.39	20980540.0
2010-03-22 12:00:00	SPY	ETF	116.4	116.52	116.24	116.46	17890958.0
2010-03-22 13:00:00	SPY	ETF	116.46	116.72	116.35	116.541	14142644.0
2010-03-22 14:00:00	SPY	ETF	116.535	116.79	116.42	116.68	19105617.0
2010-03-22 15:00:00	SPY	ETF	116.68	116.8	116.52	116.58	30121829.0
2010-03-22 16:00:00	SPY	ETF	116.57	116.77	115.843	116.71	11267825.0
2010-03-22 17:00:00	SPY	ETF	116.72	116.76	116.68	116.69	52608.0
2010-03-22 18:00:00	SPY	ETF	116.7	116.86	116.59	116.8	145730.0
2010-03-22 19:00:00	SPY	ETF	116.8	116.8	116.75	116.78	251837.0
2010-03-22 04:00:00	QQQ	ETF	47.33	47.38	47.31	47.38	2100.0
2010-03-22 05:00:00	QQQ	ETF	47.28	47.28	47.28	47.28	200.0
2010-03-22 06:00:00	QQQ	ETF	47.29	47.29	47.26	47.26	900.0
2010-03-22 07:00:00	QQQ	ETF	47.34	47.34	47.26	47.29	38114.0
2010-03-22 08:00:00	QQQ	ETF	47.28	47.36	47.26	47.29	354072.0
2010-03-22 09:00:00	QQQ	ETF	47.29	47.77	47.25	47.7001	14805251.0
2010-03-22 10:00:00	QQQ	ETF	47.7001	47.88	47.63	47.8285	11424975.0
2010-03-22 11:00:00	QQQ	ETF	47.82	47.9	47.8	47.88	6481795.0
2010-03-22 12:00:00	QQQ	ETF	47.8701	47.93	47.78	47.9201	6054814.0
2010-03-22 13:00:00	QQQ	ETF	47.93	48.02	47.7743	47.92	6426776.0
2010-03-22 14:00:00	QQQ	ETF	47.9262	48.11	47.89	48.04	5431311.0
2010-03-22 15:00:00	QQQ	ETF	48.04	48.08	47.89	47.91	8737668.0
2010-03-22 16:00:00	QQQ	ETF	47.92	47.9999	47.29	47.98	4075658.0
2010-03-22 17:00:00	QQQ	ETF	47.98	47.98	47.96	47.96	29183.0
2010-03-22 18:00:00	QQQ	ETF	47.97	48.0	47.97	47.99	124418.0
2010-03-22 19:00:00	QQQ	ETF	47.99	47.99	47.97	47.99	36376.0
2010-03-22 06:00:00	IWM	ETF	66.8	66.8	66.8	66.8	200.0
2010-03-22 07:00:00	IWM	ETF	66.94	66.95	66.81	66.81	30662.0
2010-03-22 08:00:00	IWM	ETF	66.84	67.18	66.8	66.83	279315.0
2010-03-22 09:00:00	IWM	ETF	66.83	67.5	66.78	67.39	8731575.0
2010-03-22 10:00:00	IWM	ETF	67.4	68.02	67.3	67.9362	9303761.0
2010-03-22 11:00:00	IWM	ETF	67.94	68.08	67.8333	68.01	7824311.0
2010-03-22 12:00:00	IWM	ETF	68.01	68.16	67.85	68.1465	5150044.0
2010-03-22 13:00:00	IWM	ETF	68.14	68.34	68.12	68.17	6815265.0
2010-03-22 14:00:00	IWM	ETF	68.17	68.51	68.07	68.32	5515470.0
2010-03-22 15:00:00	IWM	ETF	68.33	68.45	68.22	68.34	7875243.0
2010-03-22 16:00:00	IWM	ETF	68.33	68.44	67.906	68.44	1345977.0
2010-03-22 17:00:00	IWM	ETF	68.4	68.4	68.33	68.33	10900.0
2010-03-22 18:00:00	IWM	ETF	68.39	68.45	68.39	68.42	861.0
2010-03-22 19:00:00	IWM	ETF	68.46	68.52	68.44	68.52	2825.0
2010-03-22 05:00:00	DIA	ETF	106.88	106.88	106.88	106.88	1500.0
2010-03-22 06:00:00	DIA	ETF	106.87	106.87	106.86	106.86	500.0
2010-03-22 07:00:00	DIA	ETF	106.95	106.95	106.84	106.86	9587.0
2010-03-22 08:00:00	DIA	ETF	106.83	107.04	106.83	106.92	16824.0

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

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