PREVIEW / etf_1hour / 2010-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-21.parquet
  size:    156 KB
  rows:    4,793

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-07-21 04:00:00	SPY	ETF	108.68	108.87	108.68	108.8	3250.0
2010-07-21 05:00:00	SPY	ETF	108.98	108.98	108.83	108.83	1700.0
2010-07-21 06:00:00	SPY	ETF	108.95	108.95	108.68	108.73	12158.0
2010-07-21 07:00:00	SPY	ETF	108.81	108.92	108.71	108.81	1209238.0
2010-07-21 08:00:00	SPY	ETF	108.8	109.28	108.7166	109.25	4572439.0
2010-07-21 09:00:00	SPY	ETF	109.26	109.26	108.23	108.44	27670691.0
2010-07-21 10:00:00	SPY	ETF	108.44	108.7	108.2	108.43	25787346.0
2010-07-21 11:00:00	SPY	ETF	108.43	108.4601	107.96	108.38	26710647.0
2010-07-21 12:00:00	SPY	ETF	108.38	108.8	108.28	108.33	18147915.0
2010-07-21 13:00:00	SPY	ETF	108.32	108.68	108.29	108.45	8671401.0
2010-07-21 14:00:00	SPY	ETF	108.45	108.53	106.63	106.77	70396922.0
2010-07-21 15:00:00	SPY	ETF	106.76	107.4	106.66	107.1	61802845.0
2010-07-21 16:00:00	SPY	ETF	107.09	108.935	106.78	106.8	12352403.0
2010-07-21 17:00:00	SPY	ETF	106.82	106.94	106.77	106.8	270312.0
2010-07-21 18:00:00	SPY	ETF	106.82	107.07	106.78	106.92	109122.0
2010-07-21 19:00:00	SPY	ETF	106.95	107.03	106.93	107.02	78784.0
2010-07-21 04:00:00	QQQ	ETF	45.3	45.51	45.3	45.49	1200.0
2010-07-21 05:00:00	QQQ	ETF	45.54	45.54	45.54	45.54	100.0
2010-07-21 06:00:00	QQQ	ETF	45.52	45.52	45.48	45.48	6500.0
2010-07-21 07:00:00	QQQ	ETF	45.56	45.58	45.5	45.57	254181.0
2010-07-21 08:00:00	QQQ	ETF	45.56	45.73	45.56	45.72	778660.0
2010-07-21 09:00:00	QQQ	ETF	45.72	45.76	45.02	45.16	18587205.0
2010-07-21 10:00:00	QQQ	ETF	45.16	45.27	45.0	45.16	10960643.0
2010-07-21 11:00:00	QQQ	ETF	45.17	45.22	44.96	45.22	8437228.0
2010-07-21 12:00:00	QQQ	ETF	45.21	45.38	45.2	45.25	5435828.0
2010-07-21 13:00:00	QQQ	ETF	45.24	45.43	45.2299	45.31	3740669.0
2010-07-21 14:00:00	QQQ	ETF	45.3	45.33	44.59	44.64	17745204.0
2010-07-21 15:00:00	QQQ	ETF	44.64	44.88	44.56	44.65	14019448.0
2010-07-21 16:00:00	QQQ	ETF	44.64	44.76	44.63	44.65	2162030.0
2010-07-21 17:00:00	QQQ	ETF	44.66	44.7	44.62	44.65	30291.0
2010-07-21 18:00:00	QQQ	ETF	44.65	44.72	44.62	44.68	20212.0
2010-07-21 19:00:00	QQQ	ETF	44.7	44.72	44.68	44.72	153078.0
2010-07-21 07:00:00	IWM	ETF	62.6	62.66	62.53	62.56	29402.0
2010-07-21 08:00:00	IWM	ETF	62.56	62.98	62.56	62.88	502611.0
2010-07-21 09:00:00	IWM	ETF	62.88	62.97	62.1	62.26	7741698.0
2010-07-21 10:00:00	IWM	ETF	62.26	62.53	62.02	62.28	7239064.0
2010-07-21 11:00:00	IWM	ETF	62.28	62.29	61.825	62.16	5140975.0
2010-07-21 12:00:00	IWM	ETF	62.16	62.5799	62.13	62.27	4937907.0
2010-07-21 13:00:00	IWM	ETF	62.265	62.6	62.24	62.4	2378507.0
2010-07-21 14:00:00	IWM	ETF	62.4	62.42	61.14	61.22	15320825.0
2010-07-21 15:00:00	IWM	ETF	61.22	62.4	61.1	61.27	13791526.0
2010-07-21 16:00:00	IWM	ETF	61.26	62.4143	61.2	61.2	5287912.0
2010-07-21 17:00:00	IWM	ETF	61.19	61.26	61.18	61.19	7440.0
2010-07-21 18:00:00	IWM	ETF	61.16	61.34	61.16	61.3	2100.0
2010-07-21 19:00:00	IWM	ETF	61.3	61.33	61.27	61.28	3832.0
2010-07-21 07:00:00	DIA	ETF	102.52	102.52	102.52	102.52	1300.0
2010-07-21 08:00:00	DIA	ETF	102.55	102.8	102.55	102.79	38050.0
2010-07-21 09:00:00	DIA	ETF	102.8	102.8	102.16	102.3599	1280831.0
2010-07-21 10:00:00	DIA	ETF	102.36	102.6	102.16	102.42	1059183.0
2010-07-21 11:00:00	DIA	ETF	102.42	102.43	102.05	102.34	890641.0

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

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