PREVIEW / etf_1hour / 2010-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-18.parquet
  size:    173 KB
  rows:    5,351

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-18 04:00:00	SPY	ETF	118.75	119.51	118.75	119.48	51258.0
2010-11-18 05:00:00	SPY	ETF	119.5	119.51	119.4	119.5	6150.0
2010-11-18 06:00:00	SPY	ETF	119.45	119.63	119.45	119.58	127744.0
2010-11-18 07:00:00	SPY	ETF	119.58	119.61	119.4	119.41	658939.0
2010-11-18 08:00:00	SPY	ETF	119.4	119.6	119.35	119.4	2453703.0
2010-11-18 09:00:00	SPY	ETF	119.4	119.77	119.33	119.53	24373776.0
2010-11-18 10:00:00	SPY	ETF	119.53	120.34	119.52	120.24	36226137.0
2010-11-18 11:00:00	SPY	ETF	120.25	120.36	120.08	120.1599	17231034.0
2010-11-18 12:00:00	SPY	ETF	120.1592	120.39	120.14	120.32	12086538.0
2010-11-18 13:00:00	SPY	ETF	120.32	120.33	120.16	120.17	8789095.0
2010-11-18 14:00:00	SPY	ETF	120.17	120.29	120.01	120.21	19334180.0
2010-11-18 15:00:00	SPY	ETF	120.21	120.27	119.85	119.97	32595670.0
2010-11-18 16:00:00	SPY	ETF	119.98	120.31	118.188	120.17	21572772.0
2010-11-18 17:00:00	SPY	ETF	120.16	120.3	120.1537	120.26	9329284.0
2010-11-18 18:00:00	SPY	ETF	120.26	120.44	120.26	120.43	309221.0
2010-11-18 19:00:00	SPY	ETF	120.42	120.42	120.26	120.3	88914.0
2010-11-18 04:00:00	QQQ	ETF	52.0	52.24	52.0	52.19	12238.0
2010-11-18 05:00:00	QQQ	ETF	52.19	52.2	52.19	52.2	4300.0
2010-11-18 06:00:00	QQQ	ETF	52.19	52.23	52.18	52.23	10975.0
2010-11-18 07:00:00	QQQ	ETF	52.21	52.22	52.14	52.16	187223.0
2010-11-18 08:00:00	QQQ	ETF	52.15	52.23	52.14	52.15	766164.0
2010-11-18 09:00:00	QQQ	ETF	52.16	52.37	52.13	52.3	9108236.0
2010-11-18 10:00:00	QQQ	ETF	52.29	52.68	52.29	52.64	13011218.0
2010-11-18 11:00:00	QQQ	ETF	52.65	52.7	52.56	52.69	6815705.0
2010-11-18 12:00:00	QQQ	ETF	52.69	52.79	52.68	52.72	3410146.0
2010-11-18 13:00:00	QQQ	ETF	52.725	52.73	52.63	52.63	4006750.0
2010-11-18 14:00:00	QQQ	ETF	52.64	52.68	52.51	52.6004	6050145.0
2010-11-18 15:00:00	QQQ	ETF	52.6025	52.64	52.42	52.42	10138010.0
2010-11-18 16:00:00	QQQ	ETF	52.43	52.58	52.39	52.49	3340442.0
2010-11-18 17:00:00	QQQ	ETF	52.5242	52.58	52.48	52.52	273017.0
2010-11-18 18:00:00	QQQ	ETF	52.53	52.59	52.53	52.59	23609.0
2010-11-18 19:00:00	QQQ	ETF	52.57	52.57	52.5	52.5	47523.0
2010-11-18 04:00:00	IWM	ETF	71.37	71.6	71.37	71.58	700.0
2010-11-18 06:00:00	IWM	ETF	71.7	71.73	71.7	71.73	3100.0
2010-11-18 07:00:00	IWM	ETF	71.78	71.8	71.69	71.71	20070.0
2010-11-18 08:00:00	IWM	ETF	71.69	71.81	71.69	71.74	978756.0
2010-11-18 09:00:00	IWM	ETF	71.74	72.11	71.66	71.9	7595033.0
2010-11-18 10:00:00	IWM	ETF	71.92	72.45	71.91	72.29	9850684.0
2010-11-18 11:00:00	IWM	ETF	72.29	72.42	72.2	72.355	3496768.0
2010-11-18 12:00:00	IWM	ETF	72.36	72.58	72.35	72.47	2465578.0
2010-11-18 13:00:00	IWM	ETF	72.47	72.5	72.38	72.39	1656792.0
2010-11-18 14:00:00	IWM	ETF	72.39	72.45	72.255	72.42	3267560.0
2010-11-18 15:00:00	IWM	ETF	72.43	72.51	71.97	72.21	9579367.0
2010-11-18 16:00:00	IWM	ETF	72.21	72.33	70.8534	72.28	5066012.0
2010-11-18 17:00:00	IWM	ETF	72.31	72.41	72.31	72.35	6550.0
2010-11-18 18:00:00	IWM	ETF	72.38	72.5	72.16	72.4	21969.0
2010-11-18 19:00:00	IWM	ETF	72.45	72.45	72.31	72.32	2800.0
2010-11-18 07:00:00	DIA	ETF	111.43	111.48	111.39	111.4	3500.0
2010-11-18 08:00:00	DIA	ETF	111.38	111.47	111.32	111.36	20827.0
2010-11-18 09:00:00	DIA	ETF	111.39	111.89	111.31	111.63	1016830.0

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

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