PREVIEW / stock_1hour / 2013-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-18.parquet
  size:    960 KB
  rows:    45,688
  symbols: 3,441

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
2013-01-18 04:00:00	AAPL	Stock	17.8625	17.8868	17.7589	17.8571	162960.0
2013-01-18 05:00:00	AAPL	Stock	17.875	17.9643	17.875	17.9643	91560.0
2013-01-18 06:00:00	AAPL	Stock	17.9821	17.9911	17.9232	17.9232	195580.0
2013-01-18 07:00:00	AAPL	Stock	17.9232	18.0246	17.9	17.9446	926520.0
2013-01-18 08:00:00	AAPL	Stock	17.9464	18.0268	17.7682	17.8143	3693088.0
2013-01-18 09:00:00	AAPL	Stock	17.8164	17.9364	17.7286	17.8564	113230600.0
2013-01-18 10:00:00	AAPL	Stock	17.8549	17.8889	17.8075	17.8314	60399276.0
2013-01-18 11:00:00	AAPL	Stock	17.8321	17.834	17.7529	17.7605	51804368.0
2013-01-18 12:00:00	AAPL	Stock	17.7597	17.8446	17.7536	17.8376	35245364.0
2013-01-18 13:00:00	AAPL	Stock	17.8376	17.8596	17.8214	17.8436	27866524.0
2013-01-18 14:00:00	AAPL	Stock	17.8439	17.8475	17.7946	17.8271	35871108.0
2013-01-18 15:00:00	AAPL	Stock	17.8271	17.8607	17.8036	17.8557	78053192.0
2013-01-18 16:00:00	AAPL	Stock	17.8561	17.9529	17.7964	17.8571	18113564.0
2013-01-18 17:00:00	AAPL	Stock	17.8571	17.8639	17.8564	17.8639	4941720.0
2013-01-18 18:00:00	AAPL	Stock	17.8607	17.8732	17.8607	17.8704	425740.0
2013-01-18 19:00:00	AAPL	Stock	17.8679	17.8714	17.8625	17.8682	172648.0
2013-01-18 05:00:00	MSFT	Stock	27.17	27.17	27.17	27.17	300.0
2013-01-18 07:00:00	MSFT	Stock	27.07	27.07	27.07	27.07	1000.0
2013-01-18 08:00:00	MSFT	Stock	27.12	27.26	27.07	27.09	61744.0
2013-01-18 09:00:00	MSFT	Stock	27.1	27.27	27.02	27.2	15508635.0
2013-01-18 10:00:00	MSFT	Stock	27.19	27.23	27.1	27.195	5664996.0
2013-01-18 11:00:00	MSFT	Stock	27.195	27.24	27.1	27.165	6183717.0
2013-01-18 12:00:00	MSFT	Stock	27.16	27.25	27.13	27.24	3261947.0
2013-01-18 13:00:00	MSFT	Stock	27.235	27.29	27.23	27.25	4019636.0
2013-01-18 14:00:00	MSFT	Stock	27.24	27.29	27.18	27.188	3905907.0
2013-01-18 15:00:00	MSFT	Stock	27.18	27.25	27.16	27.25	8778971.0
2013-01-18 16:00:00	MSFT	Stock	27.24	27.27	27.166	27.23	3954034.0
2013-01-18 17:00:00	MSFT	Stock	27.23	27.27	27.21	27.27	6790.0
2013-01-18 18:00:00	MSFT	Stock	27.23	27.26	27.23	27.23	810.0
2013-01-18 19:00:00	MSFT	Stock	27.23	27.24	27.21	27.24	3200.0
2013-01-18 08:00:00	NVDA	Stock	0.3052	0.3062	0.3052	0.3062	178680.0
2013-01-18 09:00:00	NVDA	Stock	0.3062	0.3062	0.3035	0.3045	63628080.0
2013-01-18 10:00:00	NVDA	Stock	0.3045	0.3058	0.303	0.3035	44290080.0
2013-01-18 11:00:00	NVDA	Stock	0.3036	0.3038	0.3005	0.3008	51079200.0
2013-01-18 12:00:00	NVDA	Stock	0.3008	0.302	0.3008	0.3018	38287920.0
2013-01-18 13:00:00	NVDA	Stock	0.3018	0.3028	0.3015	0.302	31677120.0
2013-01-18 14:00:00	NVDA	Stock	0.3022	0.3042	0.302	0.3032	67870120.0
2013-01-18 15:00:00	NVDA	Stock	0.3032	0.3042	0.302	0.3042	87153680.0
2013-01-18 16:00:00	NVDA	Stock	0.3042	0.3042	0.3032	0.3032	12452400.0
2013-01-18 17:00:00	NVDA	Stock	0.3048	0.3048	0.3048	0.3048	4000.0
2013-01-18 18:00:00	NVDA	Stock	0.3052	0.3052	0.3052	0.3052	12000.0
2013-01-18 19:00:00	NVDA	Stock	0.3052	0.3052	0.3052	0.3052	8000.0
2013-01-18 06:00:00	AMZN	Stock	13.595	13.65	13.5755	13.625	99840.0
2013-01-18 07:00:00	AMZN	Stock	13.6445	13.646	13.5955	13.5955	136960.0
2013-01-18 08:00:00	AMZN	Stock	13.6025	13.6345	13.6	13.606	143400.0
2013-01-18 09:00:00	AMZN	Stock	13.6	13.725	13.5405	13.6256	17136900.0
2013-01-18 10:00:00	AMZN	Stock	13.629	13.6345	13.4871	13.536	10118520.0
2013-01-18 11:00:00	AMZN	Stock	13.5365	13.5405	13.48	13.4855	6135480.0
2013-01-18 12:00:00	AMZN	Stock	13.4855	13.5414	13.481	13.532	3699060.0
2013-01-18 13:00:00	AMZN	Stock	13.5315	13.569	13.525	13.54	4333900.0

> showing 50 of 45,688 rows — these rows as CSV

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