PREVIEW / stock_1hour / 2012-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-23.parquet
  size:    609 KB
  rows:    26,706
  symbols: 3,325

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-11-23 04:00:00	AAPL	Stock	20.125	20.1429	20.125	20.1429	22400.0
2012-11-23 06:00:00	AAPL	Stock	20.1625	20.2479	20.1429	20.2479	103180.0
2012-11-23 07:00:00	AAPL	Stock	20.1875	20.1929	20.1239	20.1489	287896.0
2012-11-23 08:00:00	AAPL	Stock	20.16	20.21	20.1493	20.1893	1652896.0
2012-11-23 09:00:00	AAPL	Stock	20.1807	20.2743	20.1043	20.1089	56188272.0
2012-11-23 10:00:00	AAPL	Stock	20.1086	20.219	20.0929	20.2161	52274264.0
2012-11-23 11:00:00	AAPL	Stock	20.2129	20.3125	20.2046	20.2879	57438080.0
2012-11-23 12:00:00	AAPL	Stock	20.2879	20.4286	20.1938	20.4093	85288588.0
2012-11-23 13:00:00	AAPL	Stock	20.4196	20.4286	20.2011	20.4093	15330700.0
2012-11-23 14:00:00	AAPL	Stock	20.3993	20.4232	20.3993	20.4196	349832.0
2012-11-23 15:00:00	AAPL	Stock	20.4211	20.4268	20.4161	20.4268	228844.0
2012-11-23 16:00:00	AAPL	Stock	20.4218	20.4286	20.4214	20.4279	188496.0
2012-11-23 04:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	1150.0
2012-11-23 06:00:00	MSFT	Stock	27.15	27.15	27.15	27.15	200.0
2012-11-23 07:00:00	MSFT	Stock	27.12	27.13	27.07	27.1	10325.0
2012-11-23 08:00:00	MSFT	Stock	27.09	27.11	26.95	27.06	42036.0
2012-11-23 09:00:00	MSFT	Stock	27.06	27.43	26.95	27.39	6452985.0
2012-11-23 10:00:00	MSFT	Stock	27.4	27.67	27.39	27.585	10555633.0
2012-11-23 11:00:00	MSFT	Stock	27.585	27.66	27.56	27.63	4092946.0
2012-11-23 12:00:00	MSFT	Stock	27.63	27.77	27.52	27.7	8010676.0
2012-11-23 13:00:00	MSFT	Stock	27.7	27.706	26.95	27.64	3237519.0
2012-11-23 14:00:00	MSFT	Stock	27.64	27.65	27.58	27.61	9435.0
2012-11-23 15:00:00	MSFT	Stock	27.64	27.65	27.62	27.63	4856.0
2012-11-23 16:00:00	MSFT	Stock	27.65	27.65	27.62	27.62	850.0
2012-11-23 09:00:00	NVDA	Stock	0.2965	0.299	0.2962	0.297	52095600.0
2012-11-23 10:00:00	NVDA	Stock	0.297	0.3	0.2951	0.2994	72939440.0
2012-11-23 11:00:00	NVDA	Stock	0.2995	0.301	0.2985	0.3005	51857120.0
2012-11-23 12:00:00	NVDA	Stock	0.3005	0.301	0.2962	0.2972	91129280.0
2012-11-23 13:00:00	NVDA	Stock	0.2975	0.2982	0.2972	0.2978	8493200.0
2012-11-23 07:00:00	AMZN	Stock	11.95	11.9625	11.95	11.9625	4000.0
2012-11-23 08:00:00	AMZN	Stock	11.9625	11.965	11.94	11.944	138720.0
2012-11-23 09:00:00	AMZN	Stock	11.944	11.9945	11.824	11.8483	8857420.0
2012-11-23 10:00:00	AMZN	Stock	11.845	11.9285	11.825	11.8729	8747620.0
2012-11-23 11:00:00	AMZN	Stock	11.872	11.944	11.855	11.9365	5534720.0
2012-11-23 12:00:00	AMZN	Stock	11.9365	12.0	11.895	11.9905	9892260.0
2012-11-23 13:00:00	AMZN	Stock	11.9945	12.0	11.8916	12.0	2105120.0
2012-11-23 14:00:00	AMZN	Stock	11.991	12.005	11.991	11.991	26900.0
2012-11-23 15:00:00	AMZN	Stock	12.0	12.0185	11.9925	11.9925	114960.0
2012-11-23 16:00:00	AMZN	Stock	11.993	11.993	11.993	11.993	2000.0
2012-11-23 04:00:00	META	Stock	24.26	24.26	24.26	24.26	500.0
2012-11-23 06:00:00	META	Stock	24.36	24.42	24.36	24.42	2100.0
2012-11-23 07:00:00	META	Stock	24.36	24.42	24.34	24.37	6298.0
2012-11-23 08:00:00	META	Stock	24.38	24.77	23.9	24.67	627527.0
2012-11-23 09:00:00	META	Stock	24.67	24.7	24.08	24.12	10519785.0
2012-11-23 10:00:00	META	Stock	24.12	24.2	23.88	24.11	8624372.0
2012-11-23 11:00:00	META	Stock	24.11	24.19	24.02	24.045	4317016.0
2012-11-23 12:00:00	META	Stock	24.045	24.09	23.95	24.0	4771913.0
2012-11-23 13:00:00	META	Stock	24.0	24.162	23.93	24.0	349138.0
2012-11-23 14:00:00	META	Stock	24.0	24.01	23.98	23.98	18668.0
2012-11-23 15:00:00	META	Stock	24.02	24.02	23.97	23.97	11145.0

> showing 50 of 26,706 rows — these rows as CSV

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