PREVIEW / stock_1hour / 2011-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-24.parquet
  size:    945 KB
  rows:    44,605
  symbols: 3,512

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
2011-10-24 04:00:00	AAPL	Stock	14.125	14.125	14.1061	14.1061	28000.0
2011-10-24 05:00:00	AAPL	Stock	14.0786	14.0964	14.0786	14.0964	14000.0
2011-10-24 06:00:00	AAPL	Stock	14.1071	14.1164	14.1	14.1164	40040.0
2011-10-24 07:00:00	AAPL	Stock	14.1064	14.1214	14.09	14.1214	351176.0
2011-10-24 08:00:00	AAPL	Stock	14.1179	14.1679	14.1025	14.1407	2346624.0
2011-10-24 09:00:00	AAPL	Stock	14.14	14.2721	14.1214	14.2532	77041580.0
2011-10-24 10:00:00	AAPL	Stock	14.255	14.4554	14.2354	14.4161	138256804.0
2011-10-24 11:00:00	AAPL	Stock	14.4168	14.49	14.4039	14.4382	74920300.0
2011-10-24 12:00:00	AAPL	Stock	14.4368	14.4754	14.425	14.4651	36732780.0
2011-10-24 13:00:00	AAPL	Stock	14.4657	14.5179	14.4268	14.5043	39446764.0
2011-10-24 14:00:00	AAPL	Stock	14.5043	14.515	14.4471	14.4814	38444448.0
2011-10-24 15:00:00	AAPL	Stock	14.4814	14.4964	14.4339	14.4893	78537256.0
2011-10-24 16:00:00	AAPL	Stock	14.4918	14.4993	14.1521	14.4525	10811892.0
2011-10-24 17:00:00	AAPL	Stock	14.4525	14.4893	14.45	14.4882	354956.0
2011-10-24 18:00:00	AAPL	Stock	14.4825	14.4918	14.4746	14.4789	187768.0
2011-10-24 19:00:00	AAPL	Stock	14.475	14.4757	14.4643	14.4643	178388.0
2011-10-24 06:00:00	MSFT	Stock	27.08	27.24	27.08	27.24	430.0
2011-10-24 07:00:00	MSFT	Stock	27.08	27.12	27.02	27.1	3200.0
2011-10-24 08:00:00	MSFT	Stock	27.11	27.16	27.08	27.13	4402.0
2011-10-24 09:00:00	MSFT	Stock	27.13	27.24	27.02	27.2	4634805.0
2011-10-24 10:00:00	MSFT	Stock	27.194	27.35	27.14	27.275	10921689.0
2011-10-24 11:00:00	MSFT	Stock	27.28	27.4	27.22	27.275	5756917.0
2011-10-24 12:00:00	MSFT	Stock	27.275	27.36	27.24	27.279	4424259.0
2011-10-24 13:00:00	MSFT	Stock	27.28	27.35	27.24	27.3	3321051.0
2011-10-24 14:00:00	MSFT	Stock	27.305	27.36	27.25	27.301	4142859.0
2011-10-24 15:00:00	MSFT	Stock	27.3	27.38	27.06	27.19	14108907.0
2011-10-24 16:00:00	MSFT	Stock	27.2	27.295	27.086	27.161	7930670.0
2011-10-24 17:00:00	MSFT	Stock	27.12	27.159	27.12	27.12	26818.0
2011-10-24 18:00:00	MSFT	Stock	27.19	27.19	27.18	27.18	2800.0
2011-10-24 19:00:00	MSFT	Stock	27.13	27.13	27.03	27.07	14027.0
2011-10-24 09:00:00	NVDA	Stock	0.3648	0.3743	0.3628	0.3733	63622760.0
2011-10-24 10:00:00	NVDA	Stock	0.3733	0.3783	0.3728	0.375	101315680.0
2011-10-24 11:00:00	NVDA	Stock	0.375	0.3813	0.375	0.3805	70079280.0
2011-10-24 12:00:00	NVDA	Stock	0.3803	0.3803	0.3778	0.3785	36954080.0
2011-10-24 13:00:00	NVDA	Stock	0.3785	0.379	0.3753	0.3763	46032400.0
2011-10-24 14:00:00	NVDA	Stock	0.376	0.3768	0.372	0.3766	58037120.0
2011-10-24 15:00:00	NVDA	Stock	0.3766	0.377	0.3725	0.3758	139644000.0
2011-10-24 16:00:00	NVDA	Stock	0.3755	0.3762	0.3679	0.3733	3796720.0
2011-10-24 17:00:00	NVDA	Stock	0.3738	0.3755	0.3728	0.3755	189080.0
2011-10-24 18:00:00	NVDA	Stock	0.3755	0.3755	0.3755	0.3755	18000.0
2011-10-24 19:00:00	NVDA	Stock	0.3755	0.3755	0.3755	0.3755	11320.0
2011-10-24 04:00:00	AMZN	Stock	11.758	11.758	11.758	11.758	2000.0
2011-10-24 07:00:00	AMZN	Stock	11.7755	11.7755	11.735	11.7375	53600.0
2011-10-24 08:00:00	AMZN	Stock	11.76	11.8175	11.7585	11.8025	337600.0
2011-10-24 09:00:00	AMZN	Stock	11.81	11.8615	11.731	11.796	16137180.0
2011-10-24 10:00:00	AMZN	Stock	11.7953	11.848	11.7	11.8415	18251220.0
2011-10-24 11:00:00	AMZN	Stock	11.842	11.992	11.823	11.985	14894560.0
2011-10-24 12:00:00	AMZN	Stock	11.982	12.0235	11.956	11.9675	9233860.0
2011-10-24 13:00:00	AMZN	Stock	11.97	12.005	11.952	11.98	8174420.0
2011-10-24 14:00:00	AMZN	Stock	11.98	12.0	11.925	11.9535	8760060.0

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

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