PREVIEW / etf_1hour / 2010-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-30.parquet
  size:    150 KB
  rows:    4,679

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-03-30 04:00:00	SPY	ETF	117.52	117.53	117.41	117.41	800.0
2010-03-30 05:00:00	SPY	ETF	117.36	117.36	117.35	117.35	2222.0
2010-03-30 06:00:00	SPY	ETF	117.35	117.49	117.35	117.49	10100.0
2010-03-30 07:00:00	SPY	ETF	117.52	117.62	117.5	117.56	140625.0
2010-03-30 08:00:00	SPY	ETF	117.54	117.63	117.36	117.4	1518701.0
2010-03-30 09:00:00	SPY	ETF	117.39	117.8	117.32	117.75	21085032.0
2010-03-30 10:00:00	SPY	ETF	117.75	117.83	117.38	117.48	27848022.0
2010-03-30 11:00:00	SPY	ETF	117.47	117.5	116.91	117.22	25471226.0
2010-03-30 12:00:00	SPY	ETF	117.22	117.41	117.16	117.3565	16701381.0
2010-03-30 13:00:00	SPY	ETF	117.35	117.352	117.07	117.2291	12156017.0
2010-03-30 14:00:00	SPY	ETF	117.2285	117.55	117.1	117.44	11545838.0
2010-03-30 15:00:00	SPY	ETF	117.44	117.57	117.32	117.37	19332702.0
2010-03-30 16:00:00	SPY	ETF	117.38	117.7	116.99	117.34	6124434.0
2010-03-30 17:00:00	SPY	ETF	117.32	117.42	117.32	117.36	203725.0
2010-03-30 18:00:00	SPY	ETF	117.34	117.34	117.3	117.33	17924.0
2010-03-30 19:00:00	SPY	ETF	117.35	117.42	117.33	117.42	72890.0
2010-03-30 04:00:00	QQQ	ETF	48.36	48.36	48.36	48.36	1000.0
2010-03-30 07:00:00	QQQ	ETF	48.39	48.41	48.37	48.38	30805.0
2010-03-30 08:00:00	QQQ	ETF	48.38	48.43	48.31	48.33	201411.0
2010-03-30 09:00:00	QQQ	ETF	48.33	48.5369	48.31	48.5	8806321.0
2010-03-30 10:00:00	QQQ	ETF	48.51	48.55	48.26	48.3301	11101594.0
2010-03-30 11:00:00	QQQ	ETF	48.32	48.33	48.06	48.25	7906938.0
2010-03-30 12:00:00	QQQ	ETF	48.25	48.35	48.24	48.32	3497979.0
2010-03-30 13:00:00	QQQ	ETF	48.32	48.33	48.21	48.2899	4087336.0
2010-03-30 14:00:00	QQQ	ETF	48.28	48.41	48.26	48.38	2817483.0
2010-03-30 15:00:00	QQQ	ETF	48.3701	48.46	48.36	48.38	8040434.0
2010-03-30 16:00:00	QQQ	ETF	48.39	48.4861	48.33	48.33	2573887.0
2010-03-30 17:00:00	QQQ	ETF	48.36	48.39	48.33	48.35	11086.0
2010-03-30 18:00:00	QQQ	ETF	48.35	48.35	48.33	48.33	12100.0
2010-03-30 19:00:00	QQQ	ETF	48.34	48.36	48.34	48.36	5800.0
2010-03-30 06:00:00	IWM	ETF	68.4	68.4	68.4	68.4	25000.0
2010-03-30 07:00:00	IWM	ETF	68.38	68.38	68.34	68.38	2300.0
2010-03-30 08:00:00	IWM	ETF	68.34	68.38	68.21	68.26	85186.0
2010-03-30 09:00:00	IWM	ETF	68.29	68.735	68.25	68.62	4926565.0
2010-03-30 10:00:00	IWM	ETF	68.63	68.7	68.395	68.53	4889334.0
2010-03-30 11:00:00	IWM	ETF	68.52	68.525	67.87	68.06	6797768.0
2010-03-30 12:00:00	IWM	ETF	68.05	68.2	67.97	68.15	2143232.0
2010-03-30 13:00:00	IWM	ETF	68.15	68.18	67.93	68.148	3475705.0
2010-03-30 14:00:00	IWM	ETF	68.14	68.52	68.06	68.44	3530279.0
2010-03-30 15:00:00	IWM	ETF	68.44	68.48	68.27	68.39	5351106.0
2010-03-30 16:00:00	IWM	ETF	68.4	68.44	68.1	68.31	2345572.0
2010-03-30 17:00:00	IWM	ETF	68.36	68.37	68.36	68.37	500.0
2010-03-30 18:00:00	IWM	ETF	68.4	68.42	68.4	68.42	200.0
2010-03-30 19:00:00	IWM	ETF	68.41	68.47	68.41	68.43	2300.0
2010-03-30 08:00:00	DIA	ETF	109.07	109.07	108.88	108.92	8950.0
2010-03-30 09:00:00	DIA	ETF	108.97	109.335	108.94	109.25	1138851.0
2010-03-30 10:00:00	DIA	ETF	109.29	109.38	109.01	109.14	1264310.0
2010-03-30 11:00:00	DIA	ETF	109.15	109.15	108.67	108.9401	1299029.0
2010-03-30 12:00:00	DIA	ETF	108.95	109.08	108.9	109.02	398151.0
2010-03-30 13:00:00	DIA	ETF	109.0	109.01	108.8	108.93	323484.0

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

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