PREVIEW / stock_1hour / 2010-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-19.parquet
  size:    922 KB
  rows:    43,408
  symbols: 3,492

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-04-19 04:00:00	AAPL	Stock	8.8068	8.8107	8.8064	8.8107	28000.0
2010-04-19 05:00:00	AAPL	Stock	8.7743	8.7768	8.7536	8.7768	35840.0
2010-04-19 06:00:00	AAPL	Stock	8.7554	8.7625	8.75	8.7625	35280.0
2010-04-19 07:00:00	AAPL	Stock	8.7625	8.8186	8.7625	8.8036	200648.0
2010-04-19 08:00:00	AAPL	Stock	8.7857	8.845	8.7786	8.8396	2545564.0
2010-04-19 09:00:00	AAPL	Stock	8.8396	8.8532	8.8036	8.8339	64969016.0
2010-04-19 10:00:00	AAPL	Stock	8.8339	8.8482	8.7668	8.7707	93592996.0
2010-04-19 11:00:00	AAPL	Stock	8.7707	8.8064	8.6893	8.6989	72076088.0
2010-04-19 12:00:00	AAPL	Stock	8.6975	8.7371	8.6718	8.7168	72342816.0
2010-04-19 13:00:00	AAPL	Stock	8.7161	8.7161	8.6346	8.6521	91667324.0
2010-04-19 14:00:00	AAPL	Stock	8.6521	8.7696	8.6457	8.7679	72501576.0
2010-04-19 15:00:00	AAPL	Stock	8.7679	8.8243	8.7536	8.8243	83477436.0
2010-04-19 16:00:00	AAPL	Stock	8.8243	8.8352	8.7126	8.8089	9024540.0
2010-04-19 17:00:00	AAPL	Stock	8.6806	8.8168	8.6806	8.8143	361564.0
2010-04-19 18:00:00	AAPL	Stock	8.8179	8.8214	8.8143	8.8154	146944.0
2010-04-19 19:00:00	AAPL	Stock	8.8207	8.8214	8.8096	8.8179	354088.0
2010-04-19 20:00:00	AAPL	Stock	8.7786	8.7786	8.7786	8.7786	5600.0
2010-04-19 07:00:00	MSFT	Stock	30.72	30.72	30.61	30.62	6100.0
2010-04-19 08:00:00	MSFT	Stock	30.67	30.83	30.65	30.75	41959.0
2010-04-19 09:00:00	MSFT	Stock	30.76	31.25	30.75	30.97	12025492.0
2010-04-19 10:00:00	MSFT	Stock	30.97	31.01	30.84	30.895	10964981.0
2010-04-19 11:00:00	MSFT	Stock	30.892	30.92	30.79	30.83	6806720.0
2010-04-19 12:00:00	MSFT	Stock	30.825	30.92	30.8	30.919	5509671.0
2010-04-19 13:00:00	MSFT	Stock	30.92	30.92	30.81	30.855	5352669.0
2010-04-19 14:00:00	MSFT	Stock	30.85	31.04	30.83	31.02	7284557.0
2010-04-19 15:00:00	MSFT	Stock	31.02	31.07	30.95	31.03	13103819.0
2010-04-19 16:00:00	MSFT	Stock	31.03	31.13	30.806	31.05	2157661.0
2010-04-19 17:00:00	MSFT	Stock	30.811	31.12	30.811	31.09	548136.0
2010-04-19 18:00:00	MSFT	Stock	31.08	31.09	31.04	31.08	8519.0
2010-04-19 19:00:00	MSFT	Stock	31.08	31.11	31.08	31.11	4400.0
2010-04-19 20:00:00	MSFT	Stock	30.88	30.88	30.88	30.88	500.0
2010-04-19 07:00:00	NVDA	Stock	0.4238	0.4238	0.4238	0.4238	12440.0
2010-04-19 08:00:00	NVDA	Stock	0.4248	0.4248	0.4205	0.422	823400.0
2010-04-19 09:00:00	NVDA	Stock	0.4238	0.4253	0.4205	0.423	168046560.0
2010-04-19 10:00:00	NVDA	Stock	0.423	0.4238	0.4175	0.4188	197035560.0
2010-04-19 11:00:00	NVDA	Stock	0.4188	0.4195	0.413	0.4138	145617280.0
2010-04-19 12:00:00	NVDA	Stock	0.4138	0.416	0.412	0.412	124765840.0
2010-04-19 13:00:00	NVDA	Stock	0.4122	0.415	0.4102	0.4132	85365280.0
2010-04-19 14:00:00	NVDA	Stock	0.4133	0.4198	0.413	0.4188	102692960.0
2010-04-19 15:00:00	NVDA	Stock	0.419	0.4258	0.4189	0.4245	226193720.0
2010-04-19 16:00:00	NVDA	Stock	0.4245	0.4265	0.416	0.419	6364880.0
2010-04-19 17:00:00	NVDA	Stock	0.4225	0.423	0.4208	0.4215	19534600.0
2010-04-19 18:00:00	NVDA	Stock	0.425	0.425	0.425	0.425	8000.0
2010-04-19 19:00:00	NVDA	Stock	0.4225	0.4225	0.4225	0.4225	4000.0
2010-04-19 08:00:00	AMZN	Stock	7.1235	7.124	7.0745	7.0745	22280.0
2010-04-19 09:00:00	AMZN	Stock	7.0745	7.1835	7.064	7.105	15710100.0
2010-04-19 10:00:00	AMZN	Stock	7.1045	7.1195	7.055	7.0615	18970100.0
2010-04-19 11:00:00	AMZN	Stock	7.0635	7.0905	6.9945	7.0025	17712780.0
2010-04-19 12:00:00	AMZN	Stock	7.002	7.038	6.9565	7.036	17196380.0
2010-04-19 13:00:00	AMZN	Stock	7.0355	7.058	7.0115	7.0225	11269900.0

> showing 50 of 43,408 rows — these rows as CSV

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