PREVIEW / stock_1hour / 2013-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-25.parquet
  size:    985 KB
  rows:    46,046
  symbols: 3,496

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-02-25 04:00:00	AAPL	Stock	16.1679	16.1679	16.1679	16.1679	5600.0
2013-02-25 05:00:00	AAPL	Stock	16.2393	16.2429	16.2393	16.2429	5600.0
2013-02-25 06:00:00	AAPL	Stock	16.2429	16.2429	16.1964	16.2071	88900.0
2013-02-25 07:00:00	AAPL	Stock	16.2179	16.2536	16.2007	16.2429	576548.0
2013-02-25 08:00:00	AAPL	Stock	16.2429	16.25	16.0714	16.1518	1524320.0
2013-02-25 09:00:00	AAPL	Stock	16.1518	16.2432	16.1439	16.2214	52633252.0
2013-02-25 10:00:00	AAPL	Stock	16.2221	16.2543	16.0896	16.1225	74376708.0
2013-02-25 11:00:00	AAPL	Stock	16.1232	16.1282	15.9893	16.0154	51587284.0
2013-02-25 12:00:00	AAPL	Stock	16.0132	16.0764	16.0046	16.06	22949752.0
2013-02-25 13:00:00	AAPL	Stock	16.0621	16.0857	15.9918	16.0061	26491108.0
2013-02-25 14:00:00	AAPL	Stock	16.005	16.0257	15.9536	16.0054	32318888.0
2013-02-25 15:00:00	AAPL	Stock	16.0071	16.01	15.8061	15.8189	82066348.0
2013-02-25 16:00:00	AAPL	Stock	15.8143	16.1327	15.7682	15.8036	16189852.0
2013-02-25 17:00:00	AAPL	Stock	15.8086	15.82	15.8011	15.8164	972748.0
2013-02-25 18:00:00	AAPL	Stock	15.8179	15.8389	15.8146	15.8304	453096.0
2013-02-25 19:00:00	AAPL	Stock	15.8304	15.8621	15.8304	15.8618	526372.0
2013-02-25 08:00:00	MSFT	Stock	27.85	27.89	27.71	27.86	15973.0
2013-02-25 09:00:00	MSFT	Stock	27.88	28.05	27.86	27.89	3715886.0
2013-02-25 10:00:00	MSFT	Stock	27.89	27.96	27.78	27.82	6858238.0
2013-02-25 11:00:00	MSFT	Stock	27.825	27.84	27.66	27.715	6121059.0
2013-02-25 12:00:00	MSFT	Stock	27.71	27.81	27.69	27.77	2887543.0
2013-02-25 13:00:00	MSFT	Stock	27.774	27.8	27.665	27.69	4338421.0
2013-02-25 14:00:00	MSFT	Stock	27.69	27.7	27.61	27.681	4947963.0
2013-02-25 15:00:00	MSFT	Stock	27.68	27.7	27.37	27.38	14436454.0
2013-02-25 16:00:00	MSFT	Stock	27.38	27.782	27.32	27.34	4144305.0
2013-02-25 17:00:00	MSFT	Stock	27.34	27.78	27.34	27.35	15249.0
2013-02-25 18:00:00	MSFT	Stock	27.37	27.41	27.35	27.38	2905.0
2013-02-25 19:00:00	MSFT	Stock	27.4	27.41	27.39	27.41	6200.0
2013-02-25 07:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	4000.0
2013-02-25 08:00:00	NVDA	Stock	0.314	0.314	0.3138	0.3138	44000.0
2013-02-25 09:00:00	NVDA	Stock	0.315	0.3163	0.3133	0.3153	42687840.0
2013-02-25 10:00:00	NVDA	Stock	0.3155	0.3163	0.3103	0.3128	92098240.0
2013-02-25 11:00:00	NVDA	Stock	0.3128	0.3138	0.31	0.3103	53561280.0
2013-02-25 12:00:00	NVDA	Stock	0.3103	0.311	0.3095	0.3108	47488240.0
2013-02-25 13:00:00	NVDA	Stock	0.3105	0.311	0.3098	0.3105	47774480.0
2013-02-25 14:00:00	NVDA	Stock	0.3105	0.3106	0.3095	0.3105	96472040.0
2013-02-25 15:00:00	NVDA	Stock	0.3104	0.3108	0.307	0.3078	219183960.0
2013-02-25 16:00:00	NVDA	Stock	0.3075	0.3108	0.3073	0.3075	15143960.0
2013-02-25 07:00:00	AMZN	Stock	13.3625	13.3625	13.3625	13.3625	2000.0
2013-02-25 08:00:00	AMZN	Stock	13.328	13.346	13.328	13.3315	18420.0
2013-02-25 09:00:00	AMZN	Stock	13.3375	13.4347	13.3375	13.3775	9521780.0
2013-02-25 10:00:00	AMZN	Stock	13.3725	13.421	13.2637	13.2972	9934840.0
2013-02-25 11:00:00	AMZN	Stock	13.296	13.368	13.208	13.23	7642440.0
2013-02-25 12:00:00	AMZN	Stock	13.233	13.266	13.2095	13.257	6242700.0
2013-02-25 13:00:00	AMZN	Stock	13.2527	13.292	13.166	13.179	4354020.0
2013-02-25 14:00:00	AMZN	Stock	13.176	13.213	13.128	13.174	5297880.0
2013-02-25 15:00:00	AMZN	Stock	13.1755	13.185	12.9825	12.9935	13591120.0
2013-02-25 16:00:00	AMZN	Stock	12.9935	13.3257	12.9921	12.9935	3743540.0
2013-02-25 17:00:00	AMZN	Stock	12.9935	13.025	12.9935	13.014	38900.0
2013-02-25 18:00:00	AMZN	Stock	13.0105	13.02	13.0105	13.02	8000.0

> showing 50 of 46,046 rows — these rows as CSV

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