PREVIEW / stock_30min / 2009-06-12

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-12.parquet
  size:    1.3 MB
  rows:    73,347
  symbols: 3,363

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
2009-06-12 07:00:00	AAPL	Stock	4.9818	4.9818	4.98	4.98	9800.0
2009-06-12 08:00:00	AAPL	Stock	4.98	4.9821	4.9593	4.9593	332752.0
2009-06-12 08:30:00	AAPL	Stock	4.9621	5.0	4.9536	4.9571	791308.0
2009-06-12 09:00:00	AAPL	Stock	4.9571	4.9668	4.9536	4.9593	523544.0
2009-06-12 09:30:00	AAPL	Stock	4.9575	4.9679	4.8964	4.8993	85692124.0
2009-06-12 10:00:00	AAPL	Stock	4.8993	4.9132	4.8764	4.8939	60304524.0
2009-06-12 10:30:00	AAPL	Stock	4.8939	4.9032	4.8796	4.8914	44411892.0
2009-06-12 11:00:00	AAPL	Stock	4.8914	4.8968	4.8857	4.8942	21603400.0
2009-06-12 11:30:00	AAPL	Stock	4.8936	4.8954	4.8789	4.8821	23593136.0
2009-06-12 12:00:00	AAPL	Stock	4.8825	4.8911	4.8739	4.8781	25381524.0
2009-06-12 12:30:00	AAPL	Stock	4.8782	4.8793	4.8625	4.875	38850588.0
2009-06-12 13:00:00	AAPL	Stock	4.875	4.88	4.8679	4.8702	19704412.0
2009-06-12 13:30:00	AAPL	Stock	4.87	4.87	4.8586	4.8632	35627004.0
2009-06-12 14:00:00	AAPL	Stock	4.8632	4.8761	4.8589	4.8711	30859080.0
2009-06-12 14:30:00	AAPL	Stock	4.8721	4.8925	4.8679	4.8869	48432832.0
2009-06-12 15:00:00	AAPL	Stock	4.8875	4.8986	4.8796	4.8857	39392276.0
2009-06-12 15:30:00	AAPL	Stock	4.8857	4.8946	4.8736	4.8864	72279032.0
2009-06-12 16:00:00	AAPL	Stock	4.8868	4.9	4.8808	4.8918	10487904.0
2009-06-12 16:30:00	AAPL	Stock	4.8889	4.8918	4.8857	4.8857	787304.0
2009-06-12 17:00:00	AAPL	Stock	4.8839	4.8857	4.88	4.8825	333900.0
2009-06-12 17:30:00	AAPL	Stock	4.8918	4.8918	4.8807	4.8821	204540.0
2009-06-12 18:00:00	AAPL	Stock	4.8836	4.8918	4.8836	4.8857	790300.0
2009-06-12 18:30:00	AAPL	Stock	4.8857	4.8857	4.8807	4.8807	42252.0
2009-06-12 19:00:00	AAPL	Stock	4.8839	4.885	4.8807	4.885	53200.0
2009-06-12 19:30:00	AAPL	Stock	4.885	4.8889	4.8786	4.8793	221032.0
2009-06-12 07:00:00	MSFT	Stock	22.8	22.8	22.8	22.8	1200.0
2009-06-12 07:30:00	MSFT	Stock	22.8	22.84	22.8	22.84	1000.0
2009-06-12 08:00:00	MSFT	Stock	22.74	22.8	22.7	22.73	6000.0
2009-06-12 08:30:00	MSFT	Stock	22.76	22.86	22.75	22.81	507972.0
2009-06-12 09:00:00	MSFT	Stock	22.82	22.9	22.81	22.9	64984.0
2009-06-12 09:30:00	MSFT	Stock	22.9	22.99	22.83	22.85	8317555.0
2009-06-12 10:00:00	MSFT	Stock	22.85	22.965	22.78	22.85	6305195.0
2009-06-12 10:30:00	MSFT	Stock	22.85	22.99	22.81	22.92	2803467.0
2009-06-12 11:00:00	MSFT	Stock	22.93	22.97	22.85	22.88	2910404.0
2009-06-12 11:30:00	MSFT	Stock	22.884	22.9	22.74	22.85	2818329.0
2009-06-12 12:00:00	MSFT	Stock	22.86	22.87	22.79	22.849	1070233.0
2009-06-12 12:30:00	MSFT	Stock	22.848	22.96	22.84	22.95	1915430.0
2009-06-12 13:00:00	MSFT	Stock	22.96	22.98	22.88	22.89	1225671.0
2009-06-12 13:30:00	MSFT	Stock	22.9	22.96	22.84	22.945	1854334.0
2009-06-12 14:00:00	MSFT	Stock	22.94	23.03	22.92	23.01	2169729.0
2009-06-12 14:30:00	MSFT	Stock	23.01	23.25	23.01	23.18	4138755.0
2009-06-12 15:00:00	MSFT	Stock	23.19	23.29	23.19	23.265	3976254.0
2009-06-12 15:30:00	MSFT	Stock	23.26	23.38	23.2	23.34	7979320.0
2009-06-12 16:00:00	MSFT	Stock	23.37	23.4	22.85	23.34	1933620.0
2009-06-12 16:30:00	MSFT	Stock	23.33	23.36	23.32	23.33	143784.0
2009-06-12 17:00:00	MSFT	Stock	23.33	23.35	23.31	23.35	5470.0
2009-06-12 17:30:00	MSFT	Stock	23.32	23.36	23.31	23.34	20358.0
2009-06-12 18:00:00	MSFT	Stock	23.33	23.34	23.27	23.33	21166.0
2009-06-12 18:30:00	MSFT	Stock	23.35	23.35	23.3	23.3	350.0
2009-06-12 19:00:00	MSFT	Stock	23.32	23.33	23.32	23.33	1000.0

> showing 50 of 73,347 rows — these rows as CSV

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