PREVIEW / etf_1hour / 2009-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-03.parquet
  size:    147 KB
  rows:    4,520

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-11-03 04:00:00	SPY	ETF	103.97	103.99	103.38	103.38	5319.0
2009-11-03 05:00:00	SPY	ETF	103.33	103.53	103.28	103.53	13239.0
2009-11-03 06:00:00	SPY	ETF	103.54	103.59	103.16	103.24	54406.0
2009-11-03 07:00:00	SPY	ETF	103.28	103.98	103.24	103.72	2344076.0
2009-11-03 08:00:00	SPY	ETF	103.9	104.36	102.49	103.65	6632342.0
2009-11-03 09:00:00	SPY	ETF	103.66	104.38	103.54	104.25	31516750.0
2009-11-03 10:00:00	SPY	ETF	104.23	104.54	103.75	104.1698	44097606.0
2009-11-03 11:00:00	SPY	ETF	104.16	104.369	103.6	103.9203	34166286.0
2009-11-03 12:00:00	SPY	ETF	103.9201	104.62	103.7	104.225	23518260.0
2009-11-03 13:00:00	SPY	ETF	104.2201	104.51	104.13	104.495	15890798.0
2009-11-03 14:00:00	SPY	ETF	104.5	104.8	104.13	104.22	21425374.0
2009-11-03 15:00:00	SPY	ETF	104.22	104.75	104.16	104.67	33177587.0
2009-11-03 16:00:00	SPY	ETF	104.67	104.75	103.7659	104.67	14282235.0
2009-11-03 17:00:00	SPY	ETF	104.65	104.7	104.4358	104.65	1043170.0
2009-11-03 18:00:00	SPY	ETF	104.65	104.8	104.58	104.79	46099.0
2009-11-03 19:00:00	SPY	ETF	104.75	104.82	103.79	104.78	25534.0
2009-11-03 04:00:00	QQQ	ETF	40.89	40.89	40.84	40.84	624.0
2009-11-03 05:00:00	QQQ	ETF	40.71	40.76	40.69	40.76	6555.0
2009-11-03 06:00:00	QQQ	ETF	40.79	40.79	40.69	40.7	43255.0
2009-11-03 07:00:00	QQQ	ETF	40.73	41.02	40.73	40.94	1088140.0
2009-11-03 08:00:00	QQQ	ETF	40.92	41.04	40.8	40.93	3412151.0
2009-11-03 09:00:00	QQQ	ETF	40.93	41.08	40.84	41.02	15971168.0
2009-11-03 10:00:00	QQQ	ETF	41.02	41.17	40.85	41.0	17659453.0
2009-11-03 11:00:00	QQQ	ETF	41.0	41.0895	40.84	40.96	9854829.0
2009-11-03 12:00:00	QQQ	ETF	40.96	41.21	40.85	41.1018	9740758.0
2009-11-03 13:00:00	QQQ	ETF	41.11	41.22	41.06	41.21	6993538.0
2009-11-03 14:00:00	QQQ	ETF	41.21	41.29	41.08	41.1525	10488679.0
2009-11-03 15:00:00	QQQ	ETF	41.145	41.32	41.1	41.26	16584321.0
2009-11-03 16:00:00	QQQ	ETF	41.26	41.2947	41.0779	41.26	2854786.0
2009-11-03 17:00:00	QQQ	ETF	41.23	41.26	41.23	41.26	4462.0
2009-11-03 18:00:00	QQQ	ETF	41.25	41.31	41.24	41.29	31892.0
2009-11-03 19:00:00	QQQ	ETF	41.28	41.32	41.25	41.32	9721.0
2009-11-03 06:00:00	IWM	ETF	55.55	55.64	55.55	55.56	537.0
2009-11-03 07:00:00	IWM	ETF	55.71	56.01	55.58	55.87	249137.0
2009-11-03 08:00:00	IWM	ETF	55.88	56.22	55.78	55.83	1771839.0
2009-11-03 09:00:00	IWM	ETF	55.84	56.34	55.69	56.24	14406350.0
2009-11-03 10:00:00	IWM	ETF	56.25	56.5	55.9	56.18	15790655.0
2009-11-03 11:00:00	IWM	ETF	56.185	56.28	55.92	56.2	9039557.0
2009-11-03 12:00:00	IWM	ETF	56.2	56.67	56.0	56.365	8981378.0
2009-11-03 13:00:00	IWM	ETF	56.33	56.65	56.25	56.65	5594748.0
2009-11-03 14:00:00	IWM	ETF	56.65	56.89	56.49	56.59	8797840.0
2009-11-03 15:00:00	IWM	ETF	56.585	57.09	56.51	57.06	12371677.0
2009-11-03 16:00:00	IWM	ETF	57.06	57.1128	56.92	56.97	4087912.0
2009-11-03 17:00:00	IWM	ETF	56.96	56.99	56.2898	56.94	1007700.0
2009-11-03 18:00:00	IWM	ETF	56.94	57.0	56.93	57.0	1400.0
2009-11-03 19:00:00	IWM	ETF	57.07	57.07	57.03	57.03	800.0
2009-11-03 07:00:00	DIA	ETF	97.22	97.22	97.22	97.22	200.0
2009-11-03 08:00:00	DIA	ETF	97.46	97.5	97.19	97.22	192316.0
2009-11-03 09:00:00	DIA	ETF	97.26	97.87	97.071	97.75	2305295.0
2009-11-03 10:00:00	DIA	ETF	97.74	97.92	97.31	97.6	3222066.0

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

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