PREVIEW / stock_1hour / 2010-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-18.parquet
  size:    938 KB
  rows:    45,599
  symbols: 3,495

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-11-18 04:00:00	AAPL	Stock	10.8836	10.8893	10.8643	10.8643	30800.0
2010-11-18 05:00:00	AAPL	Stock	10.8661	10.8661	10.8571	10.8596	24220.0
2010-11-18 06:00:00	AAPL	Stock	10.8654	10.875	10.8654	10.8743	81200.0
2010-11-18 07:00:00	AAPL	Stock	10.8729	10.8854	10.85	10.86	752136.0
2010-11-18 08:00:00	AAPL	Stock	10.8582	10.8932	10.8521	10.8761	3822560.0
2010-11-18 09:00:00	AAPL	Stock	10.875	10.9464	10.8714	10.9411	86734592.0
2010-11-18 10:00:00	AAPL	Stock	10.9411	11.0268	10.9389	11.0157	115562356.0
2010-11-18 11:00:00	AAPL	Stock	11.0161	11.0354	11.0	11.0318	50251628.0
2010-11-18 12:00:00	AAPL	Stock	11.0318	11.0596	11.0268	11.0336	52491152.0
2010-11-18 13:00:00	AAPL	Stock	11.035	11.0429	11.0218	11.0282	27778044.0
2010-11-18 14:00:00	AAPL	Stock	11.0286	11.0461	10.9964	11.035	47166224.0
2010-11-18 15:00:00	AAPL	Stock	11.035	11.0496	11.0011	11.0204	77961576.0
2010-11-18 16:00:00	AAPL	Stock	11.0089	11.0532	10.7321	11.045	20760040.0
2010-11-18 17:00:00	AAPL	Stock	11.0475	11.05	11.02	11.05	951832.0
2010-11-18 18:00:00	AAPL	Stock	11.05	11.0532	11.0154	11.0421	937916.0
2010-11-18 19:00:00	AAPL	Stock	11.0446	11.0536	11.0204	11.0246	851900.0
2010-11-18 06:00:00	MSFT	Stock	25.85	25.85	25.85	25.85	1000.0
2010-11-18 07:00:00	MSFT	Stock	25.82	25.82	25.76	25.82	5440.0
2010-11-18 08:00:00	MSFT	Stock	25.82	25.82	25.72	25.77	41635.0
2010-11-18 09:00:00	MSFT	Stock	25.77	25.82	25.61	25.63	6301165.0
2010-11-18 10:00:00	MSFT	Stock	25.64	26.04	25.635	25.97	14335074.0
2010-11-18 11:00:00	MSFT	Stock	25.96	26.07	25.86	26.06	7897962.0
2010-11-18 12:00:00	MSFT	Stock	26.06	26.08	25.92	25.92	5653352.0
2010-11-18 13:00:00	MSFT	Stock	25.93	25.955	25.89	25.91	2765922.0
2010-11-18 14:00:00	MSFT	Stock	25.91	25.95	25.85	25.88	4389891.0
2010-11-18 15:00:00	MSFT	Stock	25.881	25.9	25.81	25.83	10705574.0
2010-11-18 16:00:00	MSFT	Stock	25.82	26.08	25.57	25.92	3376253.0
2010-11-18 17:00:00	MSFT	Stock	25.92	25.92	25.83	25.91	64631.0
2010-11-18 18:00:00	MSFT	Stock	25.84	25.91	25.84	25.89	7626.0
2010-11-18 19:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	3000.0
2010-11-18 08:00:00	NVDA	Stock	0.329	0.329	0.3275	0.328	339200.0
2010-11-18 09:00:00	NVDA	Stock	0.328	0.3335	0.3263	0.33	134863880.0
2010-11-18 10:00:00	NVDA	Stock	0.3303	0.334	0.3295	0.3334	170485840.0
2010-11-18 11:00:00	NVDA	Stock	0.3335	0.3345	0.3308	0.3338	141599800.0
2010-11-18 12:00:00	NVDA	Stock	0.3338	0.3353	0.333	0.3336	100119320.0
2010-11-18 13:00:00	NVDA	Stock	0.3335	0.3345	0.3322	0.3342	77731480.0
2010-11-18 14:00:00	NVDA	Stock	0.3342	0.3358	0.3338	0.335	120816640.0
2010-11-18 15:00:00	NVDA	Stock	0.335	0.3362	0.3322	0.3328	223076800.0
2010-11-18 16:00:00	NVDA	Stock	0.333	0.335	0.3318	0.335	5131240.0
2010-11-18 17:00:00	NVDA	Stock	0.3325	0.333	0.3325	0.3325	464360.0
2010-11-18 18:00:00	NVDA	Stock	0.333	0.333	0.3328	0.3328	80000.0
2010-11-18 19:00:00	NVDA	Stock	0.3328	0.333	0.3325	0.333	118000.0
2010-11-18 04:00:00	AMZN	Stock	7.956	7.9775	7.956	7.9775	4000.0
2010-11-18 05:00:00	AMZN	Stock	8.0465	8.05	8.0405	8.05	10400.0
2010-11-18 07:00:00	AMZN	Stock	8.05	8.0625	8.048	8.05	55800.0
2010-11-18 08:00:00	AMZN	Stock	8.0535	8.0535	8.0135	8.0325	257080.0
2010-11-18 09:00:00	AMZN	Stock	8.042	8.158	8.0245	8.1325	22206100.0
2010-11-18 10:00:00	AMZN	Stock	8.1325	8.225	8.1135	8.2005	24944940.0
2010-11-18 11:00:00	AMZN	Stock	8.201	8.2185	8.1812	8.2095	9777440.0
2010-11-18 12:00:00	AMZN	Stock	8.21	8.2475	8.2085	8.243	14981760.0

> showing 50 of 45,599 rows — these rows as CSV

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