PREVIEW / stock_1hour / 2010-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-30.parquet
  size:    948 KB
  rows:    44,524
  symbols: 3,510

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-30 04:00:00	AAPL	Stock	11.25	11.25	11.2214	11.2286	67200.0
2010-11-30 05:00:00	AAPL	Stock	11.2296	11.2586	11.2296	11.2586	61600.0
2010-11-30 06:00:00	AAPL	Stock	11.2536	11.2857	11.2536	11.2725	11200.0
2010-11-30 07:00:00	AAPL	Stock	11.2611	11.2721	11.2325	11.25	265020.0
2010-11-30 08:00:00	AAPL	Stock	11.2568	11.2679	11.1971	11.215	3528952.0
2010-11-30 09:00:00	AAPL	Stock	11.2136	11.2268	11.1268	11.1757	86431016.0
2010-11-30 10:00:00	AAPL	Stock	11.1757	11.2271	11.1554	11.1693	76396124.0
2010-11-30 11:00:00	AAPL	Stock	11.1696	11.1811	11.1339	11.1525	61046468.0
2010-11-30 12:00:00	AAPL	Stock	11.1529	11.1625	11.1082	11.1168	48576780.0
2010-11-30 13:00:00	AAPL	Stock	11.1189	11.1718	11.1082	11.1407	54217352.0
2010-11-30 14:00:00	AAPL	Stock	11.1414	11.1657	11.1082	11.1307	52307052.0
2010-11-30 15:00:00	AAPL	Stock	11.1304	11.1589	11.1025	11.1125	82727568.0
2010-11-30 16:00:00	AAPL	Stock	11.1143	11.1596	11.0871	11.0957	28290192.0
2010-11-30 17:00:00	AAPL	Stock	11.0971	11.1203	11.0932	11.1153	1043980.0
2010-11-30 18:00:00	AAPL	Stock	11.0971	11.1125	11.0968	11.0968	638652.0
2010-11-30 19:00:00	AAPL	Stock	11.0968	11.0996	11.0929	11.0932	436772.0
2010-11-30 05:00:00	MSFT	Stock	25.11	25.22	25.11	25.22	1800.0
2010-11-30 07:00:00	MSFT	Stock	25.39	25.39	25.14	25.21	10400.0
2010-11-30 08:00:00	MSFT	Stock	25.2	25.26	25.16	25.17	35655.0
2010-11-30 09:00:00	MSFT	Stock	25.18	25.34	25.0	25.33	9984660.0
2010-11-30 10:00:00	MSFT	Stock	25.33	25.47	25.27	25.31	12542066.0
2010-11-30 11:00:00	MSFT	Stock	25.3	25.38	25.25	25.33	7757482.0
2010-11-30 12:00:00	MSFT	Stock	25.33	25.35	25.26	25.334	5833741.0
2010-11-30 13:00:00	MSFT	Stock	25.33	25.4	25.32	25.365	4956488.0
2010-11-30 14:00:00	MSFT	Stock	25.362	25.39	25.3	25.332	7183668.0
2010-11-30 15:00:00	MSFT	Stock	25.338	25.38	25.22	25.23	11911046.0
2010-11-30 16:00:00	MSFT	Stock	25.22	25.459	25.16	25.2	11118603.0
2010-11-30 17:00:00	MSFT	Stock	25.2	25.275	25.17	25.21	45805.0
2010-11-30 18:00:00	MSFT	Stock	25.22	25.26	25.18	25.18	61133.0
2010-11-30 19:00:00	MSFT	Stock	25.2	25.22	25.2	25.22	1200.0
2010-11-30 08:00:00	NVDA	Stock	0.3425	0.3425	0.338	0.3388	88000.0
2010-11-30 09:00:00	NVDA	Stock	0.3395	0.3402	0.3348	0.3365	59653280.0
2010-11-30 10:00:00	NVDA	Stock	0.3365	0.339	0.334	0.3379	86933480.0
2010-11-30 11:00:00	NVDA	Stock	0.3378	0.3385	0.336	0.3374	52668000.0
2010-11-30 12:00:00	NVDA	Stock	0.3374	0.338	0.3353	0.336	61188640.0
2010-11-30 13:00:00	NVDA	Stock	0.336	0.3393	0.3355	0.3365	159958920.0
2010-11-30 14:00:00	NVDA	Stock	0.3365	0.3395	0.3358	0.3395	123735440.0
2010-11-30 15:00:00	NVDA	Stock	0.3393	0.342	0.339	0.3402	134573360.0
2010-11-30 16:00:00	NVDA	Stock	0.3395	0.3414	0.3362	0.3414	11164880.0
2010-11-30 17:00:00	NVDA	Stock	0.3405	0.3405	0.3405	0.3405	14680.0
2010-11-30 04:00:00	AMZN	Stock	8.993	8.993	8.993	8.993	2000.0
2010-11-30 05:00:00	AMZN	Stock	8.9765	8.9765	8.9765	8.9765	12000.0
2010-11-30 07:00:00	AMZN	Stock	8.95	8.95	8.9265	8.9265	21000.0
2010-11-30 08:00:00	AMZN	Stock	8.949	8.95	8.8635	8.8645	429540.0
2010-11-30 09:00:00	AMZN	Stock	8.88	8.9075	8.75	8.8025	26304540.0
2010-11-30 10:00:00	AMZN	Stock	8.806	8.885	8.7875	8.795	24488720.0
2010-11-30 11:00:00	AMZN	Stock	8.7951	8.82	8.7705	8.796	14733340.0
2010-11-30 12:00:00	AMZN	Stock	8.7965	8.8095	8.745	8.7905	13361500.0
2010-11-30 13:00:00	AMZN	Stock	8.7865	8.844	8.773	8.8045	12801740.0
2010-11-30 14:00:00	AMZN	Stock	8.8075	8.8245	8.7785	8.7935	11509740.0

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

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