PREVIEW / stock_1hour / 2013-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-24.parquet
  size:    690 KB
  rows:    29,267
  symbols: 3,461

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-12-24 04:00:00	AAPL	Stock	20.37	20.37	20.37	20.37	2800.0
2013-12-24 05:00:00	AAPL	Stock	20.3854	20.435	20.3854	20.435	42000.0
2013-12-24 06:00:00	AAPL	Stock	20.435	20.435	20.3929	20.4261	20524.0
2013-12-24 07:00:00	AAPL	Stock	20.4246	20.4246	20.3329	20.3571	283892.0
2013-12-24 08:00:00	AAPL	Stock	20.3446	20.4257	20.3257	20.3489	893704.0
2013-12-24 09:00:00	AAPL	Stock	20.3518	20.4243	20.2786	20.3651	48293196.0
2013-12-24 10:00:00	AAPL	Stock	20.3636	20.3725	20.2518	20.2714	42015428.0
2013-12-24 11:00:00	AAPL	Stock	20.2714	20.2739	20.2154	20.2179	23829848.0
2013-12-24 12:00:00	AAPL	Stock	20.2182	20.2796	20.2161	20.2757	24904796.0
2013-12-24 13:00:00	AAPL	Stock	20.2739	20.3061	20.2689	20.286	3115420.0
2013-12-24 14:00:00	AAPL	Stock	20.2829	20.2921	20.2814	20.2857	182840.0
2013-12-24 15:00:00	AAPL	Stock	20.2925	20.3036	20.2893	20.3036	197708.0
2013-12-24 16:00:00	AAPL	Stock	20.3054	20.3054	20.2739	20.2739	95340.0
2013-12-24 09:00:00	MSFT	Stock	36.63	36.94	36.6	36.91	2030337.0
2013-12-24 10:00:00	MSFT	Stock	36.9	37.17	36.86	37.04	4110304.0
2013-12-24 11:00:00	MSFT	Stock	37.03	37.11	36.995	37.06	2188729.0
2013-12-24 12:00:00	MSFT	Stock	37.06	37.14	37.024	37.09	3836707.0
2013-12-24 13:00:00	MSFT	Stock	37.1	37.15	36.678	37.088	1245856.0
2013-12-24 14:00:00	MSFT	Stock	37.15	37.15	37.09	37.09	200.0
2013-12-24 15:00:00	MSFT	Stock	37.15	37.15	37.15	37.15	1800.0
2013-12-24 16:00:00	MSFT	Stock	37.1	37.1	37.07	37.07	500.0
2013-12-24 09:00:00	NVDA	Stock	0.3968	0.3968	0.3922	0.3922	9685320.0
2013-12-24 10:00:00	NVDA	Stock	0.3925	0.3925	0.3915	0.3919	15477320.0
2013-12-24 11:00:00	NVDA	Stock	0.3919	0.3929	0.3915	0.3926	15326680.0
2013-12-24 12:00:00	NVDA	Stock	0.3925	0.3955	0.3925	0.3955	27060280.0
2013-12-24 13:00:00	NVDA	Stock	0.3953	0.3955	0.3935	0.3955	2116120.0
2013-12-24 14:00:00	NVDA	Stock	0.3956	0.3956	0.3956	0.3956	141320.0
2013-12-24 08:00:00	AMZN	Stock	20.185	20.185	20.1	20.15	62060.0
2013-12-24 09:00:00	AMZN	Stock	20.11	20.1862	19.9975	20.032	5327360.0
2013-12-24 10:00:00	AMZN	Stock	20.025	20.033	19.8185	19.9345	9090480.0
2013-12-24 11:00:00	AMZN	Stock	19.9325	19.9965	19.9105	19.975	4559740.0
2013-12-24 12:00:00	AMZN	Stock	19.975	19.991	19.933	19.96	5493300.0
2013-12-24 13:00:00	AMZN	Stock	19.96	19.9995	19.903	19.96	649100.0
2013-12-24 14:00:00	AMZN	Stock	19.9555	19.9925	19.9555	19.9555	14740.0
2013-12-24 06:00:00	META	Stock	57.97	57.98	57.97	57.98	1200.0
2013-12-24 07:00:00	META	Stock	57.98	58.03	57.75	57.76	53830.0
2013-12-24 08:00:00	META	Stock	57.77	58.25	57.1	58.25	863745.0
2013-12-24 09:00:00	META	Stock	58.25	58.58	57.71	57.74	12102485.0
2013-12-24 10:00:00	META	Stock	57.74	57.88	56.91	57.232	15336302.0
2013-12-24 11:00:00	META	Stock	57.239	57.84	57.05	57.79	7733991.0
2013-12-24 12:00:00	META	Stock	57.79	58.1	57.57	57.97	8626103.0
2013-12-24 13:00:00	META	Stock	57.96	58.06	57.686	58.01	908784.0
2013-12-24 14:00:00	META	Stock	58.01	58.06	58.01	58.05	37200.0
2013-12-24 15:00:00	META	Stock	58.04	58.12	58.04	58.1	48348.0
2013-12-24 16:00:00	META	Stock	58.1	58.12	58.01	58.04	29610.0
2013-12-24 06:00:00	TSLA	Stock	9.7553	9.7667	9.7333	9.7333	25500.0
2013-12-24 07:00:00	TSLA	Stock	9.73	9.7333	9.6927	9.7273	122805.0
2013-12-24 08:00:00	TSLA	Stock	9.7233	10.0593	9.7033	10.02	3741195.0
2013-12-24 09:00:00	TSLA	Stock	10.0167	10.3313	9.9833	10.3193	49988355.0
2013-12-24 10:00:00	TSLA	Stock	10.3233	10.3293	10.152	10.216	40482750.0

> showing 50 of 29,267 rows — these rows as CSV

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