PREVIEW / etf_1hour / 2010-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-13.parquet
  size:    155 KB
  rows:    4,825

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-08-13 04:00:00	SPY	ETF	109.0	109.28	109.0	109.07	4533.0
2010-08-13 05:00:00	SPY	ETF	109.1	109.1	108.31	108.37	13800.0
2010-08-13 06:00:00	SPY	ETF	108.28	108.28	108.05	108.16	64050.0
2010-08-13 07:00:00	SPY	ETF	108.17	108.26	107.98	108.11	951682.0
2010-08-13 08:00:00	SPY	ETF	108.12	108.48	107.8	108.37	3919539.0
2010-08-13 09:00:00	SPY	ETF	108.31	108.89	108.1	108.84	26651116.0
2010-08-13 10:00:00	SPY	ETF	108.84	108.96	108.32	108.49	28306395.0
2010-08-13 11:00:00	SPY	ETF	108.49	108.62	108.18	108.41	17035257.0
2010-08-13 12:00:00	SPY	ETF	108.4	108.79	108.385	108.77	10710870.0
2010-08-13 13:00:00	SPY	ETF	108.7616	108.905	108.65	108.68	11496603.0
2010-08-13 14:00:00	SPY	ETF	108.68	108.76	108.4	108.49	12059801.0
2010-08-13 15:00:00	SPY	ETF	108.48	108.66	108.22	108.3	30542725.0
2010-08-13 16:00:00	SPY	ETF	108.29	108.885	108.1	108.23	15865053.0
2010-08-13 17:00:00	SPY	ETF	108.23	108.34	108.12	108.13	368372.0
2010-08-13 18:00:00	SPY	ETF	108.15	108.3	108.13	108.24	286883.0
2010-08-13 19:00:00	SPY	ETF	108.23	108.25	108.17	108.17	28312.0
2010-08-13 04:00:00	QQQ	ETF	45.18	45.2	45.18	45.2	200.0
2010-08-13 05:00:00	QQQ	ETF	45.02	45.02	45.02	45.02	783.0
2010-08-13 06:00:00	QQQ	ETF	44.86	44.86	44.78	44.82	41139.0
2010-08-13 07:00:00	QQQ	ETF	44.81	44.85	44.75	44.77	24692.0
2010-08-13 08:00:00	QQQ	ETF	44.79	44.91	44.67	44.87	1044224.0
2010-08-13 09:00:00	QQQ	ETF	44.86	45.06	44.76	44.99	8450893.0
2010-08-13 10:00:00	QQQ	ETF	44.99	45.0296	44.75	44.84	7840655.0
2010-08-13 11:00:00	QQQ	ETF	44.83	44.87	44.71	44.8301	4212871.0
2010-08-13 12:00:00	QQQ	ETF	44.83	44.96	44.82	44.95	2296272.0
2010-08-13 13:00:00	QQQ	ETF	44.94	45.02	44.9	44.93	1975602.0
2010-08-13 14:00:00	QQQ	ETF	44.93	44.95	44.82	44.86	3767778.0
2010-08-13 15:00:00	QQQ	ETF	44.86	44.93	44.72	44.725	9861513.0
2010-08-13 16:00:00	QQQ	ETF	44.72	45.0568	44.68	44.72	3927231.0
2010-08-13 17:00:00	QQQ	ETF	44.72	44.72	44.69	44.69	9443.0
2010-08-13 18:00:00	QQQ	ETF	44.69	44.71	44.68	44.68	15960.0
2010-08-13 19:00:00	QQQ	ETF	44.68	44.7	44.65	44.65	19394.0
2010-08-13 06:00:00	IWM	ETF	61.21	61.26	61.21	61.25	10100.0
2010-08-13 07:00:00	IWM	ETF	61.26	61.31	61.17	61.27	24888.0
2010-08-13 08:00:00	IWM	ETF	61.26	61.54	61.08	61.48	365937.0
2010-08-13 09:00:00	IWM	ETF	61.47	61.68	61.15	61.6301	8712628.0
2010-08-13 10:00:00	IWM	ETF	61.64	61.67	60.97	61.21	13487814.0
2010-08-13 11:00:00	IWM	ETF	61.21	61.35	61.02	61.25	5590822.0
2010-08-13 12:00:00	IWM	ETF	61.25	61.56	61.21	61.52	2545178.0
2010-08-13 13:00:00	IWM	ETF	61.52	61.65	61.39	61.49	3062830.0
2010-08-13 14:00:00	IWM	ETF	61.49	61.535	61.24	61.275	5032800.0
2010-08-13 15:00:00	IWM	ETF	61.28	61.4642	60.97	61.04	11470815.0
2010-08-13 16:00:00	IWM	ETF	61.04	61.7337	60.94	60.97	11899369.0
2010-08-13 17:00:00	IWM	ETF	60.97	61.7336	60.93	60.94	506543.0
2010-08-13 18:00:00	IWM	ETF	60.97	61.02	60.97	61.02	1700.0
2010-08-13 19:00:00	IWM	ETF	61.02	61.03	61.0	61.02	4600.0
2010-08-13 06:00:00	DIA	ETF	103.17	103.17	103.01	103.01	12000.0
2010-08-13 07:00:00	DIA	ETF	103.08	103.16	102.93	103.02	28100.0
2010-08-13 08:00:00	DIA	ETF	103.0	103.33	102.81	103.3	95383.0
2010-08-13 09:00:00	DIA	ETF	103.23	103.64	103.09	103.63	1500891.0

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

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