PREVIEW / stock_1hour / 2011-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-23.parquet
  size:    915 KB
  rows:    44,100
  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-09-23 04:00:00	AAPL	Stock	14.4286	14.5	14.4286	14.4464	80920.0
2011-09-23 05:00:00	AAPL	Stock	14.4464	14.4521	14.3929	14.3929	67200.0
2011-09-23 06:00:00	AAPL	Stock	14.3939	14.3939	14.2146	14.25	101528.0
2011-09-23 07:00:00	AAPL	Stock	14.2857	14.2996	14.1786	14.2018	1463896.0
2011-09-23 08:00:00	AAPL	Stock	14.2071	14.3507	14.1271	14.25	6358548.0
2011-09-23 09:00:00	AAPL	Stock	14.25	14.5	14.25	14.4337	115124212.0
2011-09-23 10:00:00	AAPL	Stock	14.4332	14.4782	14.3586	14.4738	102594744.0
2011-09-23 11:00:00	AAPL	Stock	14.4711	14.5221	14.4018	14.4479	74916296.0
2011-09-23 12:00:00	AAPL	Stock	14.4444	14.4821	14.4018	14.4318	43486268.0
2011-09-23 13:00:00	AAPL	Stock	14.4321	14.5086	14.4146	14.5077	51307004.0
2011-09-23 14:00:00	AAPL	Stock	14.5082	14.5264	14.4289	14.4354	48073816.0
2011-09-23 15:00:00	AAPL	Stock	14.4371	14.4879	14.4157	14.4332	78372896.0
2011-09-23 16:00:00	AAPL	Stock	14.4332	14.4815	14.2861	14.4361	21063868.0
2011-09-23 17:00:00	AAPL	Stock	14.4389	14.4536	14.4186	14.4536	255472.0
2011-09-23 18:00:00	AAPL	Stock	14.4507	14.4518	14.4393	14.4439	126700.0
2011-09-23 19:00:00	AAPL	Stock	14.4421	14.4461	14.4286	14.4321	202720.0
2011-09-23 04:00:00	MSFT	Stock	25.33	25.33	25.33	25.33	700.0
2011-09-23 05:00:00	MSFT	Stock	25.18	25.18	25.1	25.1	338.0
2011-09-23 06:00:00	MSFT	Stock	25.05	25.05	24.8	24.8	2400.0
2011-09-23 07:00:00	MSFT	Stock	24.7	24.85	24.7	24.72	31110.0
2011-09-23 08:00:00	MSFT	Stock	24.74	25.06	24.63	24.85	38505.0
2011-09-23 09:00:00	MSFT	Stock	24.81	25.13	24.78	24.91	7547376.0
2011-09-23 10:00:00	MSFT	Stock	24.91	25.06	24.69	25.02	9215650.0
2011-09-23 11:00:00	MSFT	Stock	25.025	25.14	24.9	24.97	7331258.0
2011-09-23 12:00:00	MSFT	Stock	24.97	25.052	24.83	24.84	7051914.0
2011-09-23 13:00:00	MSFT	Stock	24.85	25.05	24.77	25.03	6771962.0
2011-09-23 14:00:00	MSFT	Stock	25.04	25.13	24.86	24.93	7004764.0
2011-09-23 15:00:00	MSFT	Stock	24.93	25.15	24.925	25.06	11826076.0
2011-09-23 16:00:00	MSFT	Stock	25.06	25.09	24.961	24.968	5720875.0
2011-09-23 17:00:00	MSFT	Stock	25.02	25.02	25.01	25.02	1235.0
2011-09-23 18:00:00	MSFT	Stock	25.06	25.06	25.01	25.01	38030.0
2011-09-23 19:00:00	MSFT	Stock	25.05	25.05	25.04	25.04	855.0
2011-09-23 06:00:00	NVDA	Stock	0.338	0.338	0.324	0.3263	188000.0
2011-09-23 07:00:00	NVDA	Stock	0.3268	0.3303	0.3268	0.33	265560.0
2011-09-23 08:00:00	NVDA	Stock	0.3313	0.3378	0.3275	0.3355	1135480.0
2011-09-23 09:00:00	NVDA	Stock	0.3355	0.3442	0.3333	0.3415	104198000.0
2011-09-23 10:00:00	NVDA	Stock	0.3415	0.3525	0.3378	0.3522	174814000.0
2011-09-23 11:00:00	NVDA	Stock	0.3522	0.3545	0.3428	0.3453	190484920.0
2011-09-23 12:00:00	NVDA	Stock	0.3453	0.3468	0.3413	0.3425	96022440.0
2011-09-23 13:00:00	NVDA	Stock	0.3428	0.3461	0.341	0.3455	129945760.0
2011-09-23 14:00:00	NVDA	Stock	0.3455	0.3468	0.34	0.3406	110643160.0
2011-09-23 15:00:00	NVDA	Stock	0.3408	0.3455	0.3402	0.3445	176602520.0
2011-09-23 16:00:00	NVDA	Stock	0.3453	0.3453	0.338	0.344	10368760.0
2011-09-23 17:00:00	NVDA	Stock	0.344	0.3448	0.344	0.3448	401280.0
2011-09-23 18:00:00	NVDA	Stock	0.3448	0.345	0.3438	0.3438	215560.0
2011-09-23 19:00:00	NVDA	Stock	0.3438	0.3462	0.3428	0.3462	357800.0
2011-09-23 05:00:00	AMZN	Stock	11.1995	11.1995	11.1495	11.1495	22000.0
2011-09-23 06:00:00	AMZN	Stock	11.1495	11.1495	11.1495	11.1495	2000.0
2011-09-23 07:00:00	AMZN	Stock	11.003	11.0085	10.9255	10.9475	101000.0
2011-09-23 08:00:00	AMZN	Stock	10.946	11.1615	10.93	11.0445	297560.0

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

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