PREVIEW / stock_1hour / 2010-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-19.parquet
  size:    928 KB
  rows:    44,941
  symbols: 3,525

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-19 04:00:00	AAPL	Stock	11.0357	11.0429	11.0093	11.0093	14000.0
2010-11-19 05:00:00	AAPL	Stock	11.0093	11.0332	10.9971	11.0332	19600.0
2010-11-19 06:00:00	AAPL	Stock	11.0429	11.0479	11.0429	11.0479	5600.0
2010-11-19 07:00:00	AAPL	Stock	11.0179	11.0379	10.9579	10.9864	136500.0
2010-11-19 08:00:00	AAPL	Stock	10.9857	11.0293	10.9754	11.0179	1504468.0
2010-11-19 09:00:00	AAPL	Stock	11.0182	11.0182	10.9464	10.9564	91715568.0
2010-11-19 10:00:00	AAPL	Stock	10.9579	10.9846	10.9214	10.9586	79199932.0
2010-11-19 11:00:00	AAPL	Stock	10.9596	10.9646	10.9014	10.9364	54573456.0
2010-11-19 12:00:00	AAPL	Stock	10.9375	10.9604	10.9168	10.9525	28107884.0
2010-11-19 13:00:00	AAPL	Stock	10.9525	10.9768	10.9482	10.9718	23535708.0
2010-11-19 14:00:00	AAPL	Stock	10.9721	10.9993	10.9607	10.9686	33105212.0
2010-11-19 15:00:00	AAPL	Stock	10.9689	10.98	10.9209	10.9607	55357036.0
2010-11-19 16:00:00	AAPL	Stock	10.9607	10.9869	10.9496	10.9575	12198368.0
2010-11-19 17:00:00	AAPL	Stock	10.9589	10.9629	10.9575	10.96	239288.0
2010-11-19 18:00:00	AAPL	Stock	10.9593	10.9621	10.9546	10.9571	198072.0
2010-11-19 19:00:00	AAPL	Stock	10.9571	10.9643	10.9571	10.9643	157360.0
2010-11-19 05:00:00	MSFT	Stock	25.95	25.95	25.95	25.95	200.0
2010-11-19 08:00:00	MSFT	Stock	25.84	25.93	25.82	25.87	4900.0
2010-11-19 09:00:00	MSFT	Stock	25.85	25.9	25.6	25.67	7915720.0
2010-11-19 10:00:00	MSFT	Stock	25.66	25.76	25.65	25.69	6691621.0
2010-11-19 11:00:00	MSFT	Stock	25.7	25.71	25.67	25.69	5357465.0
2010-11-19 12:00:00	MSFT	Stock	25.7	25.75	25.67	25.743	4058086.0
2010-11-19 13:00:00	MSFT	Stock	25.748	25.76	25.7	25.705	2983907.0
2010-11-19 14:00:00	MSFT	Stock	25.71	25.74	25.7	25.7	4986054.0
2010-11-19 15:00:00	MSFT	Stock	25.705	25.73	25.66	25.7	9173296.0
2010-11-19 16:00:00	MSFT	Stock	25.705	25.83	25.65	25.72	3655661.0
2010-11-19 17:00:00	MSFT	Stock	25.71	25.73	25.71	25.73	8072.0
2010-11-19 18:00:00	MSFT	Stock	25.73	25.73	25.69	25.73	32190.0
2010-11-19 19:00:00	MSFT	Stock	25.7	25.75	25.7	25.75	10497.0
2010-11-19 09:00:00	NVDA	Stock	0.3313	0.336	0.331	0.3355	86806520.0
2010-11-19 10:00:00	NVDA	Stock	0.3355	0.3373	0.3342	0.3362	58264280.0
2010-11-19 11:00:00	NVDA	Stock	0.336	0.342	0.3345	0.3419	148746520.0
2010-11-19 12:00:00	NVDA	Stock	0.3418	0.3422	0.3398	0.342	85444760.0
2010-11-19 13:00:00	NVDA	Stock	0.342	0.3428	0.3402	0.3405	60933880.0
2010-11-19 14:00:00	NVDA	Stock	0.3402	0.3438	0.3402	0.343	95211480.0
2010-11-19 15:00:00	NVDA	Stock	0.343	0.345	0.3422	0.344	162748000.0
2010-11-19 16:00:00	NVDA	Stock	0.3435	0.3448	0.34	0.3438	4402760.0
2010-11-19 17:00:00	NVDA	Stock	0.344	0.344	0.3435	0.3435	86000.0
2010-11-19 18:00:00	NVDA	Stock	0.344	0.345	0.344	0.345	51000.0
2010-11-19 19:00:00	NVDA	Stock	0.345	0.345	0.345	0.345	80000.0
2010-11-19 07:00:00	AMZN	Stock	8.205	8.205	8.202	8.202	10000.0
2010-11-19 08:00:00	AMZN	Stock	8.1885	8.25	8.1885	8.22	65720.0
2010-11-19 09:00:00	AMZN	Stock	8.2255	8.247	8.1725	8.1965	18123100.0
2010-11-19 10:00:00	AMZN	Stock	8.1945	8.1985	8.142	8.186	14950920.0
2010-11-19 11:00:00	AMZN	Stock	8.187	8.2095	8.176	8.197	9555440.0
2010-11-19 12:00:00	AMZN	Stock	8.1985	8.217	8.187	8.2055	8528920.0
2010-11-19 13:00:00	AMZN	Stock	8.207	8.22	8.196	8.2195	9260900.0
2010-11-19 14:00:00	AMZN	Stock	8.2195	8.239	8.2105	8.2278	10684260.0
2010-11-19 15:00:00	AMZN	Stock	8.228	8.2495	8.2115	8.236	15263520.0
2010-11-19 16:00:00	AMZN	Stock	8.2405	8.25	8.2035	8.2405	2648920.0

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

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