PREVIEW / stock_1hour / 2008-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-12.parquet
  size:    824 KB
  rows:    40,477
  symbols: 3,313

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
2008-09-12 07:00:00	AAPL	Stock	5.4711	5.4711	5.4182	5.4289	11200.0
2008-09-12 08:00:00	AAPL	Stock	5.4289	5.455	5.3946	5.3982	1517852.0
2008-09-12 09:00:00	AAPL	Stock	5.3986	5.4036	5.29	5.2979	107065224.0
2008-09-12 10:00:00	AAPL	Stock	5.2982	5.3193	5.2321	5.2561	168422800.0
2008-09-12 11:00:00	AAPL	Stock	5.2564	5.3643	5.255	5.3118	144457068.0
2008-09-12 12:00:00	AAPL	Stock	5.3125	5.325	5.2536	5.2636	72441348.0
2008-09-12 13:00:00	AAPL	Stock	5.2636	5.3082	5.245	5.2993	68839260.0
2008-09-12 14:00:00	AAPL	Stock	5.2996	5.3761	5.2639	5.3654	99649956.0
2008-09-12 15:00:00	AAPL	Stock	5.3651	5.3675	5.2929	5.3186	112285096.0
2008-09-12 16:00:00	AAPL	Stock	5.3186	5.3329	5.3018	5.3268	8520456.0
2008-09-12 17:00:00	AAPL	Stock	5.3214	5.325	5.3125	5.3125	1086680.0
2008-09-12 18:00:00	AAPL	Stock	5.3171	5.3204	5.3143	5.3143	170128.0
2008-09-12 19:00:00	AAPL	Stock	5.3143	5.3179	5.3136	5.3179	156436.0
2008-09-12 20:00:00	AAPL	Stock	5.3536	5.3536	5.3536	5.3536	2800.0
2008-09-12 07:00:00	MSFT	Stock	27.34	27.34	27.34	27.34	200.0
2008-09-12 08:00:00	MSFT	Stock	27.14	27.2	27.13	27.2	2350.0
2008-09-12 09:00:00	MSFT	Stock	27.18	27.25	26.94	27.04	5686773.0
2008-09-12 10:00:00	MSFT	Stock	27.04	27.38	27.02	27.38	12158977.0
2008-09-12 11:00:00	MSFT	Stock	27.39	27.62	27.35	27.549	13096445.0
2008-09-12 12:00:00	MSFT	Stock	27.54	27.66	27.44	27.46	9696898.0
2008-09-12 13:00:00	MSFT	Stock	27.46	27.53	27.37	27.523	7744682.0
2008-09-12 14:00:00	MSFT	Stock	27.52	27.72	27.45	27.7	8974663.0
2008-09-12 15:00:00	MSFT	Stock	27.7	27.74	27.49	27.65	12873565.0
2008-09-12 16:00:00	MSFT	Stock	27.65	27.68	27.442	27.5	2633106.0
2008-09-12 17:00:00	MSFT	Stock	27.63	27.63	27.6	27.6	200.0
2008-09-12 18:00:00	MSFT	Stock	27.6	27.65	27.6	27.62	2100.0
2008-09-12 19:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	450.0
2008-09-12 20:00:00	MSFT	Stock	27.59	27.59	27.59	27.59	55700.0
2008-09-12 08:00:00	NVDA	Stock	0.2563	0.2563	0.2538	0.2538	12000.0
2008-09-12 09:00:00	NVDA	Stock	0.255	0.256	0.2442	0.2442	183293280.0
2008-09-12 10:00:00	NVDA	Stock	0.2445	0.245	0.2402	0.2432	300745280.0
2008-09-12 11:00:00	NVDA	Stock	0.2431	0.249	0.2425	0.2482	170206960.0
2008-09-12 12:00:00	NVDA	Stock	0.248	0.2513	0.2475	0.2498	158558440.0
2008-09-12 13:00:00	NVDA	Stock	0.2495	0.2533	0.2488	0.2523	120117120.0
2008-09-12 14:00:00	NVDA	Stock	0.2523	0.257	0.251	0.2563	103635600.0
2008-09-12 15:00:00	NVDA	Stock	0.2563	0.2565	0.2535	0.255	134638320.0
2008-09-12 16:00:00	NVDA	Stock	0.255	0.2563	0.2484	0.2547	11427880.0
2008-09-12 17:00:00	NVDA	Stock	0.2439	0.2547	0.2439	0.2547	884560.0
2008-09-12 18:00:00	NVDA	Stock	0.2547	0.2547	0.2545	0.2545	48000.0
2008-09-12 19:00:00	NVDA	Stock	0.2545	0.2545	0.25	0.25	40000.0
2008-09-12 08:00:00	AMZN	Stock	3.9265	3.9305	3.9265	3.9305	12000.0
2008-09-12 09:00:00	AMZN	Stock	3.932	3.945	3.85	3.856	19868220.0
2008-09-12 10:00:00	AMZN	Stock	3.856	3.9155	3.831	3.9005	22192160.0
2008-09-12 11:00:00	AMZN	Stock	3.899	3.98	3.8875	3.941	20905060.0
2008-09-12 12:00:00	AMZN	Stock	3.941	3.95	3.887	3.8935	13047440.0
2008-09-12 13:00:00	AMZN	Stock	3.894	3.925	3.866	3.924	14381900.0
2008-09-12 14:00:00	AMZN	Stock	3.9235	3.937	3.898	3.928	10674820.0
2008-09-12 15:00:00	AMZN	Stock	3.931	3.9415	3.894	3.915	21661900.0
2008-09-12 16:00:00	AMZN	Stock	3.915	3.924	3.904	3.915	4048280.0
2008-09-12 17:00:00	AMZN	Stock	3.915	3.9245	3.915	3.9245	424000.0

> showing 50 of 40,477 rows — these rows as CSV

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