PREVIEW / stock_1hour / 2010-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-18.parquet
  size:    911 KB
  rows:    44,312
  symbols: 3,469

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-08-18 04:00:00	AAPL	Stock	8.9964	9.0214	8.9964	9.0214	14700.0
2010-08-18 05:00:00	AAPL	Stock	9.0214	9.0286	9.0214	9.0286	20524.0
2010-08-18 06:00:00	AAPL	Stock	9.0286	9.0286	9.0246	9.0246	8400.0
2010-08-18 07:00:00	AAPL	Stock	9.0071	9.0346	9.0071	9.0307	93520.0
2010-08-18 08:00:00	AAPL	Stock	9.0286	9.0461	8.9964	9.0443	1660540.0
2010-08-18 09:00:00	AAPL	Stock	9.0443	9.0496	8.985	9.0407	54786984.0
2010-08-18 10:00:00	AAPL	Stock	9.0407	9.08	9.0161	9.0457	61552708.0
2010-08-18 11:00:00	AAPL	Stock	9.0449	9.075	9.0357	9.0693	43202600.0
2010-08-18 12:00:00	AAPL	Stock	9.0689	9.0786	9.0432	9.0764	33407892.0
2010-08-18 13:00:00	AAPL	Stock	9.0768	9.0954	9.0718	9.0775	36538964.0
2010-08-18 14:00:00	AAPL	Stock	9.0782	9.0836	9.0539	9.0571	33489512.0
2010-08-18 15:00:00	AAPL	Stock	9.0571	9.0654	9.025	9.0382	58800672.0
2010-08-18 16:00:00	AAPL	Stock	9.0382	9.0604	8.9982	9.0107	13307028.0
2010-08-18 17:00:00	AAPL	Stock	9.0107	9.025	9.0036	9.02	264208.0
2010-08-18 18:00:00	AAPL	Stock	9.02	9.0382	9.0143	9.0321	602420.0
2010-08-18 19:00:00	AAPL	Stock	9.0307	9.0311	9.0179	9.0214	229040.0
2010-08-18 20:00:00	AAPL	Stock	9.0029	9.0654	9.0029	9.0654	584360.0
2010-08-18 07:00:00	MSFT	Stock	24.82	24.82	24.82	24.82	101.0
2010-08-18 08:00:00	MSFT	Stock	24.82	24.82	24.76	24.79	14228.0
2010-08-18 09:00:00	MSFT	Stock	24.8	24.8	24.41	24.64	6754936.0
2010-08-18 10:00:00	MSFT	Stock	24.64	24.7	24.54	24.59	7427154.0
2010-08-18 11:00:00	MSFT	Stock	24.582	24.835	24.56	24.814	7029444.0
2010-08-18 12:00:00	MSFT	Stock	24.81	24.87	24.77	24.82	3641658.0
2010-08-18 13:00:00	MSFT	Stock	24.82	24.95	24.82	24.9	4399008.0
2010-08-18 14:00:00	MSFT	Stock	24.92	24.95	24.83	24.87	3414799.0
2010-08-18 15:00:00	MSFT	Stock	24.872	24.9	24.82	24.86	9471496.0
2010-08-18 16:00:00	MSFT	Stock	24.86	24.86	24.637	24.68	3479374.0
2010-08-18 17:00:00	MSFT	Stock	24.68	24.75	24.68	24.72	3700.0
2010-08-18 18:00:00	MSFT	Stock	24.7	24.82	24.68	24.69	15187.0
2010-08-18 19:00:00	MSFT	Stock	24.68	24.74	24.68	24.68	7404.0
2010-08-18 20:00:00	MSFT	Stock	24.82	24.82	24.82	24.82	821850.0
2010-08-18 08:00:00	NVDA	Stock	0.2312	0.2338	0.2308	0.2315	116000.0
2010-08-18 09:00:00	NVDA	Stock	0.2315	0.2332	0.2295	0.2328	50567440.0
2010-08-18 10:00:00	NVDA	Stock	0.2328	0.234	0.2303	0.231	44371960.0
2010-08-18 11:00:00	NVDA	Stock	0.2308	0.233	0.2308	0.2326	36284640.0
2010-08-18 12:00:00	NVDA	Stock	0.2326	0.2342	0.2322	0.2338	27073560.0
2010-08-18 13:00:00	NVDA	Stock	0.234	0.2348	0.2339	0.2348	32357040.0
2010-08-18 14:00:00	NVDA	Stock	0.2348	0.235	0.2335	0.2338	59604440.0
2010-08-18 15:00:00	NVDA	Stock	0.2338	0.2342	0.2328	0.233	81869880.0
2010-08-18 16:00:00	NVDA	Stock	0.233	0.233	0.2308	0.2308	12568480.0
2010-08-18 17:00:00	NVDA	Stock	0.2325	0.2325	0.2325	0.2325	28000.0
2010-08-18 18:00:00	NVDA	Stock	0.2325	0.2362	0.2312	0.2352	4285960.0
2010-08-18 19:00:00	NVDA	Stock	0.2352	0.2358	0.2348	0.2348	1612000.0
2010-08-18 07:00:00	AMZN	Stock	6.469	6.469	6.4675	6.4675	8000.0
2010-08-18 08:00:00	AMZN	Stock	6.4675	6.475	6.4455	6.468	70700.0
2010-08-18 09:00:00	AMZN	Stock	6.4735	6.485	6.413	6.461	16660760.0
2010-08-18 10:00:00	AMZN	Stock	6.462	6.494	6.4285	6.449	19507040.0
2010-08-18 11:00:00	AMZN	Stock	6.449	6.498	6.4409	6.4955	17279860.0
2010-08-18 12:00:00	AMZN	Stock	6.4955	6.5245	6.4755	6.4865	44899920.0
2010-08-18 13:00:00	AMZN	Stock	6.4875	6.5305	6.4805	6.5295	17239360.0

> showing 50 of 44,312 rows — these rows as CSV

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