PREVIEW / stock_1hour / 2010-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-15.parquet
  size:    926 KB
  rows:    44,014
  symbols: 3,507

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
2010-11-15 04:00:00	AAPL	Stock	11.0154	11.0154	11.0154	11.0154	2800.0
2010-11-15 06:00:00	AAPL	Stock	11.0536	11.0625	11.0536	11.0625	42840.0
2010-11-15 07:00:00	AAPL	Stock	11.0536	11.0764	11.0446	11.0714	415044.0
2010-11-15 08:00:00	AAPL	Stock	11.0625	11.0786	11.0489	11.0714	3422412.0
2010-11-15 09:00:00	AAPL	Stock	11.0718	11.0907	10.9964	11.0068	70991340.0
2010-11-15 10:00:00	AAPL	Stock	11.0054	11.0554	10.9382	11.0425	93096556.0
2010-11-15 11:00:00	AAPL	Stock	11.0419	11.0571	10.9754	11.0207	51822736.0
2010-11-15 12:00:00	AAPL	Stock	11.0217	11.0525	10.9957	11.0464	29475488.0
2010-11-15 13:00:00	AAPL	Stock	11.0464	11.0489	11.0079	11.0196	26422480.0
2010-11-15 14:00:00	AAPL	Stock	11.021	11.0357	10.9821	11.0117	32294808.0
2010-11-15 15:00:00	AAPL	Stock	11.0089	11.0179	10.9557	10.9789	71343496.0
2010-11-15 16:00:00	AAPL	Stock	10.9789	11.0628	10.95	10.9711	15012788.0
2010-11-15 17:00:00	AAPL	Stock	10.9711	11.0036	10.9675	10.9868	972412.0
2010-11-15 18:00:00	AAPL	Stock	10.9882	11.0143	10.9657	10.9921	482328.0
2010-11-15 19:00:00	AAPL	Stock	10.9904	10.9914	10.9661	10.9782	501480.0
2010-11-15 07:00:00	MSFT	Stock	26.29	26.3	26.29	26.29	1000.0
2010-11-15 08:00:00	MSFT	Stock	26.28	26.33	26.28	26.3	22160.0
2010-11-15 09:00:00	MSFT	Stock	26.3	26.5	26.29	26.29	7293224.0
2010-11-15 10:00:00	MSFT	Stock	26.3	26.36	26.2	26.258	7447700.0
2010-11-15 11:00:00	MSFT	Stock	26.255	26.37	26.17	26.321	6740105.0
2010-11-15 12:00:00	MSFT	Stock	26.32	26.36	26.2	26.26	3294415.0
2010-11-15 13:00:00	MSFT	Stock	26.262	26.29	26.24	26.25	4215518.0
2010-11-15 14:00:00	MSFT	Stock	26.25	26.38	26.22	26.345	4912019.0
2010-11-15 15:00:00	MSFT	Stock	26.35	26.35	26.2	26.24	11946986.0
2010-11-15 16:00:00	MSFT	Stock	26.23	26.29	26.18	26.29	3688456.0
2010-11-15 17:00:00	MSFT	Stock	26.22	26.32	26.21	26.3	33286.0
2010-11-15 18:00:00	MSFT	Stock	26.3	26.31	26.2	26.25	38088.0
2010-11-15 19:00:00	MSFT	Stock	26.27	26.31	26.2	26.2	30450.0
2010-11-15 08:00:00	NVDA	Stock	0.3315	0.3345	0.3315	0.3322	860560.0
2010-11-15 09:00:00	NVDA	Stock	0.3325	0.3378	0.3318	0.3322	134856800.0
2010-11-15 10:00:00	NVDA	Stock	0.3322	0.3345	0.3303	0.3322	114917480.0
2010-11-15 11:00:00	NVDA	Stock	0.3322	0.3335	0.3293	0.3333	93158840.0
2010-11-15 12:00:00	NVDA	Stock	0.3334	0.3335	0.331	0.3315	47503040.0
2010-11-15 13:00:00	NVDA	Stock	0.3314	0.3326	0.331	0.3325	45169520.0
2010-11-15 14:00:00	NVDA	Stock	0.3324	0.3333	0.3313	0.3314	72104680.0
2010-11-15 15:00:00	NVDA	Stock	0.3313	0.3314	0.3268	0.3278	179390960.0
2010-11-15 16:00:00	NVDA	Stock	0.3275	0.3318	0.327	0.328	14940800.0
2010-11-15 17:00:00	NVDA	Stock	0.328	0.3285	0.328	0.3285	73240.0
2010-11-15 18:00:00	NVDA	Stock	0.3283	0.3283	0.3275	0.328	165040.0
2010-11-15 19:00:00	NVDA	Stock	0.3285	0.3288	0.328	0.328	291480.0
2010-11-15 06:00:00	AMZN	Stock	8.375	8.375	8.375	8.375	4000.0
2010-11-15 07:00:00	AMZN	Stock	8.375	8.375	8.3225	8.325	49820.0
2010-11-15 08:00:00	AMZN	Stock	8.315	8.345	8.26	8.284	514820.0
2010-11-15 09:00:00	AMZN	Stock	8.2865	8.3075	8.036	8.046	35882260.0
2010-11-15 10:00:00	AMZN	Stock	8.0429	8.098	8.0135	8.0219	29616320.0
2010-11-15 11:00:00	AMZN	Stock	8.0224	8.0625	8.0035	8.0495	17581920.0
2010-11-15 12:00:00	AMZN	Stock	8.049	8.0665	8.01	8.0662	18475780.0
2010-11-15 13:00:00	AMZN	Stock	8.067	8.117	8.025	8.078	18443640.0
2010-11-15 14:00:00	AMZN	Stock	8.0795	8.099	8.0675	8.082	10724600.0
2010-11-15 15:00:00	AMZN	Stock	8.084	8.096	7.928	7.9445	52690220.0

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

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