PREVIEW / stock_1hour / 2010-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-09.parquet
  size:    890 KB
  rows:    42,784
  symbols: 3,454

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-09 04:00:00	AAPL	Stock	9.0036	9.0036	8.8807	8.9107	45220.0
2010-06-09 05:00:00	AAPL	Stock	8.9404	8.9404	8.9196	8.9304	22232.0
2010-06-09 06:00:00	AAPL	Stock	8.9464	8.9464	8.9429	8.9429	5600.0
2010-06-09 07:00:00	AAPL	Stock	8.9461	9.0111	8.9332	9.0111	280980.0
2010-06-09 08:00:00	AAPL	Stock	9.0	9.0075	8.9504	8.9814	3168452.0
2010-06-09 09:00:00	AAPL	Stock	8.9811	8.9964	8.875	8.8943	109551764.0
2010-06-09 10:00:00	AAPL	Stock	8.8943	8.9071	8.8	8.8802	148750728.0
2010-06-09 11:00:00	AAPL	Stock	8.8796	8.9478	8.8793	8.9046	112132524.0
2010-06-09 12:00:00	AAPL	Stock	8.9039	8.9789	8.8896	8.8957	75357296.0
2010-06-09 13:00:00	AAPL	Stock	8.8964	8.9121	8.8082	8.8386	80722768.0
2010-06-09 14:00:00	AAPL	Stock	8.8414	8.8707	8.775	8.775	103793928.0
2010-06-09 15:00:00	AAPL	Stock	8.7754	8.7989	8.6604	8.6861	200684876.0
2010-06-09 16:00:00	AAPL	Stock	8.6909	8.755	8.6786	8.6929	9786700.0
2010-06-09 17:00:00	AAPL	Stock	8.6964	8.6964	8.6696	8.6818	1501248.0
2010-06-09 18:00:00	AAPL	Stock	8.6768	8.6911	8.6768	8.6882	508088.0
2010-06-09 19:00:00	AAPL	Stock	8.6911	8.6911	8.6746	8.6854	401240.0
2010-06-09 20:00:00	AAPL	Stock	8.9096	8.9096	8.9096	8.9096	539000.0
2010-06-09 07:00:00	MSFT	Stock	25.14	25.14	25.14	25.14	500.0
2010-06-09 08:00:00	MSFT	Stock	25.18	25.3	25.11	25.28	603139.0
2010-06-09 09:00:00	MSFT	Stock	25.27	25.33	25.05	25.19	8819105.0
2010-06-09 10:00:00	MSFT	Stock	25.19	25.35	25.11	25.31	14237160.0
2010-06-09 11:00:00	MSFT	Stock	25.31	25.52	25.11	25.358	10553191.0
2010-06-09 12:00:00	MSFT	Stock	25.35	25.41	25.11	25.34	5386139.0
2010-06-09 13:00:00	MSFT	Stock	25.343	25.39	25.25	25.29	6000114.0
2010-06-09 14:00:00	MSFT	Stock	25.3	25.3	24.97	25.0	9624516.0
2010-06-09 15:00:00	MSFT	Stock	24.99	25.05	24.75	24.78	16283440.0
2010-06-09 16:00:00	MSFT	Stock	24.78	25.173	24.69	24.8	8727837.0
2010-06-09 17:00:00	MSFT	Stock	24.81	24.82	24.77	24.77	16398.0
2010-06-09 18:00:00	MSFT	Stock	24.79	24.81	24.79	24.8	628401.0
2010-06-09 19:00:00	MSFT	Stock	24.8	24.85	24.78	24.85	4714.0
2010-06-09 08:00:00	NVDA	Stock	0.282	0.2822	0.282	0.2822	68000.0
2010-06-09 09:00:00	NVDA	Stock	0.2842	0.2845	0.2792	0.2798	71601480.0
2010-06-09 10:00:00	NVDA	Stock	0.2798	0.2838	0.2792	0.2835	134111840.0
2010-06-09 11:00:00	NVDA	Stock	0.2835	0.2885	0.2832	0.2858	86583360.0
2010-06-09 12:00:00	NVDA	Stock	0.2855	0.2855	0.2818	0.282	68907360.0
2010-06-09 13:00:00	NVDA	Stock	0.2822	0.2832	0.28	0.2808	47952760.0
2010-06-09 14:00:00	NVDA	Stock	0.2808	0.2812	0.2758	0.2758	93246480.0
2010-06-09 15:00:00	NVDA	Stock	0.2758	0.2765	0.2718	0.2725	172907520.0
2010-06-09 16:00:00	NVDA	Stock	0.2725	0.2799	0.2724	0.274	21264360.0
2010-06-09 17:00:00	NVDA	Stock	0.273	0.273	0.273	0.273	59720.0
2010-06-09 18:00:00	NVDA	Stock	0.2763	0.2763	0.2763	0.2763	8000.0
2010-06-09 19:00:00	NVDA	Stock	0.276	0.276	0.276	0.276	24000.0
2010-06-09 08:00:00	AMZN	Stock	5.9645	6.0228	5.9645	6.0175	227720.0
2010-06-09 09:00:00	AMZN	Stock	6.0055	6.0305	5.9195	5.95	24204580.0
2010-06-09 10:00:00	AMZN	Stock	5.95	5.975	5.8705	5.9695	29029500.0
2010-06-09 11:00:00	AMZN	Stock	5.9715	6.0735	5.9695	6.023	22838540.0
2010-06-09 12:00:00	AMZN	Stock	6.0235	6.058	6.0055	6.0235	9009880.0
2010-06-09 13:00:00	AMZN	Stock	6.024	6.0335	5.9945	6.01	10078440.0
2010-06-09 14:00:00	AMZN	Stock	6.015	6.019	5.9275	5.9305	15793500.0
2010-06-09 15:00:00	AMZN	Stock	5.9295	5.953	5.868	5.8955	31342380.0

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

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