PREVIEW / stock_1hour / 2010-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-29.parquet
  size:    939 KB
  rows:    44,162
  symbols: 3,498

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-04-29 04:00:00	AAPL	Stock	9.3679	9.3714	9.3679	9.3714	8820.0
2010-04-29 05:00:00	AAPL	Stock	9.3746	9.4	9.3507	9.4	53424.0
2010-04-29 06:00:00	AAPL	Stock	9.4	9.4107	9.3936	9.4029	111608.0
2010-04-29 07:00:00	AAPL	Stock	9.4036	9.4214	9.4029	9.4107	413840.0
2010-04-29 08:00:00	AAPL	Stock	9.4032	9.4129	9.375	9.3886	2513140.0
2010-04-29 09:00:00	AAPL	Stock	9.3857	9.4961	9.3575	9.4961	95285260.0
2010-04-29 10:00:00	AAPL	Stock	9.496	9.5518	9.4707	9.548	102359656.0
2010-04-29 11:00:00	AAPL	Stock	9.5471	9.5889	9.5375	9.5736	74590292.0
2010-04-29 12:00:00	AAPL	Stock	9.5736	9.6232	9.5679	9.6189	55387892.0
2010-04-29 13:00:00	AAPL	Stock	9.6189	9.6386	9.5964	9.6329	56367164.0
2010-04-29 14:00:00	AAPL	Stock	9.6337	9.6429	9.5725	9.5893	79314480.0
2010-04-29 15:00:00	AAPL	Stock	9.5879	9.6221	9.5782	9.5929	75369560.0
2010-04-29 16:00:00	AAPL	Stock	9.5929	9.6156	9.5533	9.6025	10988768.0
2010-04-29 17:00:00	AAPL	Stock	9.6025	9.6032	9.5968	9.6014	230300.0
2010-04-29 18:00:00	AAPL	Stock	9.6011	9.6118	9.5943	9.6068	277060.0
2010-04-29 19:00:00	AAPL	Stock	9.6068	9.6071	9.575	9.575	344456.0
2010-04-29 06:00:00	MSFT	Stock	30.94	30.94	30.79	30.8	3300.0
2010-04-29 07:00:00	MSFT	Stock	30.8	30.91	30.8	30.9	12099.0
2010-04-29 08:00:00	MSFT	Stock	30.9	30.95	30.86	30.95	34424.0
2010-04-29 09:00:00	MSFT	Stock	30.97	31.02	30.67	30.85	5951337.0
2010-04-29 10:00:00	MSFT	Stock	30.85	30.926	30.83	30.878	8711381.0
2010-04-29 11:00:00	MSFT	Stock	30.88	30.9	30.84	30.89	7622521.0
2010-04-29 12:00:00	MSFT	Stock	30.885	31.13	30.88	31.105	6870921.0
2010-04-29 13:00:00	MSFT	Stock	31.105	31.14	31.0	31.113	5671523.0
2010-04-29 14:00:00	MSFT	Stock	31.12	31.433	31.04	31.1	5555547.0
2010-04-29 15:00:00	MSFT	Stock	31.09	31.13	30.99	31.04	9120649.0
2010-04-29 16:00:00	MSFT	Stock	31.04	31.07	30.97	31.03	2188106.0
2010-04-29 17:00:00	MSFT	Stock	31.03	31.03	30.97	30.97	1000.0
2010-04-29 18:00:00	MSFT	Stock	30.93	31.06	30.9	30.97	4645.0
2010-04-29 19:00:00	MSFT	Stock	30.94	30.96	30.94	30.96	1995.0
2010-04-29 08:00:00	NVDA	Stock	0.405	0.409	0.405	0.4088	48000.0
2010-04-29 09:00:00	NVDA	Stock	0.4088	0.4088	0.4043	0.4043	52614720.0
2010-04-29 10:00:00	NVDA	Stock	0.4045	0.4048	0.3993	0.4032	125317120.0
2010-04-29 11:00:00	NVDA	Stock	0.4032	0.4062	0.4015	0.4062	83698000.0
2010-04-29 12:00:00	NVDA	Stock	0.4062	0.41	0.4058	0.4093	120558160.0
2010-04-29 13:00:00	NVDA	Stock	0.4093	0.4138	0.409	0.4135	136288520.0
2010-04-29 14:00:00	NVDA	Stock	0.4138	0.4162	0.4125	0.4155	173122640.0
2010-04-29 15:00:00	NVDA	Stock	0.4157	0.4168	0.4136	0.4158	275007960.0
2010-04-29 16:00:00	NVDA	Stock	0.416	0.4175	0.4103	0.4165	3045600.0
2010-04-29 17:00:00	NVDA	Stock	0.4175	0.418	0.4168	0.4175	108880.0
2010-04-29 18:00:00	NVDA	Stock	0.4175	0.4188	0.4162	0.4162	60000.0
2010-04-29 19:00:00	NVDA	Stock	0.4173	0.4173	0.4173	0.4173	18040.0
2010-04-29 04:00:00	AMZN	Stock	6.999	6.999	6.999	6.999	2000.0
2010-04-29 06:00:00	AMZN	Stock	7.011	7.011	7.011	7.011	2000.0
2010-04-29 07:00:00	AMZN	Stock	7.02	7.02	7.02	7.02	4000.0
2010-04-29 08:00:00	AMZN	Stock	7.0	7.0275	7.0	7.0215	81000.0
2010-04-29 09:00:00	AMZN	Stock	7.015	7.1065	7.0015	7.066	17849560.0
2010-04-29 10:00:00	AMZN	Stock	7.066	7.0815	6.9895	7.0105	27617340.0
2010-04-29 11:00:00	AMZN	Stock	7.0115	7.081	7.011	7.0638	19792840.0
2010-04-29 12:00:00	AMZN	Stock	7.064	7.0975	7.0315	7.0805	12619260.0

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

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