PREVIEW / stock_1hour / 2009-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-07.parquet
  size:    875 KB
  rows:    42,013
  symbols: 3,371

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-08-07 05:00:00	AAPL	Stock	5.8393	5.8393	5.7993	5.7993	28000.0
2009-08-07 06:00:00	AAPL	Stock	5.8304	5.8304	5.8304	5.8304	5600.0
2009-08-07 07:00:00	AAPL	Stock	5.8304	5.8536	5.8286	5.8536	59780.0
2009-08-07 08:00:00	AAPL	Stock	5.8525	5.9214	5.8436	5.9143	3286584.0
2009-08-07 09:00:00	AAPL	Stock	5.9136	5.9304	5.8864	5.9036	59426444.0
2009-08-07 10:00:00	AAPL	Stock	5.9036	5.9368	5.8857	5.9311	71751792.0
2009-08-07 11:00:00	AAPL	Stock	5.9318	5.9425	5.9175	5.9318	53847220.0
2009-08-07 12:00:00	AAPL	Stock	5.9321	5.95	5.9314	5.94	39950652.0
2009-08-07 13:00:00	AAPL	Stock	5.9407	5.9496	5.9296	5.9375	33975368.0
2009-08-07 14:00:00	AAPL	Stock	5.9382	5.9439	5.9286	5.9318	30063824.0
2009-08-07 15:00:00	AAPL	Stock	5.9321	5.9332	5.9107	5.9136	77539056.0
2009-08-07 16:00:00	AAPL	Stock	5.9125	5.9367	5.9093	5.9125	14152432.0
2009-08-07 17:00:00	AAPL	Stock	5.9154	5.9154	5.91	5.9125	148652.0
2009-08-07 18:00:00	AAPL	Stock	5.9154	5.9193	5.9146	5.9193	374976.0
2009-08-07 19:00:00	AAPL	Stock	5.9179	5.9286	5.9171	5.9171	119840.0
2009-08-07 07:00:00	MSFT	Stock	23.46	23.46	23.46	23.46	500.0
2009-08-07 08:00:00	MSFT	Stock	23.4	23.82	23.4	23.64	81945.0
2009-08-07 09:00:00	MSFT	Stock	23.64	23.82	23.61	23.7	5614275.0
2009-08-07 10:00:00	MSFT	Stock	23.69	23.76	23.5	23.75	8490343.0
2009-08-07 11:00:00	MSFT	Stock	23.743	23.8	23.68	23.76	4759927.0
2009-08-07 12:00:00	MSFT	Stock	23.75	23.78	23.65	23.74	4893793.0
2009-08-07 13:00:00	MSFT	Stock	23.75	23.78	23.66	23.67	3848356.0
2009-08-07 14:00:00	MSFT	Stock	23.67	23.71	23.57	23.59	5044380.0
2009-08-07 15:00:00	MSFT	Stock	23.6	23.68	23.56	23.57	10127710.0
2009-08-07 16:00:00	MSFT	Stock	23.59	23.676	23.55	23.55	2727201.0
2009-08-07 17:00:00	MSFT	Stock	23.55	23.59	23.54	23.59	4677.0
2009-08-07 18:00:00	MSFT	Stock	23.58	23.59	23.56	23.59	3570.0
2009-08-07 19:00:00	MSFT	Stock	23.59	23.59	23.57	23.59	1830.0
2009-08-07 06:00:00	NVDA	Stock	0.35	0.35	0.35	0.35	40000.0
2009-08-07 07:00:00	NVDA	Stock	0.3398	0.3505	0.3338	0.35	5544000.0
2009-08-07 08:00:00	NVDA	Stock	0.349	0.3562	0.3475	0.3488	18440480.0
2009-08-07 09:00:00	NVDA	Stock	0.3488	0.3558	0.338	0.349	458995200.0
2009-08-07 10:00:00	NVDA	Stock	0.349	0.3502	0.342	0.3453	380369200.0
2009-08-07 11:00:00	NVDA	Stock	0.3455	0.3478	0.344	0.3457	141508200.0
2009-08-07 12:00:00	NVDA	Stock	0.3455	0.3462	0.3438	0.345	101359720.0
2009-08-07 13:00:00	NVDA	Stock	0.345	0.3473	0.3448	0.3454	74065480.0
2009-08-07 14:00:00	NVDA	Stock	0.3455	0.3488	0.3428	0.345	88374040.0
2009-08-07 15:00:00	NVDA	Stock	0.3448	0.345	0.3425	0.3428	115616320.0
2009-08-07 16:00:00	NVDA	Stock	0.3425	0.346	0.3425	0.3438	16282960.0
2009-08-07 17:00:00	NVDA	Stock	0.3438	0.3438	0.3413	0.3413	61400.0
2009-08-07 18:00:00	NVDA	Stock	0.343	0.343	0.343	0.343	4000.0
2009-08-07 19:00:00	NVDA	Stock	0.3425	0.343	0.3425	0.343	22000.0
2009-08-07 08:00:00	AMZN	Stock	4.215	4.245	4.2	4.2175	320680.0
2009-08-07 09:00:00	AMZN	Stock	4.2115	4.298	4.2005	4.2665	24455380.0
2009-08-07 10:00:00	AMZN	Stock	4.266	4.281	4.217	4.273	23326320.0
2009-08-07 11:00:00	AMZN	Stock	4.272	4.282	4.2458	4.2595	11045280.0
2009-08-07 12:00:00	AMZN	Stock	4.2595	4.266	4.2395	4.241	6390540.0
2009-08-07 13:00:00	AMZN	Stock	4.2425	4.2876	4.2425	4.283	11513400.0
2009-08-07 14:00:00	AMZN	Stock	4.282	4.2895	4.2765	4.283	6918380.0
2009-08-07 15:00:00	AMZN	Stock	4.2835	4.2885	4.261	4.2665	25223880.0

> showing 50 of 42,013 rows — these rows as CSV

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