PREVIEW / etf_1hour / 2009-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-03.parquet
  size:    131 KB
  rows:    4,089

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
2009-03-03 04:00:00	SPY	ETF	71.87	71.93	71.28	71.28	4500.0
2009-03-03 05:00:00	SPY	ETF	71.31	71.36	71.14	71.35	19912.0
2009-03-03 06:00:00	SPY	ETF	71.4	71.4	70.89	71.05	49862.0
2009-03-03 07:00:00	SPY	ETF	71.1	71.63	71.1	71.27	1919916.0
2009-03-03 08:00:00	SPY	ETF	72.05	72.05	71.2	71.74	4957821.0
2009-03-03 09:00:00	SPY	ETF	71.74	71.88	71.0	71.2	36674734.0
2009-03-03 10:00:00	SPY	ETF	71.2	71.42	70.55	70.66	66757977.0
2009-03-03 11:00:00	SPY	ETF	70.66	70.81	69.64	69.76	65065060.0
2009-03-03 12:00:00	SPY	ETF	69.76	70.8	69.74	70.19	51515193.0
2009-03-03 13:00:00	SPY	ETF	70.18	70.55	69.76	70.39	47049078.0
2009-03-03 14:00:00	SPY	ETF	70.39	71.45	70.34	71.26	75036965.0
2009-03-03 15:00:00	SPY	ETF	71.26	71.5	69.86	70.04	80550371.0
2009-03-03 16:00:00	SPY	ETF	70.05	71.299	68.76	69.08	12699054.0
2009-03-03 17:00:00	SPY	ETF	69.06	69.19	68.9	69.08	390632.0
2009-03-03 18:00:00	SPY	ETF	69.1	69.5	69.1	69.5	247430.0
2009-03-03 19:00:00	SPY	ETF	69.5	69.58	69.25	69.38	124238.0
2009-03-03 04:00:00	QQQ	ETF	26.95	26.95	26.95	26.95	100.0
2009-03-03 05:00:00	QQQ	ETF	26.82	26.82	26.82	26.82	100.0
2009-03-03 06:00:00	QQQ	ETF	26.82	26.82	26.75	26.77	10450.0
2009-03-03 07:00:00	QQQ	ETF	26.87	26.95	26.8	26.87	362613.0
2009-03-03 08:00:00	QQQ	ETF	27.05	27.05	26.84	27.0	2434191.0
2009-03-03 09:00:00	QQQ	ETF	27.0	27.0	26.75	26.81	13385654.0
2009-03-03 10:00:00	QQQ	ETF	26.8	26.9	26.64	26.7	22844629.0
2009-03-03 11:00:00	QQQ	ETF	26.69	26.74	26.42	26.48	19590904.0
2009-03-03 12:00:00	QQQ	ETF	26.49	26.84	26.47	26.629	13470122.0
2009-03-03 13:00:00	QQQ	ETF	26.62	26.82	26.54	26.78	17179797.0
2009-03-03 14:00:00	QQQ	ETF	26.77	27.16	26.75	27.045	29092645.0
2009-03-03 15:00:00	QQQ	ETF	27.05	27.05	26.62	26.62	30678850.0
2009-03-03 16:00:00	QQQ	ETF	26.62	26.9	26.17	26.28	5089332.0
2009-03-03 17:00:00	QQQ	ETF	26.3	26.32	26.22	26.25	277147.0
2009-03-03 18:00:00	QQQ	ETF	26.26	26.4	26.26	26.39	140739.0
2009-03-03 19:00:00	QQQ	ETF	26.39	26.44	26.31	26.33	122395.0
2009-03-03 06:00:00	IWM	ETF	37.08	37.08	37.08	37.08	100.0
2009-03-03 07:00:00	IWM	ETF	37.17	37.42	37.17	37.25	98402.0
2009-03-03 08:00:00	IWM	ETF	37.22	37.72	37.2	37.55	523065.0
2009-03-03 09:00:00	IWM	ETF	37.55	37.65	36.98	37.13	6944589.0
2009-03-03 10:00:00	IWM	ETF	37.12	37.16	36.57	36.63	9985236.0
2009-03-03 11:00:00	IWM	ETF	36.64	36.72	36.02	36.11	8771656.0
2009-03-03 12:00:00	IWM	ETF	36.11	36.7	36.102	36.33	6811632.0
2009-03-03 13:00:00	IWM	ETF	36.33	36.53	36.14	36.46	5697708.0
2009-03-03 14:00:00	IWM	ETF	36.45	36.99	36.41	36.855	9915060.0
2009-03-03 15:00:00	IWM	ETF	36.85	37.2	36.08	36.21	13604083.0
2009-03-03 16:00:00	IWM	ETF	36.2	36.808	35.51	35.63	3063062.0
2009-03-03 17:00:00	IWM	ETF	35.68	35.73	35.6	35.73	13849.0
2009-03-03 18:00:00	IWM	ETF	35.73	35.92	35.73	35.92	15499.0
2009-03-03 19:00:00	IWM	ETF	35.97	35.97	35.72	35.95	6600.0
2009-03-03 07:00:00	DIA	ETF	68.27	68.5	68.27	68.32	9375.0
2009-03-03 08:00:00	DIA	ETF	68.25	68.72	68.2	68.54	54042.0
2009-03-03 09:00:00	DIA	ETF	68.61	68.72	68.0	68.24	3312851.0
2009-03-03 10:00:00	DIA	ETF	68.23	68.4	67.7902	67.86	4698350.0

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

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