PREVIEW / stock_1hour / 2010-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-24.parquet
  size:    927 KB
  rows:    45,484
  symbols: 3,474

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-08-24 04:00:00	AAPL	Stock	8.75	8.75	8.75	8.75	11200.0
2010-08-24 07:00:00	AAPL	Stock	8.7232	8.7232	8.6929	8.6957	370580.0
2010-08-24 08:00:00	AAPL	Stock	8.7036	8.7446	8.6418	8.6536	3377052.0
2010-08-24 09:00:00	AAPL	Stock	8.6486	8.6818	8.5754	8.5875	115515624.0
2010-08-24 10:00:00	AAPL	Stock	8.5871	8.6411	8.5232	8.6386	155731044.0
2010-08-24 11:00:00	AAPL	Stock	8.6386	8.6786	8.6286	8.6393	70543032.0
2010-08-24 12:00:00	AAPL	Stock	8.6386	8.6575	8.6	8.6011	39454856.0
2010-08-24 13:00:00	AAPL	Stock	8.6018	8.63	8.5875	8.5888	38536288.0
2010-08-24 14:00:00	AAPL	Stock	8.5893	8.6064	8.5721	8.5893	48479088.0
2010-08-24 15:00:00	AAPL	Stock	8.5906	8.6286	8.5664	8.5804	102482016.0
2010-08-24 16:00:00	AAPL	Stock	8.5804	8.7739	8.5689	8.5757	18821488.0
2010-08-24 17:00:00	AAPL	Stock	8.6482	8.6482	8.5671	8.5714	2414916.0
2010-08-24 18:00:00	AAPL	Stock	8.5682	8.5711	8.5218	8.5475	860412.0
2010-08-24 19:00:00	AAPL	Stock	8.5386	8.5679	8.5196	8.5661	873880.0
2010-08-24 05:00:00	MSFT	Stock	24.1	24.1	24.1	24.1	100.0
2010-08-24 07:00:00	MSFT	Stock	24.22	24.22	24.15	24.15	6500.0
2010-08-24 08:00:00	MSFT	Stock	24.18	24.28	24.01	24.01	501823.0
2010-08-24 09:00:00	MSFT	Stock	24.01	24.22	24.0	24.17	6901957.0
2010-08-24 10:00:00	MSFT	Stock	24.17	24.17	24.01	24.156	9468677.0
2010-08-24 11:00:00	MSFT	Stock	24.16	24.35	24.15	24.25	9102307.0
2010-08-24 12:00:00	MSFT	Stock	24.255	24.26	24.14	24.16	7561991.0
2010-08-24 13:00:00	MSFT	Stock	24.17	24.2	24.03	24.08	5769194.0
2010-08-24 14:00:00	MSFT	Stock	24.08	24.2	24.06	24.19	6833255.0
2010-08-24 15:00:00	MSFT	Stock	24.19	24.25	24.03	24.06	13097678.0
2010-08-24 16:00:00	MSFT	Stock	24.04	24.412	24.02	24.07	6460419.0
2010-08-24 17:00:00	MSFT	Stock	24.22	24.22	24.04	24.04	215270.0
2010-08-24 18:00:00	MSFT	Stock	24.04	24.04	24.02	24.02	55607.0
2010-08-24 19:00:00	MSFT	Stock	24.03	24.03	24.0	24.03	4900.0
2010-08-24 08:00:00	NVDA	Stock	0.2415	0.2418	0.2362	0.2368	1533600.0
2010-08-24 09:00:00	NVDA	Stock	0.237	0.2442	0.234	0.2422	97727080.0
2010-08-24 10:00:00	NVDA	Stock	0.2421	0.2435	0.2382	0.2434	143997280.0
2010-08-24 11:00:00	NVDA	Stock	0.2435	0.2455	0.2428	0.2443	75752520.0
2010-08-24 12:00:00	NVDA	Stock	0.2442	0.2455	0.2434	0.244	51788960.0
2010-08-24 13:00:00	NVDA	Stock	0.2442	0.2453	0.2432	0.2442	46913720.0
2010-08-24 14:00:00	NVDA	Stock	0.2442	0.245	0.244	0.2448	53551600.0
2010-08-24 15:00:00	NVDA	Stock	0.2448	0.2453	0.2425	0.2432	141067400.0
2010-08-24 16:00:00	NVDA	Stock	0.2432	0.2438	0.2408	0.2435	14311600.0
2010-08-24 17:00:00	NVDA	Stock	0.244	0.244	0.243	0.2435	1918880.0
2010-08-24 18:00:00	NVDA	Stock	0.2435	0.2438	0.2418	0.243	688000.0
2010-08-24 19:00:00	NVDA	Stock	0.2422	0.2422	0.2415	0.2415	281040.0
2010-08-24 04:00:00	AMZN	Stock	6.3	6.3	6.3	6.3	4000.0
2010-08-24 07:00:00	AMZN	Stock	6.275	6.275	6.275	6.275	2000.0
2010-08-24 08:00:00	AMZN	Stock	6.288	6.288	6.2505	6.2625	69460.0
2010-08-24 09:00:00	AMZN	Stock	6.2595	6.275	6.1875	6.1935	14082500.0
2010-08-24 10:00:00	AMZN	Stock	6.193	6.204	6.159	6.202	20535320.0
2010-08-24 11:00:00	AMZN	Stock	6.2025	6.2375	6.1935	6.2085	10817920.0
2010-08-24 12:00:00	AMZN	Stock	6.2085	6.231	6.192	6.1995	7412560.0
2010-08-24 13:00:00	AMZN	Stock	6.2	6.22	6.1855	6.1973	8903920.0
2010-08-24 14:00:00	AMZN	Stock	6.1969	6.237	6.185	6.237	10311180.0
2010-08-24 15:00:00	AMZN	Stock	6.2375	6.266	6.224	6.2265	26968760.0

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

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