PREVIEW / stock_1hour / 2011-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-06.parquet
  size:    930 KB
  rows:    44,199
  symbols: 3,533

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-07-06 04:00:00	AAPL	Stock	12.4129	12.4129	12.4129	12.4129	2800.0
2011-07-06 05:00:00	AAPL	Stock	12.4325	12.4325	12.4089	12.4089	8400.0
2011-07-06 06:00:00	AAPL	Stock	12.4375	12.4432	12.4214	12.4432	31500.0
2011-07-06 07:00:00	AAPL	Stock	12.4639	12.4925	12.4321	12.4346	193900.0
2011-07-06 08:00:00	AAPL	Stock	12.4446	12.4857	12.4321	12.4768	1036364.0
2011-07-06 09:00:00	AAPL	Stock	12.4786	12.4875	12.41	12.4318	49255388.0
2011-07-06 10:00:00	AAPL	Stock	12.4314	12.5282	12.3825	12.5203	77648760.0
2011-07-06 11:00:00	AAPL	Stock	12.5207	12.6071	12.5089	12.5991	75478452.0
2011-07-06 12:00:00	AAPL	Stock	12.5981	12.6421	12.5704	12.6371	45847648.0
2011-07-06 13:00:00	AAPL	Stock	12.6376	12.6464	12.5821	12.6157	43155028.0
2011-07-06 14:00:00	AAPL	Stock	12.6171	12.62	12.5286	12.5311	58635920.0
2011-07-06 15:00:00	AAPL	Stock	12.5318	12.58	12.4911	12.5657	78224300.0
2011-07-06 16:00:00	AAPL	Stock	12.5629	12.57	12.5318	12.5664	6623960.0
2011-07-06 17:00:00	AAPL	Stock	12.5564	12.5671	12.5564	12.5654	271572.0
2011-07-06 18:00:00	AAPL	Stock	12.5671	12.5679	12.5607	12.5607	246288.0
2011-07-06 19:00:00	AAPL	Stock	12.5646	12.5721	12.5557	12.5714	293720.0
2011-07-06 05:00:00	MSFT	Stock	25.92	26.04	25.92	26.02	300.0
2011-07-06 06:00:00	MSFT	Stock	25.93	25.93	25.92	25.92	400.0
2011-07-06 07:00:00	MSFT	Stock	25.93	26.0	25.93	25.97	2419.0
2011-07-06 08:00:00	MSFT	Stock	25.98	26.0	25.91	26.0	13398.0
2011-07-06 09:00:00	MSFT	Stock	25.99	26.29	25.96	26.2	6881575.0
2011-07-06 10:00:00	MSFT	Stock	26.2	26.27	26.04	26.215	7566429.0
2011-07-06 11:00:00	MSFT	Stock	26.215	26.28	26.15	26.27	4226917.0
2011-07-06 12:00:00	MSFT	Stock	26.265	26.37	26.23	26.36	4492502.0
2011-07-06 13:00:00	MSFT	Stock	26.358	26.36	26.18	26.24	6955472.0
2011-07-06 14:00:00	MSFT	Stock	26.245	26.3	26.16	26.255	4265935.0
2011-07-06 15:00:00	MSFT	Stock	26.25	26.36	26.21	26.35	10508122.0
2011-07-06 16:00:00	MSFT	Stock	26.35	26.4	26.223	26.39	2952130.0
2011-07-06 17:00:00	MSFT	Stock	26.167	26.56	26.167	26.48	125288.0
2011-07-06 18:00:00	MSFT	Stock	26.47	26.49	26.33	26.46	26126.0
2011-07-06 19:00:00	MSFT	Stock	26.47	26.49	26.45	26.45	3716.0
2011-07-06 07:00:00	NVDA	Stock	0.3902	0.3925	0.3902	0.3925	44000.0
2011-07-06 08:00:00	NVDA	Stock	0.3933	0.3935	0.393	0.3935	26000.0
2011-07-06 09:00:00	NVDA	Stock	0.3938	0.3975	0.3895	0.3918	69848000.0
2011-07-06 10:00:00	NVDA	Stock	0.3915	0.3925	0.387	0.3898	101630040.0
2011-07-06 11:00:00	NVDA	Stock	0.3898	0.393	0.3888	0.3921	53740920.0
2011-07-06 12:00:00	NVDA	Stock	0.392	0.3948	0.3911	0.3948	56611160.0
2011-07-06 13:00:00	NVDA	Stock	0.3948	0.3948	0.3914	0.3922	60567040.0
2011-07-06 14:00:00	NVDA	Stock	0.3925	0.3925	0.39	0.3905	61201400.0
2011-07-06 15:00:00	NVDA	Stock	0.3905	0.392	0.3902	0.3918	109355120.0
2011-07-06 16:00:00	NVDA	Stock	0.3922	0.3922	0.391	0.3918	3048120.0
2011-07-06 17:00:00	NVDA	Stock	0.3913	0.392	0.3913	0.392	16000.0
2011-07-06 18:00:00	NVDA	Stock	0.3922	0.3922	0.3922	0.3922	80000.0
2011-07-06 19:00:00	NVDA	Stock	0.3913	0.3913	0.3913	0.3913	28000.0
2011-07-06 08:00:00	AMZN	Stock	10.623	10.625	10.6005	10.6005	65620.0
2011-07-06 09:00:00	AMZN	Stock	10.6005	10.65	10.575	10.6275	8298780.0
2011-07-06 10:00:00	AMZN	Stock	10.6285	10.6655	10.5505	10.645	9922320.0
2011-07-06 11:00:00	AMZN	Stock	10.6475	10.72	10.598	10.701	6804200.0
2011-07-06 12:00:00	AMZN	Stock	10.7015	10.7199	10.675	10.7165	5145900.0
2011-07-06 13:00:00	AMZN	Stock	10.7181	10.7181	10.678	10.6975	3310020.0

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

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