PREVIEW / etf_1hour / 2010-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-13.parquet
  size:    158 KB
  rows:    4,837

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-04-13 04:00:00	SPY	ETF	119.51	119.51	119.39	119.39	1130.0
2010-04-13 05:00:00	SPY	ETF	119.36	119.45	119.32	119.45	26986.0
2010-04-13 06:00:00	SPY	ETF	119.49	119.53	119.48	119.53	12800.0
2010-04-13 07:00:00	SPY	ETF	119.48	119.48	119.38	119.46	808535.0
2010-04-13 08:00:00	SPY	ETF	119.45	119.74	119.2	119.7	1515019.0
2010-04-13 09:00:00	SPY	ETF	119.7	119.73	119.42	119.55	16551111.0
2010-04-13 10:00:00	SPY	ETF	119.55	119.63	119.0	119.22	31348874.0
2010-04-13 11:00:00	SPY	ETF	119.23	119.37	119.14	119.31	10223339.0
2010-04-13 12:00:00	SPY	ETF	119.31	119.61	119.24	119.5799	11736891.0
2010-04-13 13:00:00	SPY	ETF	119.5701	119.83	119.55	119.79	13172993.0
2010-04-13 14:00:00	SPY	ETF	119.79	119.83	119.64	119.72	10827824.0
2010-04-13 15:00:00	SPY	ETF	119.72	120.04	119.675	119.87	21722251.0
2010-04-13 16:00:00	SPY	ETF	119.86	120.25	119.23	120.03	6422458.0
2010-04-13 17:00:00	SPY	ETF	120.04	120.1	120.03	120.06	149644.0
2010-04-13 18:00:00	SPY	ETF	120.06	120.06	119.95	119.96	111896.0
2010-04-13 19:00:00	SPY	ETF	119.97	120.02	119.97	120.02	47491.0
2010-04-13 04:00:00	QQQ	ETF	48.93	48.93	48.93	48.93	200.0
2010-04-13 06:00:00	QQQ	ETF	48.95	48.95	48.95	48.95	4400.0
2010-04-13 07:00:00	QQQ	ETF	48.93	48.95	48.92	48.94	70700.0
2010-04-13 08:00:00	QQQ	ETF	48.94	49.04	48.94	49.03	198930.0
2010-04-13 09:00:00	QQQ	ETF	49.03	49.21	48.97	49.12	6773535.0
2010-04-13 10:00:00	QQQ	ETF	49.12	49.16	48.86	48.99	12796485.0
2010-04-13 11:00:00	QQQ	ETF	49.0	49.1	48.934	49.06	6173020.0
2010-04-13 12:00:00	QQQ	ETF	49.06	49.17	49.01	49.151	6566994.0
2010-04-13 13:00:00	QQQ	ETF	49.15	49.31	49.1	49.3	5833527.0
2010-04-13 14:00:00	QQQ	ETF	49.3	49.305	49.23	49.25	4431974.0
2010-04-13 15:00:00	QQQ	ETF	49.25	49.35	49.23	49.3	7479171.0
2010-04-13 16:00:00	QQQ	ETF	49.3	49.67	48.934	49.45	6665385.0
2010-04-13 17:00:00	QQQ	ETF	49.45	49.54	49.45	49.51	576667.0
2010-04-13 18:00:00	QQQ	ETF	49.51	49.51	49.47	49.49	342065.0
2010-04-13 19:00:00	QQQ	ETF	49.49	49.51	49.48	49.5	90780.0
2010-04-13 06:00:00	IWM	ETF	70.23	70.23	70.23	70.23	100.0
2010-04-13 07:00:00	IWM	ETF	70.22	70.24	70.2	70.24	45474.0
2010-04-13 08:00:00	IWM	ETF	70.25	70.4	70.22	70.36	352549.0
2010-04-13 09:00:00	IWM	ETF	70.35	70.5	70.23	70.36	4498918.0
2010-04-13 10:00:00	IWM	ETF	70.35	70.44	69.94	70.12	7842543.0
2010-04-13 11:00:00	IWM	ETF	70.13	70.39	70.09	70.31	5553539.0
2010-04-13 12:00:00	IWM	ETF	70.31	70.48	70.24	70.42	3783390.0
2010-04-13 13:00:00	IWM	ETF	70.42	70.65	70.4	70.62	2884714.0
2010-04-13 14:00:00	IWM	ETF	70.62	70.66	70.5	70.54	4788949.0
2010-04-13 15:00:00	IWM	ETF	70.54	70.74	70.49	70.7	6692017.0
2010-04-13 16:00:00	IWM	ETF	70.7	70.9	70.5007	70.85	4848149.0
2010-04-13 17:00:00	IWM	ETF	70.39	70.89	70.39	70.87	28386.0
2010-04-13 18:00:00	IWM	ETF	70.88	70.99	70.88	70.98	4597.0
2010-04-13 19:00:00	IWM	ETF	71.01	71.01	70.87	70.88	13512.0
2010-04-13 07:00:00	DIA	ETF	109.9	109.96	109.9	109.96	1000.0
2010-04-13 08:00:00	DIA	ETF	109.91	110.08	109.91	110.08	6100.0
2010-04-13 09:00:00	DIA	ETF	110.05	110.2	109.9	110.09	510761.0
2010-04-13 10:00:00	DIA	ETF	110.08	110.12	109.53	109.78	1956313.0
2010-04-13 11:00:00	DIA	ETF	109.77	110.06	109.77	110.02	497226.0

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

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