PREVIEW / stock_1hour / 2010-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-11.parquet
  size:    882 KB
  rows:    42,294
  symbols: 3,414

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-02-11 06:00:00	AAPL	Stock	6.9682	6.9821	6.9643	6.9821	44324.0
2010-02-11 07:00:00	AAPL	Stock	7.0011	7.0014	6.9864	6.9979	139132.0
2010-02-11 08:00:00	AAPL	Stock	6.9893	6.9961	6.975	6.9782	1801576.0
2010-02-11 09:00:00	AAPL	Stock	6.9782	6.9871	6.9429	6.9582	57837976.0
2010-02-11 10:00:00	AAPL	Stock	6.9586	6.9821	6.9307	6.9604	70141092.0
2010-02-11 11:00:00	AAPL	Stock	6.9593	7.0875	6.9589	7.0721	112963648.0
2010-02-11 12:00:00	AAPL	Stock	7.0739	7.1004	7.0689	7.0989	65945012.0
2010-02-11 13:00:00	AAPL	Stock	7.0989	7.1329	7.0829	7.123	78318632.0
2010-02-11 14:00:00	AAPL	Stock	7.1239	7.1339	7.1071	7.1143	54990936.0
2010-02-11 15:00:00	AAPL	Stock	7.1146	7.1207	7.0839	7.0971	73277148.0
2010-02-11 16:00:00	AAPL	Stock	7.0961	7.0996	7.0518	7.0964	16778636.0
2010-02-11 17:00:00	AAPL	Stock	7.0993	7.11	7.0957	7.1025	3666628.0
2010-02-11 18:00:00	AAPL	Stock	7.1018	7.12	7.0954	7.1168	366268.0
2010-02-11 19:00:00	AAPL	Stock	7.1193	7.12	7.1114	7.1143	247268.0
2010-02-11 08:00:00	MSFT	Stock	28.01	28.1	28.0	28.09	620783.0
2010-02-11 09:00:00	MSFT	Stock	28.08	28.08	27.77	27.86	4637854.0
2010-02-11 10:00:00	MSFT	Stock	27.85	27.89	27.7	27.7	9540698.0
2010-02-11 11:00:00	MSFT	Stock	27.71	28.24	27.7	28.22	9764378.0
2010-02-11 12:00:00	MSFT	Stock	28.23	28.4	28.22	28.285	10667180.0
2010-02-11 13:00:00	MSFT	Stock	28.29	28.3	28.18	28.22	7324448.0
2010-02-11 14:00:00	MSFT	Stock	28.225	28.26	28.06	28.15	8710328.0
2010-02-11 15:00:00	MSFT	Stock	28.14	28.21	28.07	28.12	9523853.0
2010-02-11 16:00:00	MSFT	Stock	28.12	28.328	28.085	28.12	3835691.0
2010-02-11 17:00:00	MSFT	Stock	28.12	28.24	28.12	28.22	16580.0
2010-02-11 18:00:00	MSFT	Stock	28.13	28.18	28.13	28.18	17576.0
2010-02-11 19:00:00	MSFT	Stock	28.16	28.2	28.16	28.19	1000.0
2010-02-11 07:00:00	NVDA	Stock	0.4175	0.4175	0.4175	0.4175	48000.0
2010-02-11 08:00:00	NVDA	Stock	0.415	0.4188	0.415	0.4173	504000.0
2010-02-11 09:00:00	NVDA	Stock	0.4168	0.4195	0.4128	0.4188	99079600.0
2010-02-11 10:00:00	NVDA	Stock	0.419	0.4265	0.416	0.4202	179724400.0
2010-02-11 11:00:00	NVDA	Stock	0.4202	0.4302	0.4202	0.4293	94901960.0
2010-02-11 12:00:00	NVDA	Stock	0.4295	0.4325	0.4285	0.43	63338680.0
2010-02-11 13:00:00	NVDA	Stock	0.4302	0.4325	0.4293	0.4311	67428200.0
2010-02-11 14:00:00	NVDA	Stock	0.431	0.4322	0.4285	0.4288	67004240.0
2010-02-11 15:00:00	NVDA	Stock	0.4288	0.429	0.4268	0.4278	93297440.0
2010-02-11 16:00:00	NVDA	Stock	0.4275	0.4303	0.4248	0.4275	15977280.0
2010-02-11 17:00:00	NVDA	Stock	0.4275	0.428	0.4262	0.428	575600.0
2010-02-11 18:00:00	NVDA	Stock	0.4275	0.4275	0.4275	0.4275	3733440.0
2010-02-11 19:00:00	NVDA	Stock	0.4278	0.4278	0.4278	0.4278	24000.0
2010-02-11 08:00:00	AMZN	Stock	5.8705	5.8995	5.8705	5.8845	170760.0
2010-02-11 09:00:00	AMZN	Stock	5.885	5.885	5.825	5.8435	12738760.0
2010-02-11 10:00:00	AMZN	Stock	5.843	5.9175	5.831	5.8975	28085160.0
2010-02-11 11:00:00	AMZN	Stock	5.8975	5.967	5.8975	5.9495	31779300.0
2010-02-11 12:00:00	AMZN	Stock	5.95	5.985	5.95	5.9635	15584320.0
2010-02-11 13:00:00	AMZN	Stock	5.9639	5.9845	5.943	5.9835	16555160.0
2010-02-11 14:00:00	AMZN	Stock	5.984	5.999	5.9705	5.995	19488280.0
2010-02-11 15:00:00	AMZN	Stock	5.995	6.021	5.9835	6.0015	34443080.0
2010-02-11 16:00:00	AMZN	Stock	6.004	6.0155	5.9452	6.0045	4440260.0
2010-02-11 17:00:00	AMZN	Stock	6.005	6.0075	6.005	6.0075	50540.0
2010-02-11 18:00:00	AMZN	Stock	6.005	6.005	6.001	6.001	12200.0

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

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