PREVIEW / stock_1hour / 2010-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-17.parquet
  size:    888 KB
  rows:    42,823
  symbols: 3,445

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-06-17 04:00:00	AAPL	Stock	9.5789	9.5789	9.5789	9.5789	2800.0
2010-06-17 05:00:00	AAPL	Stock	9.6054	9.6054	9.6054	9.6054	8400.0
2010-06-17 07:00:00	AAPL	Stock	9.5896	9.6304	9.5893	9.6143	1102444.0
2010-06-17 08:00:00	AAPL	Stock	9.6143	9.6479	9.5446	9.6379	8336132.0
2010-06-17 09:00:00	AAPL	Stock	9.6379	9.7282	9.6325	9.7275	189468300.0
2010-06-17 10:00:00	AAPL	Stock	9.7271	9.7464	9.625	9.6786	231301112.0
2010-06-17 11:00:00	AAPL	Stock	9.6791	9.7114	9.6443	9.7026	90881308.0
2010-06-17 12:00:00	AAPL	Stock	9.7026	9.7071	9.6611	9.6779	49349524.0
2010-06-17 13:00:00	AAPL	Stock	9.6779	9.7214	9.6643	9.7182	50590484.0
2010-06-17 14:00:00	AAPL	Stock	9.7193	9.7268	9.6721	9.7007	72192484.0
2010-06-17 15:00:00	AAPL	Stock	9.6996	9.7193	9.6393	9.7079	153318200.0
2010-06-17 16:00:00	AAPL	Stock	9.7096	9.7161	9.6554	9.7125	11828320.0
2010-06-17 17:00:00	AAPL	Stock	9.7125	9.7154	9.7107	9.7125	411376.0
2010-06-17 18:00:00	AAPL	Stock	9.7107	9.7232	9.7082	9.7211	1446144.0
2010-06-17 19:00:00	AAPL	Stock	9.7211	9.7261	9.7179	9.7179	459536.0
2010-06-17 05:00:00	MSFT	Stock	26.38	26.38	26.38	26.38	1000.0
2010-06-17 07:00:00	MSFT	Stock	26.31	26.36	26.31	26.36	700.0
2010-06-17 08:00:00	MSFT	Stock	26.5	26.5	26.32	26.42	43475.0
2010-06-17 09:00:00	MSFT	Stock	26.43	26.67	26.38	26.41	6090409.0
2010-06-17 10:00:00	MSFT	Stock	26.41	26.41	26.18	26.241	9357171.0
2010-06-17 11:00:00	MSFT	Stock	26.24	26.31	26.15	26.23	4877455.0
2010-06-17 12:00:00	MSFT	Stock	26.235	26.24	26.08	26.15	4534317.0
2010-06-17 13:00:00	MSFT	Stock	26.155	26.28	26.04	26.27	3537050.0
2010-06-17 14:00:00	MSFT	Stock	26.28	26.33	26.11	26.13	3616531.0
2010-06-17 15:00:00	MSFT	Stock	26.14	26.38	26.06	26.37	11928667.0
2010-06-17 16:00:00	MSFT	Stock	26.37	26.38	26.138	26.38	3066946.0
2010-06-17 17:00:00	MSFT	Stock	26.36	26.4	26.35	26.4	8000.0
2010-06-17 18:00:00	MSFT	Stock	26.39	26.4	26.39	26.4	400.0
2010-06-17 19:00:00	MSFT	Stock	26.37	26.38	26.28	26.38	2800.0
2010-06-17 08:00:00	NVDA	Stock	0.3025	0.3062	0.3012	0.3048	2483440.0
2010-06-17 09:00:00	NVDA	Stock	0.305	0.3062	0.297	0.301	122417760.0
2010-06-17 10:00:00	NVDA	Stock	0.301	0.3012	0.294	0.2992	162892120.0
2010-06-17 11:00:00	NVDA	Stock	0.2992	0.3015	0.2972	0.301	86344000.0
2010-06-17 12:00:00	NVDA	Stock	0.301	0.301	0.2975	0.2988	57899720.0
2010-06-17 13:00:00	NVDA	Stock	0.2985	0.3028	0.298	0.3028	61605120.0
2010-06-17 14:00:00	NVDA	Stock	0.3028	0.3042	0.301	0.3028	78692360.0
2010-06-17 15:00:00	NVDA	Stock	0.3029	0.3055	0.301	0.3052	226380720.0
2010-06-17 16:00:00	NVDA	Stock	0.3052	0.3065	0.3008	0.3062	8185360.0
2010-06-17 17:00:00	NVDA	Stock	0.3062	0.3062	0.3062	0.3062	97800.0
2010-06-17 18:00:00	NVDA	Stock	0.3062	0.307	0.3062	0.3062	198000.0
2010-06-17 19:00:00	NVDA	Stock	0.3062	0.3062	0.3055	0.3062	94000.0
2010-06-17 07:00:00	AMZN	Stock	6.3625	6.3625	6.3625	6.3625	2000.0
2010-06-17 08:00:00	AMZN	Stock	6.3525	6.355	6.3315	6.3315	81740.0
2010-06-17 09:00:00	AMZN	Stock	6.3495	6.39	6.2935	6.342	13246200.0
2010-06-17 10:00:00	AMZN	Stock	6.3415	6.3465	6.239	6.2521	15002240.0
2010-06-17 11:00:00	AMZN	Stock	6.2545	6.311	6.2345	6.3018	8411560.0
2010-06-17 12:00:00	AMZN	Stock	6.304	6.3115	6.2795	6.2848	5375160.0
2010-06-17 13:00:00	AMZN	Stock	6.281	6.3235	6.27	6.3235	4532900.0
2010-06-17 14:00:00	AMZN	Stock	6.323	6.3315	6.2675	6.2755	4854460.0
2010-06-17 15:00:00	AMZN	Stock	6.2755	6.3025	6.2386	6.294	15281740.0

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

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