PREVIEW / stock_30min / 2007-11-08

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-08.parquet
  size:    1.2 MB
  rows:    69,803
  symbols: 3,195

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
2007-11-08 05:00:00	AAPL	Stock	6.6154	6.6154	6.6154	6.6154	5600.0
2007-11-08 06:00:00	AAPL	Stock	6.6304	6.6457	6.6304	6.6457	50400.0
2007-11-08 06:30:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	16800.0
2007-11-08 07:00:00	AAPL	Stock	6.6964	6.7143	6.6875	6.6964	423780.0
2007-11-08 07:30:00	AAPL	Stock	6.6964	6.7232	6.6804	6.7054	865480.0
2007-11-08 08:00:00	AAPL	Stock	6.7136	6.7321	6.6854	6.7	2123296.0
2007-11-08 08:30:00	AAPL	Stock	6.7018	6.7054	6.6629	6.6679	2702700.0
2007-11-08 09:00:00	AAPL	Stock	6.6686	6.6875	6.6518	6.6618	2160564.0
2007-11-08 09:30:00	AAPL	Stock	6.6668	6.675	6.4471	6.5971	187813332.0
2007-11-08 10:00:00	AAPL	Stock	6.5986	6.5993	6.5061	6.5357	120048768.0
2007-11-08 10:30:00	AAPL	Stock	6.5354	6.5639	6.4793	6.5596	91718564.0
2007-11-08 11:00:00	AAPL	Stock	6.5593	6.5696	6.5134	6.5304	53090100.0
2007-11-08 11:30:00	AAPL	Stock	6.5314	6.5536	6.2896	6.3607	149773288.0
2007-11-08 12:00:00	AAPL	Stock	6.3607	6.3979	6.2057	6.315	179633748.0
2007-11-08 12:30:00	AAPL	Stock	6.315	6.3668	6.1407	6.2621	159817168.0
2007-11-08 13:00:00	AAPL	Stock	6.2625	6.2625	5.9918	6.1546	229032888.0
2007-11-08 13:30:00	AAPL	Stock	6.1554	6.2829	6.1529	6.2696	136651200.0
2007-11-08 14:00:00	AAPL	Stock	6.2686	6.295	6.1218	6.1882	110271028.0
2007-11-08 14:30:00	AAPL	Stock	6.1875	6.3	6.13	6.2904	103054140.0
2007-11-08 15:00:00	AAPL	Stock	6.2904	6.4286	6.2546	6.4168	166229056.0
2007-11-08 15:30:00	AAPL	Stock	6.4154	6.4821	6.2607	6.2671	172742836.0
2007-11-08 16:00:00	AAPL	Stock	6.2665	6.3397	6.1	6.2934	20810944.0
2007-11-08 16:30:00	AAPL	Stock	6.2814	6.6632	6.2143	6.2679	2294012.0
2007-11-08 17:00:00	AAPL	Stock	6.265	6.3105	6.2557	6.3105	1148028.0
2007-11-08 17:30:00	AAPL	Stock	6.275	6.3781	6.2679	6.27	448588.0
2007-11-08 18:00:00	AAPL	Stock	6.2746	6.2821	6.27	6.275	328916.0
2007-11-08 18:30:00	AAPL	Stock	6.275	6.2857	6.26	6.2782	536872.0
2007-11-08 19:00:00	AAPL	Stock	6.2839	6.2889	6.2714	6.2829	305396.0
2007-11-08 19:30:00	AAPL	Stock	6.2871	6.3232	6.2857	6.3214	406476.0
2007-11-08 20:00:00	AAPL	Stock	6.3214	6.3214	6.3214	6.3214	25200.0
2007-11-08 05:30:00	MSFT	Stock	35.04	35.04	35.04	35.04	500.0
2007-11-08 06:30:00	MSFT	Stock	35.04	35.25	35.04	35.25	3116.0
2007-11-08 07:00:00	MSFT	Stock	35.25	35.48	35.2	35.45	3600.0
2007-11-08 07:30:00	MSFT	Stock	35.37	35.37	35.22	35.22	1200.0
2007-11-08 08:00:00	MSFT	Stock	35.22	35.39	35.15	35.35	23467.0
2007-11-08 08:30:00	MSFT	Stock	35.35	35.5	35.35	35.4	11436.0
2007-11-08 09:00:00	MSFT	Stock	35.37	35.61	35.37	35.49	53168.0
2007-11-08 09:30:00	MSFT	Stock	35.49	35.75	35.37	35.6	8968239.0
2007-11-08 10:00:00	MSFT	Stock	35.6	35.9	35.46	35.73	10264027.0
2007-11-08 10:30:00	MSFT	Stock	35.73	35.75	35.54	35.66	7418994.0
2007-11-08 11:00:00	MSFT	Stock	35.67	35.71	35.47	35.49	5261880.0
2007-11-08 11:30:00	MSFT	Stock	35.49	35.67	35.45	35.62	5894504.0
2007-11-08 12:00:00	MSFT	Stock	35.62	35.69	35.45	35.53	4959679.0
2007-11-08 12:30:00	MSFT	Stock	35.53	35.56	34.97	34.98	9783459.0
2007-11-08 13:00:00	MSFT	Stock	34.98	35.0	34.66	34.93	10842656.0
2007-11-08 13:30:00	MSFT	Stock	34.93	35.04	34.78	34.91	9763128.0
2007-11-08 14:00:00	MSFT	Stock	34.91	34.92	34.67	34.72	7611767.0
2007-11-08 14:30:00	MSFT	Stock	34.72	34.77	34.53	34.692	7610786.0
2007-11-08 15:00:00	MSFT	Stock	34.7	34.79	34.4	34.78	15945700.0
2007-11-08 15:30:00	MSFT	Stock	34.78	34.99	34.56	34.71	14273277.0

> showing 50 of 69,803 rows — these rows as CSV

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