PREVIEW / etf_1hour / 2010-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-12.parquet
  size:    163 KB
  rows:    5,073

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-10-12 04:00:00	SPY	ETF	116.41	116.41	115.7	115.7	13555.0
2010-10-12 05:00:00	SPY	ETF	115.75	115.98	115.75	115.98	53225.0
2010-10-12 06:00:00	SPY	ETF	115.95	116.04	115.83	116.02	20200.0
2010-10-12 07:00:00	SPY	ETF	116.02	116.32	115.98	116.25	490572.0
2010-10-12 08:00:00	SPY	ETF	116.25	116.39	115.8	116.38	3436896.0
2010-10-12 09:00:00	SPY	ETF	116.38	116.4	115.65	115.88	26480017.0
2010-10-12 10:00:00	SPY	ETF	115.88	116.52	115.81	116.3999	26648896.0
2010-10-12 11:00:00	SPY	ETF	116.4	116.59	116.35	116.46	16069520.0
2010-10-12 12:00:00	SPY	ETF	116.465	116.6	116.32	116.3499	9691093.0
2010-10-12 13:00:00	SPY	ETF	116.345	116.46	116.3	116.44	5566882.0
2010-10-12 14:00:00	SPY	ETF	116.44	117.02	116.29	116.85	35052895.0
2010-10-12 15:00:00	SPY	ETF	116.85	117.35	116.64	117.04	36323687.0
2010-10-12 16:00:00	SPY	ETF	117.04	117.25	115.915	117.07	11795285.0
2010-10-12 17:00:00	SPY	ETF	117.07	117.16	117.0	117.16	7310867.0
2010-10-12 18:00:00	SPY	ETF	117.13	117.13	116.98	117.05	202189.0
2010-10-12 19:00:00	SPY	ETF	117.06	117.13	117.02	117.05	277405.0
2010-10-12 04:00:00	QQQ	ETF	49.59	49.59	49.36	49.38	4374.0
2010-10-12 05:00:00	QQQ	ETF	49.44	49.44	49.44	49.44	200.0
2010-10-12 06:00:00	QQQ	ETF	49.5	49.55	49.46	49.55	5700.0
2010-10-12 07:00:00	QQQ	ETF	49.55	49.65	49.54	49.64	166242.0
2010-10-12 08:00:00	QQQ	ETF	49.63	49.75	49.56	49.75	352117.0
2010-10-12 09:00:00	QQQ	ETF	49.74	49.74	49.26	49.365	18579189.0
2010-10-12 10:00:00	QQQ	ETF	49.36	49.98	49.34	49.92	15279848.0
2010-10-12 11:00:00	QQQ	ETF	49.91	49.98	49.84	49.8931	6299646.0
2010-10-12 12:00:00	QQQ	ETF	49.9	49.98	49.86	49.88	4432552.0
2010-10-12 13:00:00	QQQ	ETF	49.88	49.93	49.85	49.9062	2664691.0
2010-10-12 14:00:00	QQQ	ETF	49.9	50.12	49.83	50.01	16490972.0
2010-10-12 15:00:00	QQQ	ETF	50.01	50.21	49.92	50.12	12398624.0
2010-10-12 16:00:00	QQQ	ETF	50.13	50.37	49.762	50.17	3838177.0
2010-10-12 17:00:00	QQQ	ETF	50.17	50.17	50.09	50.15	230875.0
2010-10-12 18:00:00	QQQ	ETF	50.16	50.16	50.1	50.13	40875.0
2010-10-12 19:00:00	QQQ	ETF	50.13	50.15	50.1	50.11	35504.0
2010-10-12 04:00:00	IWM	ETF	68.79	68.79	68.62	68.66	1571.0
2010-10-12 06:00:00	IWM	ETF	68.87	68.87	68.87	68.87	100.0
2010-10-12 07:00:00	IWM	ETF	68.93	69.05	68.87	69.05	257463.0
2010-10-12 08:00:00	IWM	ETF	68.99	69.16	68.65	69.15	399493.0
2010-10-12 09:00:00	IWM	ETF	69.13	69.21	68.41	68.74	11236844.0
2010-10-12 10:00:00	IWM	ETF	68.74	69.35	68.68	69.22	8786015.0
2010-10-12 11:00:00	IWM	ETF	69.23	69.4	69.18	69.29	2334778.0
2010-10-12 12:00:00	IWM	ETF	69.29	69.46	69.22	69.24	1729033.0
2010-10-12 13:00:00	IWM	ETF	69.24	69.44	69.18	69.395	1304660.0
2010-10-12 14:00:00	IWM	ETF	69.4	69.82	69.26	69.54	9545435.0
2010-10-12 15:00:00	IWM	ETF	69.53	69.81	69.39	69.56	7959736.0
2010-10-12 16:00:00	IWM	ETF	69.58	69.7552	69.39	69.57	1730378.0
2010-10-12 17:00:00	IWM	ETF	69.56	69.56	69.46	69.51	66132.0
2010-10-12 18:00:00	IWM	ETF	69.6	69.6	69.6	69.6	9348.0
2010-10-12 19:00:00	IWM	ETF	69.55	69.55	69.55	69.55	315.0
2010-10-12 04:00:00	DIA	ETF	109.43	109.43	109.43	109.43	136.0
2010-10-12 05:00:00	DIA	ETF	109.68	109.8	109.68	109.8	900.0
2010-10-12 07:00:00	DIA	ETF	109.74	109.92	109.74	109.92	450.0

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

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