PREVIEW / etf_1hour / 2010-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-24.parquet
  size:    156 KB
  rows:    4,876

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-24 04:00:00	SPY	ETF	117.35	117.35	117.26	117.26	500.0
2010-03-24 06:00:00	SPY	ETF	117.18	117.18	116.75	116.92	41946.0
2010-03-24 07:00:00	SPY	ETF	116.93	117.16	116.91	117.03	1150437.0
2010-03-24 08:00:00	SPY	ETF	117.03	117.21	116.88	117.09	3369163.0
2010-03-24 09:00:00	SPY	ETF	117.09	117.2	116.9	117.04	21377394.0
2010-03-24 10:00:00	SPY	ETF	117.03	117.32	116.87	117.13	27529053.0
2010-03-24 11:00:00	SPY	ETF	117.125	117.21	116.61	116.98	25947708.0
2010-03-24 12:00:00	SPY	ETF	116.98	117.4264	116.85	117.081	17861544.0
2010-03-24 13:00:00	SPY	ETF	117.087	117.09	115.58	116.79	28299272.0
2010-03-24 14:00:00	SPY	ETF	116.7999	116.96	116.72	116.78	17231335.0
2010-03-24 15:00:00	SPY	ETF	116.77	117.09	116.7	116.82	32361301.0
2010-03-24 16:00:00	SPY	ETF	116.82	117.4263	116.82	116.88	13693569.0
2010-03-24 17:00:00	SPY	ETF	116.88	116.9	116.85	116.88	4971629.0
2010-03-24 18:00:00	SPY	ETF	116.89	116.9	116.86	116.86	48700.0
2010-03-24 19:00:00	SPY	ETF	116.87	116.95	116.87	116.91	72905.0
2010-03-24 04:00:00	QQQ	ETF	48.26	48.28	48.21	48.21	3300.0
2010-03-24 05:00:00	QQQ	ETF	48.25	48.25	48.23	48.24	2580.0
2010-03-24 06:00:00	QQQ	ETF	48.07	48.1	48.06	48.1	16000.0
2010-03-24 07:00:00	QQQ	ETF	48.14	48.18	48.13	48.16	279717.0
2010-03-24 08:00:00	QQQ	ETF	48.17	48.26	48.13	48.19	452633.0
2010-03-24 09:00:00	QQQ	ETF	48.19	48.2	48.035	48.1	10547156.0
2010-03-24 10:00:00	QQQ	ETF	48.09	48.16	48.0	48.09	11723801.0
2010-03-24 11:00:00	QQQ	ETF	48.09	48.14	47.91	48.0502	11082052.0
2010-03-24 12:00:00	QQQ	ETF	48.055	48.11	48.03	48.06	4456821.0
2010-03-24 13:00:00	QQQ	ETF	48.05	48.06	47.93	48.0	5563434.0
2010-03-24 14:00:00	QQQ	ETF	48.01	48.06	47.95	47.95	7173770.0
2010-03-24 15:00:00	QQQ	ETF	47.95	48.11	47.94	48.02	10439983.0
2010-03-24 16:00:00	QQQ	ETF	48.02	48.06	48.01	48.04	1131573.0
2010-03-24 17:00:00	QQQ	ETF	48.04	48.06	48.0	48.0	44240.0
2010-03-24 18:00:00	QQQ	ETF	48.03	48.05	48.03	48.05	23148.0
2010-03-24 19:00:00	QQQ	ETF	48.03	48.06	48.03	48.03	16925.0
2010-03-24 06:00:00	IWM	ETF	68.68	68.68	68.54	68.6	18200.0
2010-03-24 07:00:00	IWM	ETF	68.64	68.73	68.62	68.69	40710.0
2010-03-24 08:00:00	IWM	ETF	68.72	68.83	68.65	68.78	373305.0
2010-03-24 09:00:00	IWM	ETF	68.77	68.89	68.6	68.73	7563984.0
2010-03-24 10:00:00	IWM	ETF	68.73	68.93	68.57	68.71	7311539.0
2010-03-24 11:00:00	IWM	ETF	68.7	68.79	68.44	68.7	6817554.0
2010-03-24 12:00:00	IWM	ETF	68.7	68.79	68.64	68.7	3296858.0
2010-03-24 13:00:00	IWM	ETF	68.69	68.9737	68.46	68.63	6295401.0
2010-03-24 14:00:00	IWM	ETF	68.62	68.9737	68.47	68.49	5168355.0
2010-03-24 15:00:00	IWM	ETF	68.48	68.56	68.25	68.25	14976551.0
2010-03-24 16:00:00	IWM	ETF	68.26	68.9737	68.25	68.38	5132077.0
2010-03-24 17:00:00	IWM	ETF	68.36	68.4	68.33	68.4	64823.0
2010-03-24 18:00:00	IWM	ETF	68.4	68.4	68.3	68.3	500.0
2010-03-24 19:00:00	IWM	ETF	68.39	68.43	68.25	68.35	1800.0
2010-03-24 07:00:00	DIA	ETF	108.59	108.59	108.49	108.54	71250.0
2010-03-24 08:00:00	DIA	ETF	108.54	108.7	108.46	108.52	49532.0
2010-03-24 09:00:00	DIA	ETF	108.63	108.72	108.45	108.62	900149.0
2010-03-24 10:00:00	DIA	ETF	108.61	108.81	108.49	108.62	1364754.0
2010-03-24 11:00:00	DIA	ETF	108.63	108.7	108.24	108.56	1167909.0

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

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