PREVIEW / etf_1hour / 2009-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-30.parquet
  size:    143 KB
  rows:    4,376

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-07-30 04:00:00	SPY	ETF	98.1	98.53	98.1	98.53	15418.0
2009-07-30 05:00:00	SPY	ETF	98.53	98.7	98.53	98.66	17111.0
2009-07-30 06:00:00	SPY	ETF	98.65	98.85	98.65	98.67	59424.0
2009-07-30 07:00:00	SPY	ETF	98.68	98.74	98.55	98.65	830094.0
2009-07-30 08:00:00	SPY	ETF	98.65	99.1	98.19	98.96	7862807.0
2009-07-30 09:00:00	SPY	ETF	98.98	99.47	98.6	99.41	29662908.0
2009-07-30 10:00:00	SPY	ETF	99.4	99.83	99.32	99.74	35148014.0
2009-07-30 11:00:00	SPY	ETF	99.74	99.8	99.15	99.21	24700769.0
2009-07-30 12:00:00	SPY	ETF	99.21	99.41	99.15	99.28	15419677.0
2009-07-30 13:00:00	SPY	ETF	99.275	99.64	99.25	99.365	20124007.0
2009-07-30 14:00:00	SPY	ETF	99.39	99.51	99.2	99.39	16994199.0
2009-07-30 15:00:00	SPY	ETF	99.39	99.63	98.655	98.71	49603954.0
2009-07-30 16:00:00	SPY	ETF	98.7	99.7	98.55	98.61	13727472.0
2009-07-30 17:00:00	SPY	ETF	98.61	99.025	98.55	98.6	235287.0
2009-07-30 18:00:00	SPY	ETF	98.58	98.74	98.57	98.68	101856.0
2009-07-30 19:00:00	SPY	ETF	98.7	99.01	98.68	98.7	90500.0
2009-07-30 04:00:00	QQQ	ETF	39.6	39.65	39.6	39.65	739.0
2009-07-30 05:00:00	QQQ	ETF	39.65	39.71	39.65	39.66	15770.0
2009-07-30 06:00:00	QQQ	ETF	39.75	39.75	39.66	39.7	2810.0
2009-07-30 07:00:00	QQQ	ETF	39.66	39.68	39.61	39.67	172681.0
2009-07-30 08:00:00	QQQ	ETF	39.67	39.82	39.61	39.79	1498394.0
2009-07-30 09:00:00	QQQ	ETF	39.79	40.05	39.65	40.03	17160295.0
2009-07-30 10:00:00	QQQ	ETF	40.0399	40.18	39.96	40.08	16099245.0
2009-07-30 11:00:00	QQQ	ETF	40.09	40.11	39.82	39.83	11173305.0
2009-07-30 12:00:00	QQQ	ETF	39.8299	39.88	39.77	39.8	7841524.0
2009-07-30 13:00:00	QQQ	ETF	39.79	39.93	39.78	39.83	9022555.0
2009-07-30 14:00:00	QQQ	ETF	39.8201	39.91	39.73	39.85	10771261.0
2009-07-30 15:00:00	QQQ	ETF	39.85	39.95	39.51	39.57	22878418.0
2009-07-30 16:00:00	QQQ	ETF	39.57	39.88	39.3461	39.57	7260735.0
2009-07-30 17:00:00	QQQ	ETF	39.56	39.58	39.53	39.57	100557.0
2009-07-30 18:00:00	QQQ	ETF	39.55	39.58	39.54	39.58	17750.0
2009-07-30 19:00:00	QQQ	ETF	39.59	39.61	39.56	39.56	12750.0
2009-07-30 06:00:00	IWM	ETF	55.6	55.6	55.6	55.6	5000.0
2009-07-30 07:00:00	IWM	ETF	55.45	55.49	55.4	55.49	51900.0
2009-07-30 08:00:00	IWM	ETF	55.5	55.74	55.21	55.68	927769.0
2009-07-30 09:00:00	IWM	ETF	55.71	56.165	55.38	56.14	9741356.0
2009-07-30 10:00:00	IWM	ETF	56.15	56.44	56.1	56.37	9498605.0
2009-07-30 11:00:00	IWM	ETF	56.38	56.41	55.77	55.81	6619768.0
2009-07-30 12:00:00	IWM	ETF	55.805	55.94	55.76	55.88	3050163.0
2009-07-30 13:00:00	IWM	ETF	55.88	56.22	55.87	56.0	6750750.0
2009-07-30 14:00:00	IWM	ETF	56.005	56.14	55.92	56.09	4097025.0
2009-07-30 15:00:00	IWM	ETF	56.09	56.215	55.58	55.74	12091077.0
2009-07-30 16:00:00	IWM	ETF	55.74	55.94	54.8523	55.58	9166659.0
2009-07-30 17:00:00	IWM	ETF	55.59	55.6	54.8523	55.53	3282837.0
2009-07-30 18:00:00	IWM	ETF	55.64	55.65	55.46	55.65	3635.0
2009-07-30 19:00:00	IWM	ETF	55.63	55.65	55.63	55.65	200.0
2009-07-30 07:00:00	DIA	ETF	91.55	91.6	91.48	91.52	10521.0
2009-07-30 08:00:00	DIA	ETF	91.5	91.85	91.32	91.72	156573.0
2009-07-30 09:00:00	DIA	ETF	91.71	92.0365	91.27	91.98	1854126.0
2009-07-30 10:00:00	DIA	ETF	91.98	92.48	91.969	92.43	2165483.0

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

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