PREVIEW / stock_1hour / 2010-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-28.parquet
  size:    890 KB
  rows:    42,555
  symbols: 3,462

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-05-28 04:00:00	AAPL	Stock	9.1468	9.1879	9.1468	9.1857	22400.0
2010-05-28 06:00:00	AAPL	Stock	9.1857	9.2075	9.1689	9.1689	151396.0
2010-05-28 07:00:00	AAPL	Stock	9.1693	9.225	9.1693	9.2075	1251348.0
2010-05-28 08:00:00	AAPL	Stock	9.2125	9.2768	9.1996	9.2461	12870228.0
2010-05-28 09:00:00	AAPL	Stock	9.2479	9.2643	9.15	9.208	134084580.0
2010-05-28 10:00:00	AAPL	Stock	9.2107	9.2318	9.1344	9.1529	106807064.0
2010-05-28 11:00:00	AAPL	Stock	9.1525	9.1725	9.0814	9.1218	107104704.0
2010-05-28 12:00:00	AAPL	Stock	9.1225	9.1629	9.0482	9.1021	109972660.0
2010-05-28 13:00:00	AAPL	Stock	9.1032	9.1357	9.085	9.0996	55500956.0
2010-05-28 14:00:00	AAPL	Stock	9.095	9.2143	9.0571	9.1846	103917184.0
2010-05-28 15:00:00	AAPL	Stock	9.1847	9.25	9.1679	9.1782	158335296.0
2010-05-28 16:00:00	AAPL	Stock	9.1782	9.2437	9.1211	9.1821	19614028.0
2010-05-28 17:00:00	AAPL	Stock	9.1821	9.1861	9.1743	9.1829	503608.0
2010-05-28 18:00:00	AAPL	Stock	9.1836	9.1982	9.1743	9.1982	352128.0
2010-05-28 19:00:00	AAPL	Stock	9.1968	9.1993	9.1746	9.1761	463540.0
2010-05-28 05:00:00	MSFT	Stock	26.13	26.13	26.02	26.02	450.0
2010-05-28 06:00:00	MSFT	Stock	26.04	26.04	26.04	26.04	200.0
2010-05-28 07:00:00	MSFT	Stock	26.09	26.11	26.09	26.11	1600.0
2010-05-28 08:00:00	MSFT	Stock	26.04	26.1	25.9	25.97	30669.0
2010-05-28 09:00:00	MSFT	Stock	25.94	25.95	25.68	25.798	9406575.0
2010-05-28 10:00:00	MSFT	Stock	25.8	25.88	25.7	25.82	9416416.0
2010-05-28 11:00:00	MSFT	Stock	25.82	25.94	25.7	25.762	8519247.0
2010-05-28 12:00:00	MSFT	Stock	25.77	25.9	25.66	25.75	9807788.0
2010-05-28 13:00:00	MSFT	Stock	25.76	25.8	25.7	25.75	4636568.0
2010-05-28 14:00:00	MSFT	Stock	25.75	25.95	25.68	25.88	6019083.0
2010-05-28 15:00:00	MSFT	Stock	25.88	26.12	25.76	25.8	12556981.0
2010-05-28 16:00:00	MSFT	Stock	25.81	26.112	25.72	25.83	4925511.0
2010-05-28 17:00:00	MSFT	Stock	25.83	25.83	25.8	25.8	2705.0
2010-05-28 18:00:00	MSFT	Stock	25.8	25.84	25.8	25.82	2430.0
2010-05-28 19:00:00	MSFT	Stock	25.8	25.84	25.8	25.84	3400.0
2010-05-28 08:00:00	NVDA	Stock	0.3385	0.3405	0.3385	0.34	242000.0
2010-05-28 09:00:00	NVDA	Stock	0.337	0.337	0.3285	0.333	83859280.0
2010-05-28 10:00:00	NVDA	Stock	0.333	0.3355	0.3283	0.3293	82945840.0
2010-05-28 11:00:00	NVDA	Stock	0.3293	0.3335	0.327	0.3293	67929440.0
2010-05-28 12:00:00	NVDA	Stock	0.3293	0.3308	0.325	0.3268	80564040.0
2010-05-28 13:00:00	NVDA	Stock	0.327	0.3283	0.325	0.3255	46278120.0
2010-05-28 14:00:00	NVDA	Stock	0.3255	0.329	0.3235	0.3283	50332560.0
2010-05-28 15:00:00	NVDA	Stock	0.328	0.3305	0.327	0.3285	102207520.0
2010-05-28 16:00:00	NVDA	Stock	0.3285	0.3373	0.3275	0.3275	21414800.0
2010-05-28 17:00:00	NVDA	Stock	0.3283	0.3285	0.328	0.3285	43520.0
2010-05-28 18:00:00	NVDA	Stock	0.3293	0.3293	0.3285	0.329	85520.0
2010-05-28 08:00:00	AMZN	Stock	6.325	6.325	6.295	6.2975	39200.0
2010-05-28 09:00:00	AMZN	Stock	6.305	6.366	6.2951	6.365	7678400.0
2010-05-28 10:00:00	AMZN	Stock	6.3625	6.38	6.3095	6.324	13094240.0
2010-05-28 11:00:00	AMZN	Stock	6.324	6.3375	6.2525	6.266	8462300.0
2010-05-28 12:00:00	AMZN	Stock	6.267	6.3025	6.204	6.2455	11417780.0
2010-05-28 13:00:00	AMZN	Stock	6.249	6.262	6.2075	6.222	5182120.0
2010-05-28 14:00:00	AMZN	Stock	6.221	6.3075	6.2005	6.3035	9902380.0
2010-05-28 15:00:00	AMZN	Stock	6.3025	6.334	6.2575	6.2645	18141420.0
2010-05-28 16:00:00	AMZN	Stock	6.2695	6.3344	6.255	6.273	4219660.0

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

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