PREVIEW / etf_1hour / 2011-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-10.parquet
  size:    186 KB
  rows:    5,694

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
2011-03-10 04:00:00	SPY	ETF	131.0	131.39	131.0	131.29	8771.0
2011-03-10 05:00:00	SPY	ETF	131.37	131.37	131.16	131.25	29722.0
2011-03-10 06:00:00	SPY	ETF	131.33	131.39	131.19	131.39	66800.0
2011-03-10 07:00:00	SPY	ETF	131.36	131.66	131.25	131.47	2422970.0
2011-03-10 08:00:00	SPY	ETF	131.44	131.75	131.12	131.12	7440997.0
2011-03-10 09:00:00	SPY	ETF	131.12	131.21	130.11	130.39	45019130.0
2011-03-10 10:00:00	SPY	ETF	130.39	131.18	129.9	130.471	44905701.0
2011-03-10 11:00:00	SPY	ETF	130.47	130.86	130.29	130.81	28303598.0
2011-03-10 12:00:00	SPY	ETF	130.8	130.86	130.37	130.83	22735657.0
2011-03-10 13:00:00	SPY	ETF	130.83	130.97	129.81	130.16	47009846.0
2011-03-10 14:00:00	SPY	ETF	130.16	130.64	130.0645	130.38	24843659.0
2011-03-10 15:00:00	SPY	ETF	130.39	130.46	129.83	129.92	39766154.0
2011-03-10 16:00:00	SPY	ETF	129.93	132.4162	129.72	129.86	25628989.0
2011-03-10 17:00:00	SPY	ETF	129.89	130.04	129.72	129.77	10768806.0
2011-03-10 18:00:00	SPY	ETF	129.77	130.24	129.77	130.12	460917.0
2011-03-10 19:00:00	SPY	ETF	130.18	130.28	130.12	130.19	114365.0
2011-03-10 04:00:00	QQQ	ETF	56.7	56.7	56.36	56.41	1700.0
2011-03-10 05:00:00	QQQ	ETF	56.47	56.47	56.39	56.45	3900.0
2011-03-10 06:00:00	QQQ	ETF	56.46	56.47	56.37	56.45	10024.0
2011-03-10 07:00:00	QQQ	ETF	56.44	56.59	56.4	56.54	404962.0
2011-03-10 08:00:00	QQQ	ETF	56.52	56.65	56.38	56.4	2489703.0
2011-03-10 09:00:00	QQQ	ETF	56.39	56.44	56.0	56.1795	14723288.0
2011-03-10 10:00:00	QQQ	ETF	56.17	56.235	55.91	56.2	13975290.0
2011-03-10 11:00:00	QQQ	ETF	56.21	56.34	56.11	56.32	6849895.0
2011-03-10 12:00:00	QQQ	ETF	56.32	56.47	56.15	56.46	9706821.0
2011-03-10 13:00:00	QQQ	ETF	56.46	56.52	56.0	56.19	14421964.0
2011-03-10 14:00:00	QQQ	ETF	56.19	56.39	56.17	56.2799	5568639.0
2011-03-10 15:00:00	QQQ	ETF	56.28	56.32	56.02	56.14	12182773.0
2011-03-10 16:00:00	QQQ	ETF	56.15	56.2116	55.9967	56.15	2026057.0
2011-03-10 17:00:00	QQQ	ETF	56.13	56.17	56.09	56.09	36288.0
2011-03-10 18:00:00	QQQ	ETF	56.13	56.23	56.12	56.21	61921.0
2011-03-10 19:00:00	QQQ	ETF	56.2	56.25	56.2	56.21	53748.0
2011-03-10 05:00:00	IWM	ETF	81.05	81.05	81.05	81.05	100.0
2011-03-10 06:00:00	IWM	ETF	81.17	81.17	81.12	81.15	10680.0
2011-03-10 07:00:00	IWM	ETF	81.2	81.47	81.14	81.34	223885.0
2011-03-10 08:00:00	IWM	ETF	81.35	81.58	81.12	81.13	581690.0
2011-03-10 09:00:00	IWM	ETF	81.12	81.17	80.17	80.28	15601628.0
2011-03-10 10:00:00	IWM	ETF	80.29	80.34	79.6999	80.07	14963069.0
2011-03-10 11:00:00	IWM	ETF	80.07	80.36	79.94	80.31	9977310.0
2011-03-10 12:00:00	IWM	ETF	80.3	80.46	80.03	80.42	5690828.0
2011-03-10 13:00:00	IWM	ETF	80.41	80.6	79.85	80.08	11766324.0
2011-03-10 14:00:00	IWM	ETF	80.07	80.35	80.01	80.18	6612197.0
2011-03-10 15:00:00	IWM	ETF	80.19	80.28	79.79	79.95	16538623.0
2011-03-10 16:00:00	IWM	ETF	79.95	82.0725	79.77	79.85	5753052.0
2011-03-10 17:00:00	IWM	ETF	79.87	79.94	79.75	79.75	50081.0
2011-03-10 18:00:00	IWM	ETF	79.8	80.09	79.8	80.07	6635.0
2011-03-10 19:00:00	IWM	ETF	80.01	80.11	80.0	80.03	5200.0
2011-03-10 07:00:00	DIA	ETF	121.3	121.38	121.23	121.31	2300.0
2011-03-10 08:00:00	DIA	ETF	121.43	121.55	121.03	121.03	32401.0
2011-03-10 09:00:00	DIA	ETF	121.0	121.11	120.02	120.18	2264977.0

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

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