PREVIEW / stock_1hour / 2012-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-17.parquet
  size:    965 KB
  rows:    46,185
  symbols: 3,534

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
2012-05-17 04:00:00	AAPL	Stock	19.4532	19.4532	19.4532	19.4532	5600.0
2012-05-17 05:00:00	AAPL	Stock	19.4286	19.4286	19.4196	19.4196	5600.0
2012-05-17 06:00:00	AAPL	Stock	19.4393	19.4407	19.4107	19.4107	61600.0
2012-05-17 07:00:00	AAPL	Stock	19.4279	19.4643	19.3332	19.4054	619528.0
2012-05-17 08:00:00	AAPL	Stock	19.4107	19.5564	19.3446	19.5429	3982720.0
2012-05-17 09:00:00	AAPL	Stock	19.5389	19.5807	19.1804	19.2489	117654768.0
2012-05-17 10:00:00	AAPL	Stock	19.2443	19.3636	19.0961	19.2392	158470676.0
2012-05-17 11:00:00	AAPL	Stock	19.2393	19.2779	19.0429	19.0957	95320316.0
2012-05-17 12:00:00	AAPL	Stock	19.0946	19.1	18.9804	19.0657	75942160.0
2012-05-17 13:00:00	AAPL	Stock	19.0675	19.2279	19.0596	19.1554	72277660.0
2012-05-17 14:00:00	AAPL	Stock	19.15	19.1525	19.0089	19.0793	58678060.0
2012-05-17 15:00:00	AAPL	Stock	19.0757	19.1282	18.9329	18.9329	113676220.0
2012-05-17 16:00:00	AAPL	Stock	18.9332	19.2332	18.9329	18.9504	8482936.0
2012-05-17 17:00:00	AAPL	Stock	18.9536	19.0157	18.9329	18.9996	2898112.0
2012-05-17 18:00:00	AAPL	Stock	18.9993	18.9993	18.9714	18.9786	560448.0
2012-05-17 19:00:00	AAPL	Stock	18.9818	19.0125	18.9771	19.0007	796684.0
2012-05-17 07:00:00	MSFT	Stock	29.88	29.88	29.8	29.8	320.0
2012-05-17 08:00:00	MSFT	Stock	29.9	30.0	29.81	29.91	12248.0
2012-05-17 09:00:00	MSFT	Stock	29.9	30.16	29.87	30.14	3805665.0
2012-05-17 10:00:00	MSFT	Stock	30.15	30.208	29.99	30.09	6538127.0
2012-05-17 11:00:00	MSFT	Stock	30.09	30.12	29.96	29.99	5359389.0
2012-05-17 12:00:00	MSFT	Stock	29.985	30.07	29.89	30.019	5319887.0
2012-05-17 13:00:00	MSFT	Stock	30.02	30.09	29.94	30.0	3807765.0
2012-05-17 14:00:00	MSFT	Stock	29.995	30.05	29.96	30.0	4448746.0
2012-05-17 15:00:00	MSFT	Stock	30.0	30.03	29.71	29.73	13642826.0
2012-05-17 16:00:00	MSFT	Stock	29.72	29.99	29.71	29.72	4085800.0
2012-05-17 17:00:00	MSFT	Stock	29.72	29.79	29.72	29.72	335680.0
2012-05-17 18:00:00	MSFT	Stock	29.73	29.75	29.73	29.75	520.0
2012-05-17 19:00:00	MSFT	Stock	29.72	29.76	29.72	29.76	2848.0
2012-05-17 09:00:00	NVDA	Stock	0.3213	0.3223	0.318	0.319	37884320.0
2012-05-17 10:00:00	NVDA	Stock	0.3188	0.3226	0.3168	0.3208	59280800.0
2012-05-17 11:00:00	NVDA	Stock	0.3208	0.3218	0.319	0.3207	36485040.0
2012-05-17 12:00:00	NVDA	Stock	0.3205	0.321	0.3183	0.3204	42646720.0
2012-05-17 13:00:00	NVDA	Stock	0.3205	0.3228	0.3203	0.3215	34684560.0
2012-05-17 14:00:00	NVDA	Stock	0.3213	0.3214	0.319	0.3195	32190040.0
2012-05-17 15:00:00	NVDA	Stock	0.3195	0.3205	0.3163	0.3163	78085280.0
2012-05-17 16:00:00	NVDA	Stock	0.3163	0.3196	0.3153	0.3163	2781480.0
2012-05-17 17:00:00	NVDA	Stock	0.3163	0.3163	0.315	0.3158	1102400.0
2012-05-17 19:00:00	NVDA	Stock	0.3153	0.3153	0.3133	0.3133	78000.0
2012-05-17 07:00:00	AMZN	Stock	11.18	11.192	11.18	11.192	5800.0
2012-05-17 08:00:00	AMZN	Stock	11.189	11.25	11.1645	11.195	114880.0
2012-05-17 09:00:00	AMZN	Stock	11.232	11.27	11.1375	11.2015	10037540.0
2012-05-17 10:00:00	AMZN	Stock	11.2045	11.3	11.13	11.148	16220940.0
2012-05-17 11:00:00	AMZN	Stock	11.1475	11.178	11.05	11.0825	14681900.0
2012-05-17 12:00:00	AMZN	Stock	11.0815	11.1475	11.0305	11.0996	8618680.0
2012-05-17 13:00:00	AMZN	Stock	11.1055	11.1874	11.0743	11.101	7574720.0
2012-05-17 14:00:00	AMZN	Stock	11.101	11.1045	11.04	11.0605	6891220.0
2012-05-17 15:00:00	AMZN	Stock	11.0585	11.0825	10.9045	10.92	22626740.0
2012-05-17 16:00:00	AMZN	Stock	10.922	11.165	10.9	10.918	1183160.0
2012-05-17 17:00:00	AMZN	Stock	10.918	10.93	10.918	10.9295	355180.0

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

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