PREVIEW / etf_1hour / 2010-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-07.parquet
  size:    162 KB
  rows:    4,890

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-07-07 04:00:00	SPY	ETF	102.46	102.51	102.31	102.31	2400.0
2010-07-07 05:00:00	SPY	ETF	102.34	102.34	102.19	102.33	2750.0
2010-07-07 06:00:00	SPY	ETF	102.36	102.65	102.36	102.65	24800.0
2010-07-07 07:00:00	SPY	ETF	102.68	102.89	102.62	102.65	414344.0
2010-07-07 08:00:00	SPY	ETF	102.66	103.11	102.04	103.0	2786913.0
2010-07-07 09:00:00	SPY	ETF	103.0	103.62	102.87	103.6	22230987.0
2010-07-07 10:00:00	SPY	ETF	103.6	104.69	103.6	104.58	42085810.0
2010-07-07 11:00:00	SPY	ETF	104.58	104.65	104.09	104.22	29211599.0
2010-07-07 12:00:00	SPY	ETF	104.22	104.62	104.2	104.5	23445631.0
2010-07-07 13:00:00	SPY	ETF	104.51	105.18	104.48	105.06	22657872.0
2010-07-07 14:00:00	SPY	ETF	105.05	105.35	104.95	105.33	24210385.0
2010-07-07 15:00:00	SPY	ETF	105.34	106.24	105.11	106.13	66687502.0
2010-07-07 16:00:00	SPY	ETF	106.14	106.46	103.075	106.41	16441220.0
2010-07-07 17:00:00	SPY	ETF	106.4	106.44	106.35	106.37	246543.0
2010-07-07 18:00:00	SPY	ETF	106.37	106.46	106.15	106.39	151678.0
2010-07-07 19:00:00	SPY	ETF	106.4	106.41	106.3	106.32	195131.0
2010-07-07 04:00:00	QQQ	ETF	42.61	42.61	42.47	42.49	19900.0
2010-07-07 05:00:00	QQQ	ETF	42.51	42.51	42.4	42.46	6700.0
2010-07-07 06:00:00	QQQ	ETF	42.42	42.59	42.42	42.59	30200.0
2010-07-07 07:00:00	QQQ	ETF	42.59	42.69	42.58	42.62	88377.0
2010-07-07 08:00:00	QQQ	ETF	42.63	42.71	42.56	42.63	1350283.0
2010-07-07 09:00:00	QQQ	ETF	42.64	42.99	42.6	42.94	9520367.0
2010-07-07 10:00:00	QQQ	ETF	42.95	43.31	42.945	43.28	11520874.0
2010-07-07 11:00:00	QQQ	ETF	43.27	43.34	43.11	43.17	8543441.0
2010-07-07 12:00:00	QQQ	ETF	43.17	43.28	43.14	43.23	5407318.0
2010-07-07 13:00:00	QQQ	ETF	43.23	43.52	43.22	43.485	9445099.0
2010-07-07 14:00:00	QQQ	ETF	43.485	43.62	43.4296	43.61	6202653.0
2010-07-07 15:00:00	QQQ	ETF	43.61	44.01	43.51	43.96	16088857.0
2010-07-07 16:00:00	QQQ	ETF	43.97	44.04	42.639	44.02	2870428.0
2010-07-07 17:00:00	QQQ	ETF	44.04	44.05	44.02	44.05	59216.0
2010-07-07 18:00:00	QQQ	ETF	44.04	44.09	44.02	44.02	31385.0
2010-07-07 19:00:00	QQQ	ETF	44.03	44.04	44.0	44.02	58635.0
2010-07-07 05:00:00	IWM	ETF	58.71	58.72	58.71	58.72	2000.0
2010-07-07 06:00:00	IWM	ETF	58.65	58.65	58.65	58.65	100.0
2010-07-07 07:00:00	IWM	ETF	58.99	59.12	58.95	58.96	43300.0
2010-07-07 08:00:00	IWM	ETF	58.95	59.21	58.85	59.12	261552.0
2010-07-07 09:00:00	IWM	ETF	59.16	59.64	59.09	59.52	6398960.0
2010-07-07 10:00:00	IWM	ETF	59.52	60.12	59.46	60.05	11780074.0
2010-07-07 11:00:00	IWM	ETF	60.05	60.1	59.5	59.6499	8506077.0
2010-07-07 12:00:00	IWM	ETF	59.65	59.93	59.56	59.84	4504597.0
2010-07-07 13:00:00	IWM	ETF	59.84	60.34	59.8	60.31	8802519.0
2010-07-07 14:00:00	IWM	ETF	60.32	60.54	60.27	60.53	8288212.0
2010-07-07 15:00:00	IWM	ETF	60.54	61.15	60.05	61.09	20195244.0
2010-07-07 16:00:00	IWM	ETF	61.1	61.45	58.9865	61.34	4181030.0
2010-07-07 17:00:00	IWM	ETF	61.1423	61.38	61.1	61.33	2627034.0
2010-07-07 18:00:00	IWM	ETF	61.26	61.34	61.26	61.29	2300.0
2010-07-07 19:00:00	IWM	ETF	61.27	61.29	61.2	61.29	9800.0
2010-07-07 07:00:00	DIA	ETF	97.27	97.37	97.26	97.26	23500.0
2010-07-07 08:00:00	DIA	ETF	97.22	97.59	97.13	97.54	51930.0
2010-07-07 09:00:00	DIA	ETF	97.43	97.97	97.43	97.95	1115759.0

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

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