PREVIEW / stock_1hour / 2008-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-18.parquet
  size:    826 KB
  rows:    40,022
  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-08-18 04:00:00	AAPL	Stock	6.25	6.25	6.25	6.25	7000.0
2008-08-18 07:00:00	AAPL	Stock	6.2993	6.3143	6.2964	6.3036	249536.0
2008-08-18 08:00:00	AAPL	Stock	6.3036	6.3104	6.2682	6.2932	1647912.0
2008-08-18 09:00:00	AAPL	Stock	6.2936	6.3286	6.2589	6.3214	82672828.0
2008-08-18 10:00:00	AAPL	Stock	6.3236	6.3504	6.2646	6.3368	105748160.0
2008-08-18 11:00:00	AAPL	Stock	6.3382	6.3496	6.2932	6.2936	49337708.0
2008-08-18 12:00:00	AAPL	Stock	6.2936	6.3071	6.2589	6.263	65564576.0
2008-08-18 13:00:00	AAPL	Stock	6.263	6.3018	6.2536	6.2629	48225968.0
2008-08-18 14:00:00	AAPL	Stock	6.2629	6.2896	6.2554	6.2596	54362224.0
2008-08-18 15:00:00	AAPL	Stock	6.2606	6.2739	6.2079	6.265	117081608.0
2008-08-18 16:00:00	AAPL	Stock	6.2671	6.2813	6.2333	6.2743	18470984.0
2008-08-18 17:00:00	AAPL	Stock	6.2718	6.2718	6.2643	6.2675	251188.0
2008-08-18 18:00:00	AAPL	Stock	6.2577	6.2818	6.2577	6.2779	191184.0
2008-08-18 19:00:00	AAPL	Stock	6.2814	6.2893	6.2786	6.2893	379484.0
2008-08-18 08:00:00	MSFT	Stock	27.81	27.91	27.81	27.85	300.0
2008-08-18 09:00:00	MSFT	Stock	27.89	27.98	27.78	27.96	3989815.0
2008-08-18 10:00:00	MSFT	Stock	27.96	27.98	27.79	27.96	5708079.0
2008-08-18 11:00:00	MSFT	Stock	27.95	28.05	27.77	27.77	3271100.0
2008-08-18 12:00:00	MSFT	Stock	27.77	27.79	27.63	27.649	4837565.0
2008-08-18 13:00:00	MSFT	Stock	27.65	27.74	27.58	27.6	2861450.0
2008-08-18 14:00:00	MSFT	Stock	27.6	27.68	27.575	27.66	3115706.0
2008-08-18 15:00:00	MSFT	Stock	27.652	27.76	27.55	27.71	8597514.0
2008-08-18 16:00:00	MSFT	Stock	27.73	27.894	27.601	27.69	4682925.0
2008-08-18 17:00:00	MSFT	Stock	27.77	27.77	27.75	27.76	1070.0
2008-08-18 18:00:00	MSFT	Stock	27.638	27.77	27.638	27.77	31649.0
2008-08-18 19:00:00	MSFT	Stock	27.76	27.77	27.76	27.77	4490.0
2008-08-18 08:00:00	NVDA	Stock	0.3235	0.3275	0.3235	0.325	229840.0
2008-08-18 09:00:00	NVDA	Stock	0.3275	0.3295	0.3228	0.325	75339400.0
2008-08-18 10:00:00	NVDA	Stock	0.325	0.3305	0.3245	0.329	149723400.0
2008-08-18 11:00:00	NVDA	Stock	0.3291	0.33	0.3275	0.329	101144040.0
2008-08-18 12:00:00	NVDA	Stock	0.329	0.3298	0.3275	0.3293	100475200.0
2008-08-18 13:00:00	NVDA	Stock	0.3295	0.332	0.3288	0.3298	108555480.0
2008-08-18 14:00:00	NVDA	Stock	0.33	0.331	0.329	0.3303	120226560.0
2008-08-18 15:00:00	NVDA	Stock	0.33	0.3335	0.3295	0.3313	198619480.0
2008-08-18 16:00:00	NVDA	Stock	0.3315	0.333	0.3281	0.3308	12684920.0
2008-08-18 17:00:00	NVDA	Stock	0.3308	0.3308	0.33	0.33	680960.0
2008-08-18 18:00:00	NVDA	Stock	0.3305	0.3305	0.33	0.33	241040.0
2008-08-18 19:00:00	NVDA	Stock	0.33	0.33	0.33	0.33	75360.0
2008-08-18 09:00:00	AMZN	Stock	4.322	4.3225	4.2615	4.282	11234660.0
2008-08-18 10:00:00	AMZN	Stock	4.282	4.282	4.2345	4.253	22208140.0
2008-08-18 11:00:00	AMZN	Stock	4.252	4.263	4.238	4.24	15640980.0
2008-08-18 12:00:00	AMZN	Stock	4.24	4.249	4.188	4.198	16086700.0
2008-08-18 13:00:00	AMZN	Stock	4.1965	4.2315	4.195	4.1975	10853480.0
2008-08-18 14:00:00	AMZN	Stock	4.1975	4.2095	4.17	4.1765	15549200.0
2008-08-18 15:00:00	AMZN	Stock	4.1775	4.1975	4.152	4.1635	29902740.0
2008-08-18 16:00:00	AMZN	Stock	4.1621	4.2196	4.153	4.1795	5569680.0
2008-08-18 17:00:00	AMZN	Stock	4.175	4.175	4.175	4.175	2000.0
2008-08-18 19:00:00	AMZN	Stock	4.165	4.165	4.165	4.165	2000.0
2008-08-18 09:00:00	TLT	Stock	93.08	93.19	92.96	93.15	196842.0
2008-08-18 10:00:00	TLT	Stock	93.16	93.36	93.16	93.21	225093.0

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

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