PREVIEW / etf_1hour / 2010-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-29.parquet
  size:    160 KB
  rows:    4,843

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-01-29 04:00:00	SPY	ETF	108.52	108.52	108.33	108.33	1958.0
2010-01-29 05:00:00	SPY	ETF	108.37	108.67	108.19	108.63	109600.0
2010-01-29 06:00:00	SPY	ETF	108.55	108.85	108.55	108.7	55700.0
2010-01-29 07:00:00	SPY	ETF	108.65	108.85	108.59	108.8	607534.0
2010-01-29 08:00:00	SPY	ETF	108.77	109.34	108.73	109.13	7403055.0
2010-01-29 09:00:00	SPY	ETF	109.13	109.5	108.74	109.32	38962983.0
2010-01-29 10:00:00	SPY	ETF	109.32	109.8	109.02	109.29	40549753.0
2010-01-29 11:00:00	SPY	ETF	109.28	109.35	108.41	108.42	42601888.0
2010-01-29 12:00:00	SPY	ETF	108.41	108.87	108.24	108.832	28401918.0
2010-01-29 13:00:00	SPY	ETF	108.84	108.92	108.19	108.36	23620561.0
2010-01-29 14:00:00	SPY	ETF	108.37	108.57	107.64	107.93	38392589.0
2010-01-29 15:00:00	SPY	ETF	107.92	108.566	107.22	107.42	72153152.0
2010-01-29 16:00:00	SPY	ETF	107.42	109.62	107.15	107.34	15955272.0
2010-01-29 17:00:00	SPY	ETF	107.36	107.38	107.21	107.27	293530.0
2010-01-29 18:00:00	SPY	ETF	107.27	107.36	107.24	107.31	134863.0
2010-01-29 19:00:00	SPY	ETF	107.38	107.38	107.29	107.35	19500.0
2010-01-29 04:00:00	QQQ	ETF	43.65	43.65	43.62	43.63	700.0
2010-01-29 05:00:00	QQQ	ETF	43.61	43.61	43.53	43.53	2600.0
2010-01-29 06:00:00	QQQ	ETF	43.63	43.7	43.63	43.7	2000.0
2010-01-29 07:00:00	QQQ	ETF	43.65	43.78	43.64	43.78	50097.0
2010-01-29 08:00:00	QQQ	ETF	43.67	44.04	43.67	44.04	3297399.0
2010-01-29 09:00:00	QQQ	ETF	44.03	44.04	43.8	43.899	25986137.0
2010-01-29 10:00:00	QQQ	ETF	43.9	44.0	43.595	43.67	29595547.0
2010-01-29 11:00:00	QQQ	ETF	43.67	43.7	43.24	43.26	34643940.0
2010-01-29 12:00:00	QQQ	ETF	43.26	44.0	43.15	43.38	20220459.0
2010-01-29 13:00:00	QQQ	ETF	43.37	44.0	43.02	43.07	13308928.0
2010-01-29 14:00:00	QQQ	ETF	43.0701	43.14	42.68	42.7838	28608088.0
2010-01-29 15:00:00	QQQ	ETF	42.78	42.98	42.63	42.8	39815764.0
2010-01-29 16:00:00	QQQ	ETF	42.8	44.0	42.72	42.81	5286258.0
2010-01-29 17:00:00	QQQ	ETF	42.81	42.9	42.66	42.86	64199.0
2010-01-29 18:00:00	QQQ	ETF	42.83	42.83	42.77	42.8	15915.0
2010-01-29 19:00:00	QQQ	ETF	42.79	42.9	42.79	42.89	14018.0
2010-01-29 05:00:00	IWM	ETF	60.78	60.78	60.74	60.74	800.0
2010-01-29 06:00:00	IWM	ETF	60.77	60.79	60.67	60.67	32400.0
2010-01-29 07:00:00	IWM	ETF	60.66	60.83	60.64	60.8	21313.0
2010-01-29 08:00:00	IWM	ETF	60.79	61.19	60.25	61.08	1095329.0
2010-01-29 09:00:00	IWM	ETF	61.07	61.44	60.77	61.378	10297795.0
2010-01-29 10:00:00	IWM	ETF	61.38	61.69	61.14	61.31	9308412.0
2010-01-29 11:00:00	IWM	ETF	61.3	61.3975	60.77	60.78	10076062.0
2010-01-29 12:00:00	IWM	ETF	60.78	61.07	60.66	61.05	5374675.0
2010-01-29 13:00:00	IWM	ETF	61.058	61.09	60.65	60.76	4802083.0
2010-01-29 14:00:00	IWM	ETF	60.76	60.83	60.26	60.4201	7730480.0
2010-01-29 15:00:00	IWM	ETF	60.42	60.47	59.97	60.17	17431579.0
2010-01-29 16:00:00	IWM	ETF	60.17	60.7904	59.98	60.07	5138599.0
2010-01-29 17:00:00	IWM	ETF	60.07	60.1	60.05	60.07	2500.0
2010-01-29 18:00:00	IWM	ETF	60.05	60.1	60.03	60.07	4500.0
2010-01-29 19:00:00	IWM	ETF	60.1	60.1	60.05	60.05	8495.0
2010-01-29 07:00:00	DIA	ETF	101.16	101.38	101.16	101.38	1600.0
2010-01-29 08:00:00	DIA	ETF	101.5	101.84	101.45	101.72	91704.0
2010-01-29 09:00:00	DIA	ETF	101.72	101.98	101.34	101.86	2012619.0

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

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