PREVIEW / etf_1hour / 2009-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-16.parquet
  size:    144 KB
  rows:    4,388

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
2009-10-16 04:00:00	SPY	ETF	109.72	109.79	109.63	109.63	2500.0
2009-10-16 05:00:00	SPY	ETF	109.64	109.64	109.64	109.64	150.0
2009-10-16 06:00:00	SPY	ETF	109.67	109.67	109.24	109.24	6163.0
2009-10-16 07:00:00	SPY	ETF	109.16	109.19	108.82	109.01	865681.0
2009-10-16 08:00:00	SPY	ETF	109.02	109.5	108.53	108.74	3242983.0
2009-10-16 09:00:00	SPY	ETF	108.74	109.65	108.57	108.64	31799849.0
2009-10-16 10:00:00	SPY	ETF	108.64	108.65	108.23	108.35	32082152.0
2009-10-16 11:00:00	SPY	ETF	108.35	108.69	108.33	108.54	19310211.0
2009-10-16 12:00:00	SPY	ETF	108.54	108.66	108.43	108.61	11617924.0
2009-10-16 13:00:00	SPY	ETF	108.62	109.17	108.54	108.949	21327208.0
2009-10-16 14:00:00	SPY	ETF	108.94	109.01	108.72	108.89	15475980.0
2009-10-16 15:00:00	SPY	ETF	108.88	109.27	108.78	108.89	38102888.0
2009-10-16 16:00:00	SPY	ETF	108.89	108.91	108.43	108.59	16508916.0
2009-10-16 17:00:00	SPY	ETF	108.59	108.62	108.5	108.53	226984.0
2009-10-16 18:00:00	SPY	ETF	108.52	108.56	108.47	108.48	42598.0
2009-10-16 19:00:00	SPY	ETF	108.48	108.55	108.47	108.55	20514.0
2009-10-16 05:00:00	QQQ	ETF	43.14	43.14	43.14	43.14	5000.0
2009-10-16 06:00:00	QQQ	ETF	43.17	43.17	43.03	43.03	2100.0
2009-10-16 07:00:00	QQQ	ETF	42.97	42.98	42.9	42.93	159300.0
2009-10-16 08:00:00	QQQ	ETF	42.96	42.97	42.79	42.86	1095108.0
2009-10-16 09:00:00	QQQ	ETF	42.86	42.98	42.72	42.76	18086059.0
2009-10-16 10:00:00	QQQ	ETF	42.76	42.768	42.48	42.55	20536602.0
2009-10-16 11:00:00	QQQ	ETF	42.54	42.66	42.52	42.58	10942527.0
2009-10-16 12:00:00	QQQ	ETF	42.58	42.69	42.58	42.67	7202479.0
2009-10-16 13:00:00	QQQ	ETF	42.67	42.99	42.63	42.88	12391398.0
2009-10-16 14:00:00	QQQ	ETF	42.87	42.9347	42.79	42.81	8729115.0
2009-10-16 15:00:00	QQQ	ETF	42.82	42.95	42.74	42.78	20968286.0
2009-10-16 16:00:00	QQQ	ETF	42.79	43.133	42.63	42.69	6343836.0
2009-10-16 17:00:00	QQQ	ETF	42.69	42.71	42.67	42.69	40024.0
2009-10-16 18:00:00	QQQ	ETF	42.69	42.79	42.67	42.68	43335.0
2009-10-16 19:00:00	QQQ	ETF	42.67	42.67	42.66	42.66	13800.0
2009-10-16 07:00:00	IWM	ETF	62.03	62.03	61.85	61.88	12733.0
2009-10-16 08:00:00	IWM	ETF	62.07	62.07	61.62	61.8	717509.0
2009-10-16 09:00:00	IWM	ETF	61.81	62.02	61.52	61.62	10135280.0
2009-10-16 10:00:00	IWM	ETF	61.61	61.61	61.14	61.235	8607761.0
2009-10-16 11:00:00	IWM	ETF	61.22	61.47	61.18	61.29	5286298.0
2009-10-16 12:00:00	IWM	ETF	61.28	61.42	61.26	61.35	3108561.0
2009-10-16 13:00:00	IWM	ETF	61.36	61.95	61.31	61.79	5530388.0
2009-10-16 14:00:00	IWM	ETF	61.79	61.84	61.67	61.74	3105620.0
2009-10-16 15:00:00	IWM	ETF	61.73	62.0	61.63	61.73	9560117.0
2009-10-16 16:00:00	IWM	ETF	61.72	61.72	61.49	61.62	1173925.0
2009-10-16 18:00:00	IWM	ETF	61.6	61.6	61.6	61.6	500.0
2009-10-16 19:00:00	IWM	ETF	61.55	61.55	61.55	61.55	100.0
2009-10-16 04:00:00	DIA	ETF	100.79	101.0	100.79	101.0	200.0
2009-10-16 07:00:00	DIA	ETF	99.89	99.91	99.73	99.83	25300.0
2009-10-16 08:00:00	DIA	ETF	99.84	100.12	99.46	99.62	117602.0
2009-10-16 09:00:00	DIA	ETF	99.64	99.97	99.57	99.65	2341173.0
2009-10-16 10:00:00	DIA	ETF	99.64	99.76	99.37	99.48	2094008.0
2009-10-16 11:00:00	DIA	ETF	99.47	99.73	99.44	99.55	1476315.0
2009-10-16 12:00:00	DIA	ETF	99.555	99.72	99.5083	99.7	862556.0

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

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