PREVIEW / stock_1hour / 2010-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-08.parquet
  size:    891 KB
  rows:    42,900
  symbols: 3,466

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-06-08 04:00:00	AAPL	Stock	9.0696	9.0696	9.0696	9.0696	2800.0
2010-06-08 05:00:00	AAPL	Stock	9.0018	9.0229	9.0018	9.0229	25340.0
2010-06-08 06:00:00	AAPL	Stock	9.0036	9.0036	9.0036	9.0036	13720.0
2010-06-08 07:00:00	AAPL	Stock	9.0089	9.0354	9.0	9.0	420280.0
2010-06-08 08:00:00	AAPL	Stock	9.0086	9.0939	8.9982	9.0432	6276900.0
2010-06-08 09:00:00	AAPL	Stock	9.0432	9.0643	8.9293	8.9588	119775208.0
2010-06-08 10:00:00	AAPL	Stock	8.9604	9.0143	8.8514	8.9137	174553148.0
2010-06-08 11:00:00	AAPL	Stock	8.915	9.0429	8.8571	8.9959	145543916.0
2010-06-08 12:00:00	AAPL	Stock	8.9968	9.0179	8.8929	8.9243	85983492.0
2010-06-08 13:00:00	AAPL	Stock	8.9243	8.9389	8.825	8.8561	107995552.0
2010-06-08 14:00:00	AAPL	Stock	8.8575	8.925	8.7996	8.8343	140433608.0
2010-06-08 15:00:00	AAPL	Stock	8.8336	8.9096	8.7732	8.9064	202211660.0
2010-06-08 16:00:00	AAPL	Stock	8.9057	8.966	8.8564	8.9036	11979464.0
2010-06-08 17:00:00	AAPL	Stock	8.9036	8.9271	8.9036	8.9221	646632.0
2010-06-08 18:00:00	AAPL	Stock	8.9179	8.9286	8.9046	8.925	355600.0
2010-06-08 19:00:00	AAPL	Stock	8.9196	8.9411	8.9196	8.9286	352604.0
2010-06-08 20:00:00	AAPL	Stock	8.97	8.97	8.97	8.97	193200.0
2010-06-08 07:00:00	MSFT	Stock	25.43	25.43	25.43	25.43	100.0
2010-06-08 08:00:00	MSFT	Stock	25.4	25.42	25.08	25.35	106758.0
2010-06-08 09:00:00	MSFT	Stock	25.38	25.42	24.98	25.01	8457385.0
2010-06-08 10:00:00	MSFT	Stock	25.02	25.1	24.65	24.82	17751105.0
2010-06-08 11:00:00	MSFT	Stock	24.82	25.03	24.75	24.94	14495584.0
2010-06-08 12:00:00	MSFT	Stock	24.94	24.97	24.75	24.86	8465478.0
2010-06-08 13:00:00	MSFT	Stock	24.86	24.89	24.69	24.81	8387607.0
2010-06-08 14:00:00	MSFT	Stock	24.81	25.03	24.8	24.89	9425554.0
2010-06-08 15:00:00	MSFT	Stock	24.9	25.16	24.86	25.11	16337416.0
2010-06-08 16:00:00	MSFT	Stock	25.12	25.293	24.798	25.08	2662810.0
2010-06-08 17:00:00	MSFT	Stock	25.08	25.08	25.07	25.08	29409.0
2010-06-08 18:00:00	MSFT	Stock	25.08	25.11	25.07	25.07	35474.0
2010-06-08 19:00:00	MSFT	Stock	25.07	25.08	25.05	25.07	10612.0
2010-06-08 20:00:00	MSFT	Stock	25.44	25.44	25.44	25.44	94600.0
2010-06-08 08:00:00	NVDA	Stock	0.2888	0.2888	0.2858	0.2858	242000.0
2010-06-08 09:00:00	NVDA	Stock	0.287	0.287	0.2778	0.278	134387360.0
2010-06-08 10:00:00	NVDA	Stock	0.2783	0.2795	0.2723	0.275	169745480.0
2010-06-08 11:00:00	NVDA	Stock	0.275	0.2783	0.2728	0.2769	154149920.0
2010-06-08 12:00:00	NVDA	Stock	0.277	0.2789	0.276	0.2786	122016200.0
2010-06-08 13:00:00	NVDA	Stock	0.2785	0.2791	0.2743	0.2758	106568880.0
2010-06-08 14:00:00	NVDA	Stock	0.2755	0.2798	0.2752	0.2768	81867920.0
2010-06-08 15:00:00	NVDA	Stock	0.2768	0.2805	0.2759	0.2795	165479520.0
2010-06-08 16:00:00	NVDA	Stock	0.2798	0.2884	0.2775	0.2792	8419800.0
2010-06-08 17:00:00	NVDA	Stock	0.2805	0.2805	0.2805	0.2805	4000.0
2010-06-08 18:00:00	NVDA	Stock	0.28	0.28	0.28	0.28	4000.0
2010-06-08 19:00:00	NVDA	Stock	0.28	0.2805	0.28	0.2805	108000.0
2010-06-08 08:00:00	AMZN	Stock	6.1	6.1	6.1	6.1	4000.0
2010-06-08 09:00:00	AMZN	Stock	6.1165	6.1165	5.8655	5.89	36328760.0
2010-06-08 10:00:00	AMZN	Stock	5.8925	5.9435	5.8065	5.856	39655560.0
2010-06-08 11:00:00	AMZN	Stock	5.855	5.9855	5.79	5.957	43393580.0
2010-06-08 12:00:00	AMZN	Stock	5.957	5.9985	5.936	5.9745	19364060.0
2010-06-08 13:00:00	AMZN	Stock	5.973	5.994	5.876	5.895	22872620.0
2010-06-08 14:00:00	AMZN	Stock	5.8985	5.945	5.851	5.868	22985200.0

> showing 50 of 42,900 rows — these rows as CSV

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