PREVIEW / stock_30min / 2010-07-20

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-20.parquet
  size:    1.3 MB
  rows:    71,685
  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.735	8.735	8.735	2800.0
2010-07-20 05:30:00	AAPL	Stock	8.7357	8.7357	8.6868	8.6964	51520.0
2010-07-20 06:00:00	AAPL	Stock	8.6868	8.6868	8.6607	8.6607	42000.0
2010-07-20 06:30:00	AAPL	Stock	8.6607	8.6711	8.6607	8.6711	31948.0
2010-07-20 07:00:00	AAPL	Stock	8.6575	8.6946	8.6571	8.6789	115920.0
2010-07-20 07:30:00	AAPL	Stock	8.6807	8.7	8.6807	8.6957	173600.0
2010-07-20 08:00:00	AAPL	Stock	8.6964	8.7125	8.6289	8.6429	2314116.0
2010-07-20 08:30:00	AAPL	Stock	8.6432	8.6611	8.6429	8.6432	2326268.0
2010-07-20 09:00:00	AAPL	Stock	8.6457	8.68	8.64	8.6782	2317308.0
2010-07-20 09:30:00	AAPL	Stock	8.675	8.6854	8.5718	8.6475	116194792.0
2010-07-20 10:00:00	AAPL	Stock	8.6475	8.7054	8.6332	8.6898	72679880.0
2010-07-20 10:30:00	AAPL	Stock	8.6898	8.7714	8.6825	8.7325	65095660.0
2010-07-20 11:00:00	AAPL	Stock	8.7323	8.82	8.7286	8.8029	58480996.0
2010-07-20 11:30:00	AAPL	Stock	8.8041	8.8346	8.7771	8.8129	72573396.0
2010-07-20 12:00:00	AAPL	Stock	8.8157	8.8514	8.8125	8.8207	37836288.0
2010-07-20 12:30:00	AAPL	Stock	8.8207	8.8661	8.82	8.8657	35143752.0
2010-07-20 13:00:00	AAPL	Stock	8.8656	8.9179	8.8636	8.917	56143136.0
2010-07-20 13:30:00	AAPL	Stock	8.917	8.9554	8.9139	8.9371	78670564.0
2010-07-20 14:00:00	AAPL	Stock	8.9379	8.9711	8.9236	8.9486	61722584.0
2010-07-20 14:30:00	AAPL	Stock	8.9466	8.9786	8.9357	8.9571	61945352.0
2010-07-20 15:00:00	AAPL	Stock	8.9596	9.0246	8.9486	9.0096	73091984.0
2010-07-20 15:30:00	AAPL	Stock	9.0121	9.0321	8.9575	9.0025	106455132.0
2010-07-20 16:00:00	AAPL	Stock	8.9996	9.0289	8.6851	8.9429	13997536.0
2010-07-20 16:30:00	AAPL	Stock	8.9429	9.3929	8.7596	9.255	118276760.0
2010-07-20 17:00:00	AAPL	Stock	9.26	9.3107	9.2021	9.2496	15986628.0
2010-07-20 17:30:00	AAPL	Stock	9.2496	9.2564	9.1518	9.1821	9731876.0
2010-07-20 18:00:00	AAPL	Stock	9.1846	9.2529	8.9961	9.2529	4597544.0
2010-07-20 18:30:00	AAPL	Stock	9.2532	9.2796	9.25	9.2564	2268084.0
2010-07-20 19:00:00	AAPL	Stock	9.2582	9.2782	9.2539	9.2739	1300292.0
2010-07-20 19:30:00	AAPL	Stock	9.2739	9.2786	9.2518	9.2571	1470084.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.87	24.87	24.87	100.0
2010-07-20 07:30:00	MSFT	Stock	24.88	24.88	24.84	24.85	1107.0
2010-07-20 08:00:00	MSFT	Stock	24.88	24.9	24.82	24.85	2829.0
2010-07-20 08:30:00	MSFT	Stock	24.87	25.0	24.87	25.0	13596.0
2010-07-20 09:00:00	MSFT	Stock	24.99	24.99	24.8	24.86	134994.0
2010-07-20 09:30:00	MSFT	Stock	24.86	24.93	24.74	24.86	5340000.0
2010-07-20 10:00:00	MSFT	Stock	24.86	24.93	24.7	24.895	3238283.0
2010-07-20 10:30:00	MSFT	Stock	24.9	24.95	24.86	24.91	3203573.0
2010-07-20 11:00:00	MSFT	Stock	24.92	25.06	24.91	25.01	2175088.0
2010-07-20 11:30:00	MSFT	Stock	25.02	25.03	24.91	24.91	1693877.0
2010-07-20 12:00:00	MSFT	Stock	24.92	24.99	24.91	24.94	1386461.0
2010-07-20 12:30:00	MSFT	Stock	24.934	25.05	24.93	25.026	2482132.0
2010-07-20 13:00:00	MSFT	Stock	25.03	25.07	24.97	25.04	1781146.0
2010-07-20 13:30:00	MSFT	Stock	25.04	25.325	25.03	25.315	5097320.0
2010-07-20 14:00:00	MSFT	Stock	25.32	25.33	25.22	25.245	3558046.0
2010-07-20 14:30:00	MSFT	Stock	25.25	25.35	25.22	25.262	3239276.0
2010-07-20 15:00:00	MSFT	Stock	25.27	25.41	24.93	25.37	2785811.0
2010-07-20 15:30:00	MSFT	Stock	25.37	25.48	25.36	25.47	5814600.0
2010-07-20 16:00:00	MSFT	Stock	25.48	25.65	25.094	25.6	1497717.0

> showing 50 of 71,685 rows — these rows as CSV

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