PREVIEW / etf_1hour / 2010-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-04.parquet
  size:    178 KB
  rows:    5,473

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-04 04:00:00	SPY	ETF	120.32	120.8	120.32	120.8	41950.0
2010-11-04 05:00:00	SPY	ETF	120.81	120.95	120.81	120.91	73800.0
2010-11-04 06:00:00	SPY	ETF	120.89	121.05	120.89	120.95	66390.0
2010-11-04 07:00:00	SPY	ETF	120.95	121.03	120.86	121.03	1120002.0
2010-11-04 08:00:00	SPY	ETF	121.02	121.4	120.94	121.3	5907858.0
2010-11-04 09:00:00	SPY	ETF	121.31	121.52	121.13	121.42	25729466.0
2010-11-04 10:00:00	SPY	ETF	121.41	121.83	121.16	121.78	36091804.0
2010-11-04 11:00:00	SPY	ETF	121.79	121.96	121.63	121.67	22098266.0
2010-11-04 12:00:00	SPY	ETF	121.66	121.86	121.57	121.82	19065572.0
2010-11-04 13:00:00	SPY	ETF	121.82	121.93	121.68	121.71	14496380.0
2010-11-04 14:00:00	SPY	ETF	121.72	122.01	121.63	121.84	22240668.0
2010-11-04 15:00:00	SPY	ETF	121.84	122.32	121.83	122.24	54383015.0
2010-11-04 16:00:00	SPY	ETF	122.23	122.35	121.175	122.22	10549330.0
2010-11-04 17:00:00	SPY	ETF	122.23	122.29	122.18	122.24	432167.0
2010-11-04 18:00:00	SPY	ETF	122.24	122.29	122.2	122.22	263816.0
2010-11-04 19:00:00	SPY	ETF	122.2	122.29	122.2	122.28	203632.0
2010-11-04 04:00:00	QQQ	ETF	53.34	53.45	53.34	53.45	1450.0
2010-11-04 05:00:00	QQQ	ETF	53.44	53.51	53.44	53.5	11900.0
2010-11-04 06:00:00	QQQ	ETF	53.5	53.53	53.5	53.53	7000.0
2010-11-04 07:00:00	QQQ	ETF	53.49	53.58	53.49	53.56	91178.0
2010-11-04 08:00:00	QQQ	ETF	53.57	53.69	53.54	53.68	1170763.0
2010-11-04 09:00:00	QQQ	ETF	53.68	53.78	53.6	53.65	13358883.0
2010-11-04 10:00:00	QQQ	ETF	53.65	53.82	53.5	53.8	10462739.0
2010-11-04 11:00:00	QQQ	ETF	53.805	53.8614	53.66	53.67	5930441.0
2010-11-04 12:00:00	QQQ	ETF	53.67	53.75	53.64	53.71	3754364.0
2010-11-04 13:00:00	QQQ	ETF	53.71	53.78	53.61	53.61	5252357.0
2010-11-04 14:00:00	QQQ	ETF	53.61	53.76	53.58	53.655	5671464.0
2010-11-04 15:00:00	QQQ	ETF	53.65	53.73	53.58	53.69	14913950.0
2010-11-04 16:00:00	QQQ	ETF	53.68	53.74	53.6164	53.67	2622569.0
2010-11-04 17:00:00	QQQ	ETF	53.65	53.72	53.64	53.67	116828.0
2010-11-04 18:00:00	QQQ	ETF	53.67	53.7	53.64	53.64	41444.0
2010-11-04 19:00:00	QQQ	ETF	53.68	53.69	53.65	53.66	19937.0
2010-11-04 07:00:00	IWM	ETF	72.31	72.44	72.3	72.44	69939.0
2010-11-04 08:00:00	IWM	ETF	72.43	72.82	72.41	72.76	909217.0
2010-11-04 09:00:00	IWM	ETF	72.76	73.0402	72.67	72.9	9550773.0
2010-11-04 10:00:00	IWM	ETF	72.908	73.13	72.62	73.12	8373551.0
2010-11-04 11:00:00	IWM	ETF	73.11	73.27	72.9	72.93	8082922.0
2010-11-04 12:00:00	IWM	ETF	72.92	73.11	72.9	73.11	4561093.0
2010-11-04 13:00:00	IWM	ETF	73.12	73.19	72.9199	72.94	3408334.0
2010-11-04 14:00:00	IWM	ETF	72.94	73.22	72.86	73.105	3458794.0
2010-11-04 15:00:00	IWM	ETF	73.11	73.38	73.1	73.36	12303689.0
2010-11-04 16:00:00	IWM	ETF	73.36	73.41	71.5512	73.32	2952711.0
2010-11-04 17:00:00	IWM	ETF	73.3	73.3	73.28	73.29	11491.0
2010-11-04 18:00:00	IWM	ETF	73.31	73.37	73.31	73.34	39414.0
2010-11-04 19:00:00	IWM	ETF	73.3	73.37	73.3	73.34	2585.0
2010-11-04 07:00:00	DIA	ETF	113.01	113.02	112.93	113.02	3050.0
2010-11-04 08:00:00	DIA	ETF	113.01	113.4	113.0	113.35	86283.0
2010-11-04 09:00:00	DIA	ETF	113.32	113.7	113.21	113.6901	1720261.0
2010-11-04 10:00:00	DIA	ETF	113.695	114.23	113.5	114.2078	2359009.0
2010-11-04 11:00:00	DIA	ETF	114.21	114.41	114.05	114.09	1441733.0

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

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