PREVIEW / etf_1hour / 2009-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-28.parquet
  size:    150 KB
  rows:    4,613

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-10-28 04:00:00	SPY	ETF	106.25	106.34	105.99	105.99	6822.0
2009-10-28 05:00:00	SPY	ETF	106.12	106.15	106.04	106.15	1058.0
2009-10-28 06:00:00	SPY	ETF	106.1	106.1	105.77	105.97	38149.0
2009-10-28 07:00:00	SPY	ETF	105.96	106.06	105.8	106.06	444414.0
2009-10-28 08:00:00	SPY	ETF	106.06	106.4	105.86	106.1342	2614083.0
2009-10-28 09:00:00	SPY	ETF	106.16	106.4783	105.85	105.99	29352128.0
2009-10-28 10:00:00	SPY	ETF	105.99	106.11	105.15	105.48	49725328.0
2009-10-28 11:00:00	SPY	ETF	105.47	105.74	105.28	105.41	25776103.0
2009-10-28 12:00:00	SPY	ETF	105.4	105.58	104.84	105.03	28619577.0
2009-10-28 13:00:00	SPY	ETF	105.04	105.63	104.95	105.21	22502071.0
2009-10-28 14:00:00	SPY	ETF	105.21	105.28	104.74	104.83	27293362.0
2009-10-28 15:00:00	SPY	ETF	104.83	105.01	104.35	104.42	47965902.0
2009-10-28 16:00:00	SPY	ETF	104.42	106.4798	104.25	104.26	9582614.0
2009-10-28 17:00:00	SPY	ETF	104.29	106.4798	104.25	104.28	1816113.0
2009-10-28 18:00:00	SPY	ETF	104.32	104.37	104.2	104.26	227089.0
2009-10-28 19:00:00	SPY	ETF	104.27	104.35	104.22	104.3	62985.0
2009-10-28 04:00:00	QQQ	ETF	42.25	42.32	42.23	42.23	10500.0
2009-10-28 05:00:00	QQQ	ETF	42.23	42.26	42.23	42.26	500.0
2009-10-28 06:00:00	QQQ	ETF	42.24	42.25	42.16	42.25	1850.0
2009-10-28 07:00:00	QQQ	ETF	42.24	42.28	42.19	42.27	18200.0
2009-10-28 08:00:00	QQQ	ETF	42.28	42.34	42.18	42.31	456458.0
2009-10-28 09:00:00	QQQ	ETF	42.32	42.32	41.56	42.17	21090769.0
2009-10-28 10:00:00	QQQ	ETF	42.18	42.22	41.7	41.85	31211085.0
2009-10-28 11:00:00	QQQ	ETF	41.85	41.95	41.75	41.825	12670345.0
2009-10-28 12:00:00	QQQ	ETF	41.82	41.89	41.54	41.6	13626269.0
2009-10-28 13:00:00	QQQ	ETF	41.605	41.85	41.56	41.69	10524854.0
2009-10-28 14:00:00	QQQ	ETF	41.69	41.7	41.46	41.55	13339379.0
2009-10-28 15:00:00	QQQ	ETF	41.55	41.62	41.3	41.4	29965967.0
2009-10-28 16:00:00	QQQ	ETF	41.4	41.4467	41.35	41.39	5868947.0
2009-10-28 17:00:00	QQQ	ETF	41.38	41.45	41.35	41.4	125099.0
2009-10-28 18:00:00	QQQ	ETF	41.4	41.41	41.34	41.35	118778.0
2009-10-28 19:00:00	QQQ	ETF	41.37	41.39	41.32	41.37	43542.0
2009-10-28 04:00:00	IWM	ETF	58.7	58.7	58.7	58.7	100.0
2009-10-28 06:00:00	IWM	ETF	58.38	58.41	58.38	58.41	300.0
2009-10-28 07:00:00	IWM	ETF	58.45	58.5	58.28	58.5	56265.0
2009-10-28 08:00:00	IWM	ETF	58.49	58.79	58.39	58.57	1319906.0
2009-10-28 09:00:00	IWM	ETF	58.58	58.8	58.31	58.47	11290696.0
2009-10-28 10:00:00	IWM	ETF	58.48	58.48	57.47	57.7	16633440.0
2009-10-28 11:00:00	IWM	ETF	57.7	57.91	57.531	57.71	6080762.0
2009-10-28 12:00:00	IWM	ETF	57.72	57.84	57.18	57.28	8500342.0
2009-10-28 13:00:00	IWM	ETF	57.2701	57.735	57.21	57.39	7654355.0
2009-10-28 14:00:00	IWM	ETF	57.39	57.44	56.91	56.94	11758906.0
2009-10-28 15:00:00	IWM	ETF	56.94	57.6	56.59	56.81	17625548.0
2009-10-28 16:00:00	IWM	ETF	56.82	58.6	56.75	56.76	3223555.0
2009-10-28 17:00:00	IWM	ETF	56.75	56.82	56.71	56.77	379542.0
2009-10-28 18:00:00	IWM	ETF	56.78	56.91	56.68	56.72	17633.0
2009-10-28 19:00:00	IWM	ETF	56.79	56.81	56.68	56.8	4100.0
2009-10-28 07:00:00	DIA	ETF	98.4	98.4	98.4	98.4	266.0
2009-10-28 08:00:00	DIA	ETF	98.52	98.68	98.2	98.67	73650.0
2009-10-28 09:00:00	DIA	ETF	98.6	99.07	98.38	98.7273	2296369.0

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

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