PREVIEW / stock_1hour / 2010-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-19.parquet
  size:    950 KB
  rows:    46,004
  symbols: 3,475

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-19 04:00:00	AAPL	Stock	8.9125	8.9125	8.86	8.86	9660.0
2010-05-19 05:00:00	AAPL	Stock	8.8814	8.9143	8.8814	8.9143	15400.0
2010-05-19 06:00:00	AAPL	Stock	8.9107	8.9107	8.8768	8.905	57120.0
2010-05-19 07:00:00	AAPL	Stock	8.9036	8.9375	8.8946	8.9321	492744.0
2010-05-19 08:00:00	AAPL	Stock	8.9311	8.9779	8.8893	8.9736	5783148.0
2010-05-19 09:00:00	AAPL	Stock	8.975	9.0329	8.8682	8.9	139970628.0
2010-05-19 10:00:00	AAPL	Stock	8.9	8.9075	8.7593	8.8596	231625436.0
2010-05-19 11:00:00	AAPL	Stock	8.8596	8.875	8.7446	8.7911	152582668.0
2010-05-19 12:00:00	AAPL	Stock	8.7889	8.855	8.7614	8.855	113068088.0
2010-05-19 13:00:00	AAPL	Stock	8.8554	8.8979	8.8154	8.8686	103835760.0
2010-05-19 14:00:00	AAPL	Stock	8.8684	8.9286	8.8268	8.8607	95939676.0
2010-05-19 15:00:00	AAPL	Stock	8.8621	8.9064	8.7954	8.8682	158844840.0
2010-05-19 16:00:00	AAPL	Stock	8.8682	9.0133	8.8188	8.8714	13518820.0
2010-05-19 17:00:00	AAPL	Stock	8.8721	8.875	8.8536	8.8643	1942724.0
2010-05-19 18:00:00	AAPL	Stock	8.8621	8.8714	8.8607	8.8682	465472.0
2010-05-19 19:00:00	AAPL	Stock	8.8682	8.8821	8.8679	8.8821	555324.0
2010-05-19 05:00:00	MSFT	Stock	28.25	28.25	28.25	28.25	280.0
2010-05-19 07:00:00	MSFT	Stock	28.3	28.4	28.3	28.4	680.0
2010-05-19 08:00:00	MSFT	Stock	28.67	28.67	28.3	28.46	20649.0
2010-05-19 09:00:00	MSFT	Stock	28.46	28.69	28.34	28.44	5808977.0
2010-05-19 10:00:00	MSFT	Stock	28.43	28.45	27.79	28.29	14262734.0
2010-05-19 11:00:00	MSFT	Stock	28.29	28.335	28.03	28.17	6791225.0
2010-05-19 12:00:00	MSFT	Stock	28.17	28.36	28.14	28.28	6014615.0
2010-05-19 13:00:00	MSFT	Stock	28.28	28.44	28.26	28.31	5592307.0
2010-05-19 14:00:00	MSFT	Stock	28.31	28.42	28.14	28.178	5562462.0
2010-05-19 15:00:00	MSFT	Stock	28.17	28.345	28.01	28.22	13888890.0
2010-05-19 16:00:00	MSFT	Stock	28.23	28.632	28.17	28.25	2344825.0
2010-05-19 17:00:00	MSFT	Stock	28.23	28.23	28.22	28.22	900.0
2010-05-19 18:00:00	MSFT	Stock	28.24	28.3	28.22	28.22	22016.0
2010-05-19 19:00:00	MSFT	Stock	28.22	28.29	28.22	28.29	2445.0
2010-05-19 06:00:00	NVDA	Stock	0.3058	0.3088	0.3058	0.3088	20000.0
2010-05-19 07:00:00	NVDA	Stock	0.3062	0.31	0.3062	0.31	22400.0
2010-05-19 08:00:00	NVDA	Stock	0.3105	0.3146	0.3075	0.3125	640640.0
2010-05-19 09:00:00	NVDA	Stock	0.3125	0.319	0.3115	0.3163	65467000.0
2010-05-19 10:00:00	NVDA	Stock	0.3163	0.3168	0.3103	0.3155	144756160.0
2010-05-19 11:00:00	NVDA	Stock	0.3158	0.317	0.311	0.3128	88922760.0
2010-05-19 12:00:00	NVDA	Stock	0.3128	0.3168	0.3115	0.3168	65730960.0
2010-05-19 13:00:00	NVDA	Stock	0.3168	0.3195	0.3163	0.3185	99497240.0
2010-05-19 14:00:00	NVDA	Stock	0.3185	0.3195	0.3158	0.3175	129090040.0
2010-05-19 15:00:00	NVDA	Stock	0.3175	0.3195	0.3155	0.319	216058440.0
2010-05-19 16:00:00	NVDA	Stock	0.3188	0.3195	0.3143	0.3175	14840760.0
2010-05-19 17:00:00	NVDA	Stock	0.3188	0.3195	0.3188	0.3195	87920.0
2010-05-19 18:00:00	NVDA	Stock	0.3195	0.3195	0.3195	0.3195	4000.0
2010-05-19 19:00:00	NVDA	Stock	0.3198	0.3198	0.3188	0.3188	81920.0
2010-05-19 08:00:00	AMZN	Stock	6.2745	6.305	6.2625	6.305	94000.0
2010-05-19 09:00:00	AMZN	Stock	6.325	6.3965	6.268	6.3169	13057360.0
2010-05-19 10:00:00	AMZN	Stock	6.3165	6.332	6.2	6.32	25158700.0
2010-05-19 11:00:00	AMZN	Stock	6.319	6.343	6.226	6.2595	14817060.0
2010-05-19 12:00:00	AMZN	Stock	6.258	6.286	6.2155	6.2705	10661260.0
2010-05-19 13:00:00	AMZN	Stock	6.27	6.273	6.231	6.249	14279260.0

> showing 50 of 46,004 rows — these rows as CSV

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