PREVIEW / stock_1hour / 2010-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-12.parquet
  size:    917 KB
  rows:    43,526
  symbols: 3,458

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-03-12 04:00:00	AAPL	Stock	8.0779	8.1	8.0779	8.1	22400.0
2010-03-12 05:00:00	AAPL	Stock	8.1061	8.1061	8.0968	8.0968	42588.0
2010-03-12 06:00:00	AAPL	Stock	8.1068	8.1068	8.1036	8.1036	11396.0
2010-03-12 07:00:00	AAPL	Stock	8.1025	8.1036	8.0843	8.0907	420224.0
2010-03-12 08:00:00	AAPL	Stock	8.0857	8.1268	8.0391	8.1225	5437124.0
2010-03-12 09:00:00	AAPL	Stock	8.1232	8.1332	8.0718	8.1286	102907840.0
2010-03-12 10:00:00	AAPL	Stock	8.1293	8.1318	8.0675	8.095	92940428.0
2010-03-12 11:00:00	AAPL	Stock	8.095	8.1161	8.0896	8.0957	37761220.0
2010-03-12 12:00:00	AAPL	Stock	8.0954	8.1071	8.0918	8.1014	26493012.0
2010-03-12 13:00:00	AAPL	Stock	8.1018	8.1021	8.0814	8.0958	26425364.0
2010-03-12 14:00:00	AAPL	Stock	8.0959	8.1089	8.0929	8.103	36890028.0
2010-03-12 15:00:00	AAPL	Stock	8.1025	8.1046	8.0625	8.0936	77773724.0
2010-03-12 16:00:00	AAPL	Stock	8.0921	8.0982	8.0583	8.0918	6365884.0
2010-03-12 17:00:00	AAPL	Stock	8.0932	8.1007	8.0875	8.1007	462028.0
2010-03-12 18:00:00	AAPL	Stock	8.0916	8.1032	8.0879	8.0925	344988.0
2010-03-12 19:00:00	AAPL	Stock	8.0929	8.0929	8.0857	8.0857	226632.0
2010-03-12 20:00:00	AAPL	Stock	8.1004	8.1004	8.1004	8.1004	133840.0
2010-03-12 04:00:00	MSFT	Stock	29.2	29.28	29.2	29.28	980.0
2010-03-12 05:00:00	MSFT	Stock	29.38	29.38	29.38	29.38	500.0
2010-03-12 06:00:00	MSFT	Stock	29.38	29.38	29.38	29.38	115.0
2010-03-12 07:00:00	MSFT	Stock	29.26	29.34	29.26	29.34	6400.0
2010-03-12 08:00:00	MSFT	Stock	29.34	29.39	29.28	29.33	33370.0
2010-03-12 09:00:00	MSFT	Stock	29.33	29.39	29.14	29.26	4692013.0
2010-03-12 10:00:00	MSFT	Stock	29.26	29.29	29.04	29.09	7280129.0
2010-03-12 11:00:00	MSFT	Stock	29.09	29.32	29.06	29.213	4648051.0
2010-03-12 12:00:00	MSFT	Stock	29.21	29.25	29.15	29.23	2623079.0
2010-03-12 13:00:00	MSFT	Stock	29.24	29.26	29.19	29.23	1984153.0
2010-03-12 14:00:00	MSFT	Stock	29.24	29.29	29.2	29.26	2439517.0
2010-03-12 15:00:00	MSFT	Stock	29.26	29.3	29.21	29.27	5793896.0
2010-03-12 16:00:00	MSFT	Stock	29.27	29.313	29.188	29.25	1075728.0
2010-03-12 17:00:00	MSFT	Stock	29.28	29.28	29.27	29.27	1900.0
2010-03-12 18:00:00	MSFT	Stock	29.25	29.25	29.25	29.25	300.0
2010-03-12 19:00:00	MSFT	Stock	29.25	29.26	29.23	29.23	3356.0
2010-03-12 20:00:00	MSFT	Stock	29.28	29.28	29.28	29.28	5800.0
2010-03-12 08:00:00	NVDA	Stock	0.4355	0.4355	0.4338	0.4338	250760.0
2010-03-12 09:00:00	NVDA	Stock	0.4335	0.4348	0.4302	0.4338	54092960.0
2010-03-12 10:00:00	NVDA	Stock	0.4335	0.4352	0.429	0.4304	196757080.0
2010-03-12 11:00:00	NVDA	Stock	0.4302	0.4358	0.43	0.434	75354800.0
2010-03-12 12:00:00	NVDA	Stock	0.434	0.4342	0.4312	0.4315	37963680.0
2010-03-12 13:00:00	NVDA	Stock	0.4315	0.4322	0.4301	0.432	38618920.0
2010-03-12 14:00:00	NVDA	Stock	0.432	0.4325	0.43	0.43	36823600.0
2010-03-12 15:00:00	NVDA	Stock	0.43	0.432	0.4295	0.431	67609720.0
2010-03-12 16:00:00	NVDA	Stock	0.4312	0.4324	0.43	0.4312	10186680.0
2010-03-12 18:00:00	NVDA	Stock	0.4312	0.4312	0.4312	0.4312	1425560.0
2010-03-12 07:00:00	AMZN	Stock	6.667	6.7185	6.667	6.7185	4000.0
2010-03-12 08:00:00	AMZN	Stock	6.725	6.725	6.667	6.7245	484640.0
2010-03-12 09:00:00	AMZN	Stock	6.72	6.72	6.6465	6.6771	21287300.0
2010-03-12 10:00:00	AMZN	Stock	6.6775	6.71	6.5645	6.603	37323800.0
2010-03-12 11:00:00	AMZN	Stock	6.6025	6.639	6.596	6.6315	13408700.0
2010-03-12 12:00:00	AMZN	Stock	6.6315	6.6345	6.596	6.6185	9313600.0

> showing 50 of 43,526 rows — these rows as CSV

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