PREVIEW / etf_1hour / 2010-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-27.parquet
  size:    170 KB
  rows:    5,188

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-05-27 04:00:00	SPY	ETF	108.62	108.8	108.44	108.75	69239.0
2010-05-27 05:00:00	SPY	ETF	108.81	109.46	108.81	109.46	106149.0
2010-05-27 06:00:00	SPY	ETF	109.42	109.65	109.19	109.26	475021.0
2010-05-27 07:00:00	SPY	ETF	109.25	109.29	108.95	109.04	2580299.0
2010-05-27 08:00:00	SPY	ETF	109.04	109.6	106.97	108.84	6818449.0
2010-05-27 09:00:00	SPY	ETF	108.83	109.44	108.77	109.13	38487517.0
2010-05-27 10:00:00	SPY	ETF	109.13	109.98	108.7801	109.6917	49343942.0
2010-05-27 11:00:00	SPY	ETF	109.69	109.9	109.38	109.845	32281045.0
2010-05-27 12:00:00	SPY	ETF	109.84	109.87	109.35	109.59	21208366.0
2010-05-27 13:00:00	SPY	ETF	109.59	109.97	109.26	109.71	25658593.0
2010-05-27 14:00:00	SPY	ETF	109.71	110.27	109.66	109.97	26104699.0
2010-05-27 15:00:00	SPY	ETF	109.97	110.8	109.82	110.78	59164037.0
2010-05-27 16:00:00	SPY	ETF	110.77	110.79	108.99	110.63	35131187.0
2010-05-27 17:00:00	SPY	ETF	110.76	110.76	106.8	110.68	623436.0
2010-05-27 18:00:00	SPY	ETF	110.67	110.9	110.59	110.59	356010.0
2010-05-27 19:00:00	SPY	ETF	110.6	110.78	110.56	110.7	139280.0
2010-05-27 04:00:00	QQQ	ETF	44.93	45.02	44.85	45.02	9266.0
2010-05-27 05:00:00	QQQ	ETF	45.05	45.3	45.05	45.3	10011.0
2010-05-27 06:00:00	QQQ	ETF	45.28	45.35	45.18	45.18	104358.0
2010-05-27 07:00:00	QQQ	ETF	45.16	45.2	45.04	45.08	1138097.0
2010-05-27 08:00:00	QQQ	ETF	45.08	45.22	44.93	45.05	4772629.0
2010-05-27 09:00:00	QQQ	ETF	45.05	45.37	45.02	45.22	16465503.0
2010-05-27 10:00:00	QQQ	ETF	45.21	45.55	45.1	45.37	22114261.0
2010-05-27 11:00:00	QQQ	ETF	45.37	45.5	45.28	45.46	12665201.0
2010-05-27 12:00:00	QQQ	ETF	45.46	45.5	45.38	45.43	11742477.0
2010-05-27 13:00:00	QQQ	ETF	45.43	45.62	45.34	45.52	10203110.0
2010-05-27 14:00:00	QQQ	ETF	45.51	45.72	45.49	45.6	8701928.0
2010-05-27 15:00:00	QQQ	ETF	45.6	45.89	45.54	45.87	15347704.0
2010-05-27 16:00:00	QQQ	ETF	45.87	45.93	45.4341	45.89	5226107.0
2010-05-27 17:00:00	QQQ	ETF	45.88	46.05	45.87	45.97	104585.0
2010-05-27 18:00:00	QQQ	ETF	45.93	46.02	45.86	45.91	130594.0
2010-05-27 19:00:00	QQQ	ETF	45.91	45.95	45.9	45.91	40983.0
2010-05-27 04:00:00	IWM	ETF	65.38	65.39	65.38	65.39	694.0
2010-05-27 05:00:00	IWM	ETF	65.55	65.8	65.55	65.8	800.0
2010-05-27 06:00:00	IWM	ETF	65.99	65.99	65.72	65.76	42007.0
2010-05-27 07:00:00	IWM	ETF	65.78	65.8	65.63	65.68	401657.0
2010-05-27 08:00:00	IWM	ETF	65.66	65.83	65.47	65.79	1350107.0
2010-05-27 09:00:00	IWM	ETF	65.78	66.2	65.45	65.66	12395343.0
2010-05-27 10:00:00	IWM	ETF	65.65	66.29	65.43	65.9	13603735.0
2010-05-27 11:00:00	IWM	ETF	65.9	66.11	65.76	66.1	7417634.0
2010-05-27 12:00:00	IWM	ETF	66.1	66.37	66.01	66.18	6494669.0
2010-05-27 13:00:00	IWM	ETF	66.19	66.44	65.93	66.25	7849520.0
2010-05-27 14:00:00	IWM	ETF	66.25	66.63	66.0	66.555	6985038.0
2010-05-27 15:00:00	IWM	ETF	66.55	67.14	66.46	67.11	16150796.0
2010-05-27 16:00:00	IWM	ETF	67.12	67.13	64.345	66.97	7458157.0
2010-05-27 17:00:00	IWM	ETF	66.99	67.05	66.92	66.99	13004.0
2010-05-27 18:00:00	IWM	ETF	66.99	67.07	66.98	67.0	8716.0
2010-05-27 19:00:00	IWM	ETF	67.04	67.09	66.98	67.0	9616.0
2010-05-27 07:00:00	DIA	ETF	101.38	101.38	101.24	101.24	6400.0
2010-05-27 08:00:00	DIA	ETF	101.19	101.37	100.86	101.0	124728.0

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

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