PREVIEW / stock_1hour / 2009-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-28.parquet
  size:    891 KB
  rows:    42,578
  symbols: 3,409

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-10-28 04:00:00	AAPL	Stock	7.0	7.0304	6.995	6.995	40796.0
2009-10-28 05:00:00	AAPL	Stock	6.9929	7.0229	6.9929	6.9929	16100.0
2009-10-28 06:00:00	AAPL	Stock	6.9857	7.0071	6.9857	6.9982	60284.0
2009-10-28 07:00:00	AAPL	Stock	7.0211	7.0268	6.9918	7.0268	210336.0
2009-10-28 08:00:00	AAPL	Stock	7.0282	7.0757	7.0182	7.0643	1332968.0
2009-10-28 09:00:00	AAPL	Stock	7.0646	7.0893	6.9771	7.0346	129757320.0
2009-10-28 10:00:00	AAPL	Stock	7.0332	7.0721	6.8707	6.9236	192162740.0
2009-10-28 11:00:00	AAPL	Stock	6.9225	6.9604	6.9018	6.9318	91544180.0
2009-10-28 12:00:00	AAPL	Stock	6.9321	6.9532	6.8964	6.9029	61822208.0
2009-10-28 13:00:00	AAPL	Stock	6.9034	6.9461	6.825	6.914	80230584.0
2009-10-28 14:00:00	AAPL	Stock	6.9143	6.9196	6.8518	6.8982	101088960.0
2009-10-28 15:00:00	AAPL	Stock	6.8979	6.9224	6.835	6.8668	139763540.0
2009-10-28 16:00:00	AAPL	Stock	6.8711	7.1114	6.861	6.8679	11571000.0
2009-10-28 17:00:00	AAPL	Stock	6.8671	6.8714	6.8446	6.8446	611660.0
2009-10-28 18:00:00	AAPL	Stock	6.85	6.8714	6.8143	6.8143	1683472.0
2009-10-28 19:00:00	AAPL	Stock	6.8143	6.8264	6.8061	6.825	880404.0
2009-10-28 05:00:00	MSFT	Stock	28.38	28.38	28.38	28.38	100.0
2009-10-28 06:00:00	MSFT	Stock	28.29	28.29	28.29	28.29	375.0
2009-10-28 07:00:00	MSFT	Stock	28.29	28.31	28.25	28.27	7125.0
2009-10-28 08:00:00	MSFT	Stock	28.37	28.44	28.35	28.39	31430.0
2009-10-28 09:00:00	MSFT	Stock	28.61	28.7	28.1	28.592	7926882.0
2009-10-28 10:00:00	MSFT	Stock	28.59	28.77	28.41	28.41	13486541.0
2009-10-28 11:00:00	MSFT	Stock	28.41	28.44	28.3	28.35	8532268.0
2009-10-28 12:00:00	MSFT	Stock	28.35	28.43	28.02	28.13	9620438.0
2009-10-28 13:00:00	MSFT	Stock	28.135	28.38	28.13	28.22	5299123.0
2009-10-28 14:00:00	MSFT	Stock	28.225	28.305	27.98	28.1	9521120.0
2009-10-28 15:00:00	MSFT	Stock	28.108	28.16	27.95	28.04	14807349.0
2009-10-28 16:00:00	MSFT	Stock	28.03	28.296	27.97	27.99	2431029.0
2009-10-28 17:00:00	MSFT	Stock	27.99	28.02	27.97	27.99	13078.0
2009-10-28 18:00:00	MSFT	Stock	27.99	28.02	27.97	27.97	62610.0
2009-10-28 19:00:00	MSFT	Stock	27.97	27.98	27.93	27.98	10178.0
2009-10-28 08:00:00	NVDA	Stock	0.311	0.311	0.3062	0.3078	338920.0
2009-10-28 09:00:00	NVDA	Stock	0.308	0.3134	0.304	0.3115	117280800.0
2009-10-28 10:00:00	NVDA	Stock	0.3113	0.3114	0.3029	0.3048	152352440.0
2009-10-28 11:00:00	NVDA	Stock	0.3048	0.309	0.304	0.3078	69540400.0
2009-10-28 12:00:00	NVDA	Stock	0.3079	0.308	0.3018	0.3018	58116080.0
2009-10-28 13:00:00	NVDA	Stock	0.3019	0.305	0.301	0.3032	68613400.0
2009-10-28 14:00:00	NVDA	Stock	0.303	0.3035	0.302	0.3025	53080680.0
2009-10-28 15:00:00	NVDA	Stock	0.3025	0.3026	0.299	0.3008	234488040.0
2009-10-28 16:00:00	NVDA	Stock	0.3002	0.3047	0.2992	0.3	6528200.0
2009-10-28 17:00:00	NVDA	Stock	0.2992	0.2992	0.2992	0.2992	14120.0
2009-10-28 18:00:00	NVDA	Stock	0.2995	0.2995	0.2975	0.2978	93600.0
2009-10-28 19:00:00	NVDA	Stock	0.2978	0.2978	0.2978	0.2978	8000.0
2009-10-28 04:00:00	AMZN	Stock	6.0605	6.0985	6.0325	6.0905	32880.0
2009-10-28 05:00:00	AMZN	Stock	6.1035	6.1035	6.1035	6.1035	3120.0
2009-10-28 06:00:00	AMZN	Stock	6.0515	6.0515	6.0515	6.0515	2120.0
2009-10-28 07:00:00	AMZN	Stock	6.0875	6.0875	6.0515	6.059	36000.0
2009-10-28 08:00:00	AMZN	Stock	6.0605	6.1375	6.0605	6.1325	958580.0
2009-10-28 09:00:00	AMZN	Stock	6.1255	6.16	6.053	6.1375	35196260.0
2009-10-28 10:00:00	AMZN	Stock	6.1355	6.256	6.122	6.186	103133480.0

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

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