PREVIEW / stock_1hour / 2012-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-19.parquet
  size:    932 KB
  rows:    44,531
  symbols: 3,506

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-04-19 04:00:00	AAPL	Stock	21.6818	21.75	21.6764	21.6764	100660.0
2012-04-19 05:00:00	AAPL	Stock	21.6893	21.7143	21.6357	21.7143	88732.0
2012-04-19 06:00:00	AAPL	Stock	21.7139	21.75	21.6982	21.7143	83888.0
2012-04-19 07:00:00	AAPL	Stock	21.7143	21.8214	21.6518	21.7143	1503684.0
2012-04-19 08:00:00	AAPL	Stock	21.7143	21.7854	21.3857	21.4211	10353896.0
2012-04-19 09:00:00	AAPL	Stock	21.4196	21.5976	21.2965	21.4475	130343780.0
2012-04-19 10:00:00	AAPL	Stock	21.4414	21.5489	21.2786	21.4789	130965492.0
2012-04-19 11:00:00	AAPL	Stock	21.4789	21.5404	21.3868	21.4121	58916620.0
2012-04-19 12:00:00	AAPL	Stock	21.4164	21.4282	21.25	21.2768	80605056.0
2012-04-19 13:00:00	AAPL	Stock	21.2746	21.3439	21.0221	21.0593	96657596.0
2012-04-19 14:00:00	AAPL	Stock	21.0525	21.1246	20.8757	21.0714	167663356.0
2012-04-19 15:00:00	AAPL	Stock	21.0711	21.1354	20.94	20.9982	138398848.0
2012-04-19 16:00:00	AAPL	Stock	20.9909	21.3264	20.9754	21.0179	9033864.0
2012-04-19 17:00:00	AAPL	Stock	21.0254	21.0279	20.98	20.9982	772632.0
2012-04-19 18:00:00	AAPL	Stock	20.9996	21.0	20.9761	20.9918	436268.0
2012-04-19 19:00:00	AAPL	Stock	20.9925	20.9925	20.9339	20.9486	716688.0
2012-04-19 04:00:00	MSFT	Stock	31.22	31.27	31.22	31.27	600.0
2012-04-19 07:00:00	MSFT	Stock	31.25	31.25	31.1	31.12	8210.0
2012-04-19 08:00:00	MSFT	Stock	31.18	31.19	31.0	31.09	46438.0
2012-04-19 09:00:00	MSFT	Stock	31.1	31.48	31.01	31.44	6340562.0
2012-04-19 10:00:00	MSFT	Stock	31.44	31.68	31.2	31.54	9621859.0
2012-04-19 11:00:00	MSFT	Stock	31.54	31.61	31.37	31.44	4135426.0
2012-04-19 12:00:00	MSFT	Stock	31.43	31.45	31.16	31.16	5033255.0
2012-04-19 13:00:00	MSFT	Stock	31.16	31.26	31.04	31.18	4987593.0
2012-04-19 14:00:00	MSFT	Stock	31.18	31.2	30.94	31.065	6300002.0
2012-04-19 15:00:00	MSFT	Stock	31.06	31.18	31.0	31.05	12235822.0
2012-04-19 16:00:00	MSFT	Stock	31.018	31.98	30.69	31.93	5111815.0
2012-04-19 17:00:00	MSFT	Stock	31.92	32.0	31.86	31.91	369392.0
2012-04-19 18:00:00	MSFT	Stock	31.91	31.99	31.9	31.99	97807.0
2012-04-19 19:00:00	MSFT	Stock	31.99	32.01	31.94	31.97	78818.0
2012-04-19 07:00:00	NVDA	Stock	0.3475	0.3475	0.3475	0.3475	40000.0
2012-04-19 08:00:00	NVDA	Stock	0.345	0.345	0.3415	0.3425	458000.0
2012-04-19 09:00:00	NVDA	Stock	0.3438	0.3498	0.3413	0.349	74553560.0
2012-04-19 10:00:00	NVDA	Stock	0.349	0.3553	0.3465	0.352	148579240.0
2012-04-19 11:00:00	NVDA	Stock	0.3518	0.3533	0.3448	0.346	155172640.0
2012-04-19 12:00:00	NVDA	Stock	0.3462	0.3465	0.3435	0.3435	78700960.0
2012-04-19 13:00:00	NVDA	Stock	0.3435	0.344	0.342	0.3422	47178320.0
2012-04-19 14:00:00	NVDA	Stock	0.3422	0.3428	0.3398	0.3415	44312240.0
2012-04-19 15:00:00	NVDA	Stock	0.3416	0.3428	0.3408	0.3415	106450960.0
2012-04-19 16:00:00	NVDA	Stock	0.342	0.3468	0.3415	0.3424	1001720.0
2012-04-19 17:00:00	NVDA	Stock	0.3422	0.3438	0.3414	0.3438	1179720.0
2012-04-19 18:00:00	NVDA	Stock	0.3438	0.3438	0.3438	0.3438	216800.0
2012-04-19 19:00:00	NVDA	Stock	0.3438	0.344	0.3438	0.344	112000.0
2012-04-19 05:00:00	AMZN	Stock	9.6115	9.6115	9.6115	9.6115	2000.0
2012-04-19 06:00:00	AMZN	Stock	9.6245	9.625	9.616	9.625	24000.0
2012-04-19 07:00:00	AMZN	Stock	9.625	9.67	9.625	9.67	132000.0
2012-04-19 08:00:00	AMZN	Stock	9.685	9.686	9.625	9.6275	204320.0
2012-04-19 09:00:00	AMZN	Stock	9.63	9.7275	9.6005	9.6735	10972140.0
2012-04-19 10:00:00	AMZN	Stock	9.674	9.705	9.594	9.663	12574120.0
2012-04-19 11:00:00	AMZN	Stock	9.662	9.6675	9.612	9.6185	9050820.0

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

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