PREVIEW / etf_1hour / 2010-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-10.parquet
  size:    162 KB
  rows:    4,949

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-06-10 04:00:00	SPY	ETF	106.59	107.34	106.59	107.14	9990.0
2010-06-10 05:00:00	SPY	ETF	107.18	107.47	107.18	107.3	64900.0
2010-06-10 06:00:00	SPY	ETF	107.13	107.29	107.04	107.25	83330.0
2010-06-10 07:00:00	SPY	ETF	107.24	107.35	106.97	106.97	825081.0
2010-06-10 08:00:00	SPY	ETF	106.99	107.33	106.77	107.21	5703482.0
2010-06-10 09:00:00	SPY	ETF	107.21	108.62	107.11	108.58	47069996.0
2010-06-10 10:00:00	SPY	ETF	108.58	108.83	108.0	108.28	50545415.0
2010-06-10 11:00:00	SPY	ETF	108.28	108.6	108.07	108.28	28460174.0
2010-06-10 12:00:00	SPY	ETF	108.28	108.33	107.69	108.02	29482961.0
2010-06-10 13:00:00	SPY	ETF	108.02	108.48	107.7396	108.33	18800540.0
2010-06-10 14:00:00	SPY	ETF	108.33	108.87	108.02	108.665	29246828.0
2010-06-10 15:00:00	SPY	ETF	108.6686	109.28	108.56	109.19	66124856.0
2010-06-10 16:00:00	SPY	ETF	109.18	109.19	107.78	109.0	36306548.0
2010-06-10 17:00:00	SPY	ETF	109.01	109.08	108.96	109.04	138863.0
2010-06-10 18:00:00	SPY	ETF	109.05	109.19	108.92	108.96	129999.0
2010-06-10 19:00:00	SPY	ETF	108.96	108.99	108.91	108.99	66190.0
2010-06-10 04:00:00	QQQ	ETF	43.94	44.29	43.94	44.29	1378.0
2010-06-10 05:00:00	QQQ	ETF	44.26	44.36	44.26	44.33	2300.0
2010-06-10 06:00:00	QQQ	ETF	44.29	44.31	44.25	44.28	9604.0
2010-06-10 07:00:00	QQQ	ETF	44.27	44.36	44.13	44.15	278249.0
2010-06-10 08:00:00	QQQ	ETF	44.16	44.28	44.0	44.19	1542089.0
2010-06-10 09:00:00	QQQ	ETF	44.19	44.72	44.15	44.68	14484208.0
2010-06-10 10:00:00	QQQ	ETF	44.68	44.81	44.5	44.66	11494071.0
2010-06-10 11:00:00	QQQ	ETF	44.66	44.7902	44.49	44.63	6930599.0
2010-06-10 12:00:00	QQQ	ETF	44.63	44.66	44.38	44.5	7421510.0
2010-06-10 13:00:00	QQQ	ETF	44.5	44.72	44.4	44.68	7161295.0
2010-06-10 14:00:00	QQQ	ETF	44.68	45.0	44.54	44.9	6822937.0
2010-06-10 15:00:00	QQQ	ETF	44.9099	45.12	44.85	45.08	16392209.0
2010-06-10 16:00:00	QQQ	ETF	45.07	45.08	43.8176	44.9	3226845.0
2010-06-10 17:00:00	QQQ	ETF	44.9	44.94	44.89	44.9	58696.0
2010-06-10 18:00:00	QQQ	ETF	44.91	44.96	44.9	44.9	94741.0
2010-06-10 19:00:00	QQQ	ETF	44.91	44.94	44.9	44.94	52601.0
2010-06-10 04:00:00	IWM	ETF	62.52	62.82	62.52	62.82	200.0
2010-06-10 06:00:00	IWM	ETF	62.8	62.8	62.8	62.8	500.0
2010-06-10 07:00:00	IWM	ETF	62.84	62.87	62.65	62.68	120741.0
2010-06-10 08:00:00	IWM	ETF	62.64	62.91	62.29	62.72	643971.0
2010-06-10 09:00:00	IWM	ETF	62.74	63.45	62.68	63.44	11829233.0
2010-06-10 10:00:00	IWM	ETF	63.43	63.57	62.99	63.2674	8652033.0
2010-06-10 11:00:00	IWM	ETF	63.27	63.57	63.19	63.39	6025133.0
2010-06-10 12:00:00	IWM	ETF	63.39	63.41	62.8	63.01	8110793.0
2010-06-10 13:00:00	IWM	ETF	63.0	63.35	62.8	63.22	5544881.0
2010-06-10 14:00:00	IWM	ETF	63.23	63.83	63.02	63.61	9134334.0
2010-06-10 15:00:00	IWM	ETF	63.6	64.08	63.53	64.07	18687229.0
2010-06-10 16:00:00	IWM	ETF	64.07	64.07	63.6231	63.89	3941050.0
2010-06-10 17:00:00	IWM	ETF	63.86	64.05	63.85	63.9	4083.0
2010-06-10 18:00:00	IWM	ETF	63.89	63.92	63.86	63.87	26501.0
2010-06-10 19:00:00	IWM	ETF	63.9	63.98	63.87	63.9	6921.0
2010-06-10 04:00:00	DIA	ETF	99.7	100.07	99.7	100.07	5500.0
2010-06-10 05:00:00	DIA	ETF	100.07	100.23	100.07	100.23	2000.0
2010-06-10 07:00:00	DIA	ETF	100.09	100.12	99.9	99.9	25630.0

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

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