PREVIEW / stock_1hour / 2010-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-20.parquet
  size:    875 KB
  rows:    42,123
  symbols: 3,463

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-07-20 05:00:00	AAPL	Stock	8.735	8.7357	8.6868	8.6964	54320.0
2010-07-20 06:00:00	AAPL	Stock	8.6868	8.6868	8.6607	8.6711	73948.0
2010-07-20 07:00:00	AAPL	Stock	8.6575	8.7	8.6571	8.6957	289520.0
2010-07-20 08:00:00	AAPL	Stock	8.6964	8.7125	8.6289	8.6432	4640384.0
2010-07-20 09:00:00	AAPL	Stock	8.6457	8.6854	8.5718	8.6475	118512100.0
2010-07-20 10:00:00	AAPL	Stock	8.6475	8.7714	8.6332	8.7325	137775540.0
2010-07-20 11:00:00	AAPL	Stock	8.7323	8.8346	8.7286	8.8129	131054392.0
2010-07-20 12:00:00	AAPL	Stock	8.8157	8.8661	8.8125	8.8657	72980040.0
2010-07-20 13:00:00	AAPL	Stock	8.8656	8.9554	8.8636	8.9371	134813700.0
2010-07-20 14:00:00	AAPL	Stock	8.9379	8.9786	8.9236	8.9571	123667936.0
2010-07-20 15:00:00	AAPL	Stock	8.9596	9.0321	8.9486	9.0025	179547116.0
2010-07-20 16:00:00	AAPL	Stock	8.9996	9.3929	8.6851	9.255	132274296.0
2010-07-20 17:00:00	AAPL	Stock	9.26	9.3107	9.1518	9.1821	25718504.0
2010-07-20 18:00:00	AAPL	Stock	9.1846	9.2796	8.9961	9.2564	6865628.0
2010-07-20 19:00:00	AAPL	Stock	9.2582	9.2786	9.2518	9.2571	2770376.0
2010-07-20 04:00:00	MSFT	Stock	24.9	24.9	24.6	24.6	484.0
2010-07-20 07:00:00	MSFT	Stock	24.87	24.88	24.84	24.85	1207.0
2010-07-20 08:00:00	MSFT	Stock	24.88	25.0	24.82	25.0	16425.0
2010-07-20 09:00:00	MSFT	Stock	24.99	24.99	24.74	24.86	5474994.0
2010-07-20 10:00:00	MSFT	Stock	24.86	24.95	24.7	24.91	6441856.0
2010-07-20 11:00:00	MSFT	Stock	24.92	25.06	24.91	24.91	3868965.0
2010-07-20 12:00:00	MSFT	Stock	24.92	25.05	24.91	25.026	3868593.0
2010-07-20 13:00:00	MSFT	Stock	25.03	25.325	24.97	25.315	6878466.0
2010-07-20 14:00:00	MSFT	Stock	25.32	25.35	25.22	25.262	6797322.0
2010-07-20 15:00:00	MSFT	Stock	25.27	25.48	24.93	25.47	8600411.0
2010-07-20 16:00:00	MSFT	Stock	25.48	25.78	25.094	25.66	1629293.0
2010-07-20 17:00:00	MSFT	Stock	25.69	25.71	25.62	25.65	27400.0
2010-07-20 18:00:00	MSFT	Stock	25.65	25.69	25.48	25.6	22066.0
2010-07-20 19:00:00	MSFT	Stock	25.63	25.63	25.6	25.6	1443.0
2010-07-20 08:00:00	NVDA	Stock	0.2538	0.255	0.2538	0.2545	924720.0
2010-07-20 09:00:00	NVDA	Stock	0.2543	0.258	0.2525	0.2575	123032080.0
2010-07-20 10:00:00	NVDA	Stock	0.2575	0.2618	0.2568	0.261	207179680.0
2010-07-20 11:00:00	NVDA	Stock	0.261	0.266	0.2608	0.2649	240004000.0
2010-07-20 12:00:00	NVDA	Stock	0.265	0.2663	0.2638	0.2655	112408560.0
2010-07-20 13:00:00	NVDA	Stock	0.2655	0.2695	0.2652	0.2692	160087960.0
2010-07-20 14:00:00	NVDA	Stock	0.269	0.2695	0.2655	0.2675	111267560.0
2010-07-20 15:00:00	NVDA	Stock	0.2672	0.2695	0.267	0.2683	194977680.0
2010-07-20 16:00:00	NVDA	Stock	0.268	0.2695	0.2638	0.2695	9038160.0
2010-07-20 17:00:00	NVDA	Stock	0.2695	0.27	0.2692	0.2698	432200.0
2010-07-20 18:00:00	NVDA	Stock	0.2703	0.2703	0.2695	0.2695	436000.0
2010-07-20 19:00:00	NVDA	Stock	0.2695	0.271	0.2688	0.271	232000.0
2010-07-20 05:00:00	AMZN	Stock	5.997	5.998	5.997	5.998	36400.0
2010-07-20 06:00:00	AMZN	Stock	5.998	5.998	5.998	5.998	2000.0
2010-07-20 07:00:00	AMZN	Stock	5.985	6.0	5.9845	6.0	22000.0
2010-07-20 08:00:00	AMZN	Stock	5.9975	6.025	5.9635	6.0	353320.0
2010-07-20 09:00:00	AMZN	Stock	6.0035	6.052	5.9175	5.928	21994040.0
2010-07-20 10:00:00	AMZN	Stock	5.9275	5.975	5.8865	5.8955	27110060.0
2010-07-20 11:00:00	AMZN	Stock	5.8965	5.9345	5.8755	5.8985	20108500.0
2010-07-20 12:00:00	AMZN	Stock	5.898	5.915	5.8825	5.9145	9728460.0
2010-07-20 13:00:00	AMZN	Stock	5.9147	5.9525	5.9005	5.9435	15718320.0

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

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