PREVIEW / etf_1hour / 2010-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-15.parquet
  size:    172 KB
  rows:    5,264

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-11-15 04:00:00	SPY	ETF	120.1	120.1	119.85	120.0	2800.0
2010-11-15 05:00:00	SPY	ETF	120.21	120.21	120.21	120.21	472.0
2010-11-15 06:00:00	SPY	ETF	120.2	120.38	120.2	120.35	32944.0
2010-11-15 07:00:00	SPY	ETF	120.36	120.64	120.32	120.6	669675.0
2010-11-15 08:00:00	SPY	ETF	120.59	120.72	116.71	120.54	2733234.0
2010-11-15 09:00:00	SPY	ETF	120.54	120.82	120.44	120.47	21149030.0
2010-11-15 10:00:00	SPY	ETF	120.46	120.72	120.23	120.56	23147489.0
2010-11-15 11:00:00	SPY	ETF	120.57	121.05	120.4	120.95	19566248.0
2010-11-15 12:00:00	SPY	ETF	120.94	121.04	120.66	120.9	14711065.0
2010-11-15 13:00:00	SPY	ETF	120.9	121.02	120.71	120.84	11250686.0
2010-11-15 14:00:00	SPY	ETF	120.84	120.93	120.44	120.66	18975562.0
2010-11-15 15:00:00	SPY	ETF	120.66	120.67	119.98	120.03	36782095.0
2010-11-15 16:00:00	SPY	ETF	120.02	120.985	119.83	119.95	12788386.0
2010-11-15 17:00:00	SPY	ETF	119.93	119.95	119.74	119.85	638641.0
2010-11-15 18:00:00	SPY	ETF	119.85	120.04	119.85	119.85	108315.0
2010-11-15 19:00:00	SPY	ETF	119.88	119.93	119.54	119.64	201166.0
2010-11-15 04:00:00	QQQ	ETF	52.55	52.55	52.5	52.5	10100.0
2010-11-15 06:00:00	QQQ	ETF	52.69	52.7	52.69	52.7	20500.0
2010-11-15 07:00:00	QQQ	ETF	52.71	52.83	52.71	52.83	101898.0
2010-11-15 08:00:00	QQQ	ETF	52.81	52.85	52.7	52.78	710285.0
2010-11-15 09:00:00	QQQ	ETF	52.79	52.88	52.48	52.49	9205013.0
2010-11-15 10:00:00	QQQ	ETF	52.4962	52.61	52.36	52.55	10610825.0
2010-11-15 11:00:00	QQQ	ETF	52.55	52.68	52.39	52.64	6892410.0
2010-11-15 12:00:00	QQQ	ETF	52.64	52.68	52.51	52.665	3054676.0
2010-11-15 13:00:00	QQQ	ETF	52.66	52.73	52.57	52.66	2962818.0
2010-11-15 14:00:00	QQQ	ETF	52.66	52.69	52.49	52.59	4034675.0
2010-11-15 15:00:00	QQQ	ETF	52.59	52.6	52.29	52.32	13676773.0
2010-11-15 16:00:00	QQQ	ETF	52.32	52.42	52.19	52.24	3905507.0
2010-11-15 17:00:00	QQQ	ETF	52.24	52.27	52.2	52.26	58734.0
2010-11-15 18:00:00	QQQ	ETF	52.23	52.27	52.21	52.23	31000.0
2010-11-15 19:00:00	QQQ	ETF	52.27	52.27	51.98	52.09	201705.0
2010-11-15 07:00:00	IWM	ETF	72.25	72.42	72.22	72.38	85800.0
2010-11-15 08:00:00	IWM	ETF	72.37	72.49	72.23	72.39	387180.0
2010-11-15 09:00:00	IWM	ETF	72.38	72.64	72.1	72.13	4702268.0
2010-11-15 10:00:00	IWM	ETF	72.14	72.4	72.02	72.34	5342255.0
2010-11-15 11:00:00	IWM	ETF	72.34	72.83	72.2	72.77	4861813.0
2010-11-15 12:00:00	IWM	ETF	72.77	72.85	72.32	72.71	3235528.0
2010-11-15 13:00:00	IWM	ETF	72.71	72.77	72.58	72.65	1846423.0
2010-11-15 14:00:00	IWM	ETF	72.65	72.72	72.412	72.64	3164533.0
2010-11-15 15:00:00	IWM	ETF	72.64	72.65	71.97	72.05	11239236.0
2010-11-15 16:00:00	IWM	ETF	72.05	72.7152	71.95	72.01	1577744.0
2010-11-15 17:00:00	IWM	ETF	72.01	72.01	71.93	72.0	8900.0
2010-11-15 18:00:00	IWM	ETF	71.7	71.98	71.7	71.8	2806.0
2010-11-15 19:00:00	IWM	ETF	72.0	72.0	71.84	71.95	26808.0
2010-11-15 07:00:00	DIA	ETF	112.35	112.49	112.32	112.49	41300.0
2010-11-15 08:00:00	DIA	ETF	112.41	112.48	112.27	112.35	10387.0
2010-11-15 09:00:00	DIA	ETF	112.37	112.6599	112.31	112.46	1382227.0
2010-11-15 10:00:00	DIA	ETF	112.4227	112.72	112.2499	112.6	1360252.0
2010-11-15 11:00:00	DIA	ETF	112.5905	112.96	112.45	112.9	632696.0
2010-11-15 12:00:00	DIA	ETF	112.89	112.97	112.7	112.92	554055.0

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

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