PREVIEW / stock_1hour / 2010-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-28.parquet
  size:    930 KB
  rows:    44,923
  symbols: 3,470

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-10-28 04:00:00	AAPL	Stock	10.93	10.93	10.93	10.93	2800.0
2010-10-28 05:00:00	AAPL	Stock	10.9657	10.9657	10.9596	10.9643	11200.0
2010-10-28 06:00:00	AAPL	Stock	10.9643	10.9643	10.9643	10.9643	2800.0
2010-10-28 07:00:00	AAPL	Stock	10.9286	10.9625	10.9286	10.95	519680.0
2010-10-28 08:00:00	AAPL	Stock	10.9518	11.0071	10.9329	10.9914	7406168.0
2010-10-28 09:00:00	AAPL	Stock	10.9921	11.0175	10.9082	10.9229	69108536.0
2010-10-28 10:00:00	AAPL	Stock	10.9246	10.9579	10.8364	10.8511	107816772.0
2010-10-28 11:00:00	AAPL	Stock	10.8497	10.8864	10.8439	10.8536	42276668.0
2010-10-28 12:00:00	AAPL	Stock	10.8525	10.8529	10.7636	10.7654	68651716.0
2010-10-28 13:00:00	AAPL	Stock	10.7639	10.8571	10.7464	10.8393	81157048.0
2010-10-28 14:00:00	AAPL	Stock	10.8382	10.9075	10.8361	10.8864	62858488.0
2010-10-28 15:00:00	AAPL	Stock	10.8864	10.9443	10.8732	10.9011	98051688.0
2010-10-28 16:00:00	AAPL	Stock	10.9014	10.9334	10.8761	10.9139	8746248.0
2010-10-28 17:00:00	AAPL	Stock	10.9132	10.9161	10.8979	10.9011	676312.0
2010-10-28 18:00:00	AAPL	Stock	10.9	10.9014	10.8825	10.8871	415436.0
2010-10-28 19:00:00	AAPL	Stock	10.8871	10.8939	10.8629	10.89	1838760.0
2010-10-28 05:00:00	MSFT	Stock	26.15	26.15	26.15	26.15	100.0
2010-10-28 07:00:00	MSFT	Stock	26.13	26.13	26.01	26.11	2100.0
2010-10-28 08:00:00	MSFT	Stock	26.1	26.21	25.96	26.17	80977.0
2010-10-28 09:00:00	MSFT	Stock	26.16	26.25	26.1	26.21	7034741.0
2010-10-28 10:00:00	MSFT	Stock	26.21	26.32	26.01	26.064	9800713.0
2010-10-28 11:00:00	MSFT	Stock	26.06	26.18	25.95	25.97	6118725.0
2010-10-28 12:00:00	MSFT	Stock	25.97	26.12	25.92	26.09	6482302.0
2010-10-28 13:00:00	MSFT	Stock	26.09	26.25	26.05	26.21	6826016.0
2010-10-28 14:00:00	MSFT	Stock	26.21	26.38	26.2	26.3	10765635.0
2010-10-28 15:00:00	MSFT	Stock	26.3	26.37	26.16	26.27	18659737.0
2010-10-28 16:00:00	MSFT	Stock	26.27	27.23	26.195	27.18	10908198.0
2010-10-28 17:00:00	MSFT	Stock	27.18	27.21	27.03	27.1	1039452.0
2010-10-28 18:00:00	MSFT	Stock	27.1	27.21	26.28	27.18	290980.0
2010-10-28 19:00:00	MSFT	Stock	27.2	27.22	27.16	27.18	82606.0
2010-10-28 08:00:00	NVDA	Stock	0.302	0.3025	0.301	0.3022	162240.0
2010-10-28 09:00:00	NVDA	Stock	0.3025	0.3052	0.3008	0.3026	70564680.0
2010-10-28 10:00:00	NVDA	Stock	0.3028	0.304	0.2985	0.3012	106463800.0
2010-10-28 11:00:00	NVDA	Stock	0.3012	0.3032	0.3008	0.3016	48576400.0
2010-10-28 12:00:00	NVDA	Stock	0.3015	0.3022	0.3	0.301	38897560.0
2010-10-28 13:00:00	NVDA	Stock	0.3012	0.3042	0.3005	0.3031	75270960.0
2010-10-28 14:00:00	NVDA	Stock	0.303	0.306	0.303	0.304	78532960.0
2010-10-28 15:00:00	NVDA	Stock	0.3041	0.3048	0.3005	0.301	273629040.0
2010-10-28 16:00:00	NVDA	Stock	0.3012	0.3038	0.2996	0.3038	8462400.0
2010-10-28 18:00:00	NVDA	Stock	0.3025	0.3025	0.3008	0.3008	262000.0
2010-10-28 19:00:00	NVDA	Stock	0.3012	0.3012	0.3012	0.3012	112000.0
2010-10-28 08:00:00	AMZN	Stock	8.3585	8.427	8.3585	8.425	235640.0
2010-10-28 09:00:00	AMZN	Stock	8.427	8.4285	8.3355	8.3521	14414360.0
2010-10-28 10:00:00	AMZN	Stock	8.3525	8.3745	8.2865	8.313	17676700.0
2010-10-28 11:00:00	AMZN	Stock	8.314	8.32	8.2825	8.283	10690820.0
2010-10-28 12:00:00	AMZN	Stock	8.2845	8.2915	8.2525	8.272	10799020.0
2010-10-28 13:00:00	AMZN	Stock	8.2715	8.3329	8.262	8.3045	10458920.0
2010-10-28 14:00:00	AMZN	Stock	8.3045	8.343	8.2978	8.332	9000760.0
2010-10-28 15:00:00	AMZN	Stock	8.3305	8.35	8.305	8.344	16953080.0
2010-10-28 16:00:00	AMZN	Stock	8.342	8.343	8.3262	8.3375	2225660.0

> showing 50 of 44,923 rows — these rows as CSV

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