PREVIEW / etf_1hour / 2009-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-06.parquet
  size:    140 KB
  rows:    4,334

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-06 04:00:00	SPY	ETF	106.98	106.98	106.87	106.87	3000.0
2009-11-06 05:00:00	SPY	ETF	106.72	106.84	106.68	106.84	1300.0
2009-11-06 06:00:00	SPY	ETF	107.0	107.0	106.84	106.9	12700.0
2009-11-06 07:00:00	SPY	ETF	106.87	107.03	106.84	106.97	373843.0
2009-11-06 08:00:00	SPY	ETF	107.0	107.4	105.85	106.08	13342272.0
2009-11-06 09:00:00	SPY	ETF	106.09	107.33	105.97	107.17	37143794.0
2009-11-06 10:00:00	SPY	ETF	107.17	107.4	106.24	106.771	36900543.0
2009-11-06 11:00:00	SPY	ETF	106.77	106.99	106.53	106.83	16898649.0
2009-11-06 12:00:00	SPY	ETF	106.83	107.22	106.83	106.95	15565432.0
2009-11-06 13:00:00	SPY	ETF	106.935	107.25	106.8	106.99	10075509.0
2009-11-06 14:00:00	SPY	ETF	106.99	107.12	106.82	106.85	10581403.0
2009-11-06 15:00:00	SPY	ETF	106.85	107.19	106.66	107.15	23480225.0
2009-11-06 16:00:00	SPY	ETF	107.14	107.4177	106.295	107.22	6163573.0
2009-11-06 17:00:00	SPY	ETF	107.24	107.3	107.22	107.29	210508.0
2009-11-06 18:00:00	SPY	ETF	107.28	107.3	107.27	107.27	15233.0
2009-11-06 19:00:00	SPY	ETF	107.28	107.32	107.27	107.32	29258.0
2009-11-06 04:00:00	QQQ	ETF	42.35	42.35	42.33	42.35	700.0
2009-11-06 06:00:00	QQQ	ETF	42.4	42.41	42.39	42.41	15150.0
2009-11-06 07:00:00	QQQ	ETF	42.37	42.46	42.37	42.45	94689.0
2009-11-06 08:00:00	QQQ	ETF	42.43	42.73	42.0	42.09	6837969.0
2009-11-06 09:00:00	QQQ	ETF	42.08	42.63	42.05	42.57	18557149.0
2009-11-06 10:00:00	QQQ	ETF	42.58	42.65	42.19	42.39	18808562.0
2009-11-06 11:00:00	QQQ	ETF	42.385	42.5	42.34	42.44	10718245.0
2009-11-06 12:00:00	QQQ	ETF	42.45	42.58	42.41	42.4699	8346332.0
2009-11-06 13:00:00	QQQ	ETF	42.46	42.61	42.43	42.51	6673695.0
2009-11-06 14:00:00	QQQ	ETF	42.5075	42.59	42.45	42.51	4933382.0
2009-11-06 15:00:00	QQQ	ETF	42.51	42.61	42.442	42.59	12290591.0
2009-11-06 16:00:00	QQQ	ETF	42.6	42.65	42.51	42.62	5137590.0
2009-11-06 17:00:00	QQQ	ETF	42.63	42.67	42.63	42.64	79585.0
2009-11-06 18:00:00	QQQ	ETF	42.65	42.68	42.65	42.67	6350.0
2009-11-06 19:00:00	QQQ	ETF	42.67	42.67	42.64	42.64	16925.0
2009-11-06 06:00:00	IWM	ETF	58.08	58.08	58.08	58.08	100.0
2009-11-06 07:00:00	IWM	ETF	58.1	58.13	58.04	58.1	4199.0
2009-11-06 08:00:00	IWM	ETF	58.1	59.67	57.23	57.45	2508387.0
2009-11-06 09:00:00	IWM	ETF	57.43	58.54	57.27	58.38	12317043.0
2009-11-06 10:00:00	IWM	ETF	58.38	58.58	57.47	57.8681	11225800.0
2009-11-06 11:00:00	IWM	ETF	57.86	58.02	57.72	57.88	4210224.0
2009-11-06 12:00:00	IWM	ETF	57.882	58.4048	57.72	57.79	6041544.0
2009-11-06 13:00:00	IWM	ETF	57.79	58.16	57.67	57.92	4659538.0
2009-11-06 14:00:00	IWM	ETF	57.93	57.98	57.735	57.868	3653385.0
2009-11-06 15:00:00	IWM	ETF	57.86	58.12	57.77	58.1	5529059.0
2009-11-06 16:00:00	IWM	ETF	58.09	58.1	57.463	58.02	1144698.0
2009-11-06 17:00:00	IWM	ETF	58.03	58.06	58.01	58.05	6174.0
2009-11-06 18:00:00	IWM	ETF	58.11	58.13	58.06	58.13	600.0
2009-11-06 19:00:00	IWM	ETF	58.05	58.05	58.05	58.05	475.0
2009-11-06 07:00:00	DIA	ETF	100.29	100.31	100.29	100.31	10000.0
2009-11-06 08:00:00	DIA	ETF	100.24	100.4	99.32	99.5	487123.0
2009-11-06 09:00:00	DIA	ETF	99.44	100.52	99.4	100.41	2987171.0
2009-11-06 10:00:00	DIA	ETF	100.42	100.6	99.68	100.14	2220100.0
2009-11-06 11:00:00	DIA	ETF	100.14	100.35	99.97	100.2	1166512.0

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

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