PREVIEW / stock_30min / 2008-11-26

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-26.parquet
  size:    1.2 MB
  rows:    69,624
  symbols: 3,351

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
2008-11-26 07:00:00	AAPL	Stock	3.225	3.225	3.225	3.225	2800.0
2008-11-26 07:30:00	AAPL	Stock	3.2071	3.2071	3.2071	3.2071	75600.0
2008-11-26 08:00:00	AAPL	Stock	3.1964	3.2071	3.1836	3.1929	1136240.0
2008-11-26 08:30:00	AAPL	Stock	3.1929	3.2304	3.1821	3.2046	1072512.0
2008-11-26 09:00:00	AAPL	Stock	3.2071	3.2229	3.2036	3.215	420476.0
2008-11-26 09:30:00	AAPL	Stock	3.2175	3.3204	3.2082	3.3046	110972540.0
2008-11-26 10:00:00	AAPL	Stock	3.3046	3.3664	3.3	3.3486	101549392.0
2008-11-26 10:30:00	AAPL	Stock	3.3489	3.375	3.3321	3.3561	67892076.0
2008-11-26 11:00:00	AAPL	Stock	3.3571	3.3886	3.3386	3.3571	56294924.0
2008-11-26 11:30:00	AAPL	Stock	3.3557	3.3929	3.3536	3.3686	59024700.0
2008-11-26 12:00:00	AAPL	Stock	3.3696	3.3796	3.3396	3.3593	44458764.0
2008-11-26 12:30:00	AAPL	Stock	3.3593	3.3861	3.35	3.3818	36168328.0
2008-11-26 13:00:00	AAPL	Stock	3.3825	3.3889	3.3429	3.3493	44812544.0
2008-11-26 13:30:00	AAPL	Stock	3.3504	3.3525	3.3239	3.3296	45810436.0
2008-11-26 14:00:00	AAPL	Stock	3.3296	3.3564	3.3161	3.3475	46583180.0
2008-11-26 14:30:00	AAPL	Stock	3.3479	3.3929	3.3471	3.3854	75326468.0
2008-11-26 15:00:00	AAPL	Stock	3.3854	3.4018	3.3729	3.3914	77427560.0
2008-11-26 15:30:00	AAPL	Stock	3.3914	3.3982	3.3421	3.3964	95950176.0
2008-11-26 16:00:00	AAPL	Stock	3.3982	3.3982	3.2968	3.3893	20890296.0
2008-11-26 16:30:00	AAPL	Stock	3.3893	3.3929	3.3495	3.3893	2131920.0
2008-11-26 17:00:00	AAPL	Stock	3.3911	3.4043	3.3896	3.4	834400.0
2008-11-26 17:30:00	AAPL	Stock	3.4	3.4029	3.3896	3.3911	331744.0
2008-11-26 18:00:00	AAPL	Stock	3.3925	3.3929	3.39	3.3914	70224.0
2008-11-26 18:30:00	AAPL	Stock	3.3907	3.3929	3.39	3.3911	239372.0
2008-11-26 19:00:00	AAPL	Stock	3.3929	3.3929	3.39	3.3929	120148.0
2008-11-26 19:30:00	AAPL	Stock	3.3929	3.3946	3.3896	3.3896	244244.0
2008-11-26 07:30:00	MSFT	Stock	19.73	19.73	19.7	19.7	1538.0
2008-11-26 08:00:00	MSFT	Stock	19.86	19.86	19.72	19.75	15935.0
2008-11-26 08:30:00	MSFT	Stock	19.72	19.76	19.67	19.75	14197.0
2008-11-26 09:00:00	MSFT	Stock	19.76	19.88	19.75	19.84	5760.0
2008-11-26 09:30:00	MSFT	Stock	19.75	20.39	19.73	20.35	5832135.0
2008-11-26 10:00:00	MSFT	Stock	20.36	20.45	20.24	20.31	5718957.0
2008-11-26 10:30:00	MSFT	Stock	20.31	20.49	20.1	20.42	4541185.0
2008-11-26 11:00:00	MSFT	Stock	20.43	20.63	20.32	20.48	4771504.0
2008-11-26 11:30:00	MSFT	Stock	20.48	20.59	20.34	20.36	4098477.0
2008-11-26 12:00:00	MSFT	Stock	20.36	20.39	20.2	20.27	3159177.0
2008-11-26 12:30:00	MSFT	Stock	20.26	20.42	20.22	20.32	2758688.0
2008-11-26 13:00:00	MSFT	Stock	20.33	20.45	20.3	20.33	2429899.0
2008-11-26 13:30:00	MSFT	Stock	20.33	20.39	20.25	20.27	2826045.0
2008-11-26 14:00:00	MSFT	Stock	20.27	20.32	20.17	20.27	2436522.0
2008-11-26 14:30:00	MSFT	Stock	20.27	20.4	20.24	20.34	5625134.0
2008-11-26 15:00:00	MSFT	Stock	20.34	20.45	20.3	20.38	5720818.0
2008-11-26 15:30:00	MSFT	Stock	20.39	20.49	20.13	20.49	9717285.0
2008-11-26 16:00:00	MSFT	Stock	20.49	20.494	20.31	20.491	15510555.0
2008-11-26 16:30:00	MSFT	Stock	19.99	20.491	19.99	20.49	3423408.0
2008-11-26 17:00:00	MSFT	Stock	20.37	20.37	20.37	20.37	400.0
2008-11-26 17:30:00	MSFT	Stock	20.4	20.4	20.37	20.37	2427.0
2008-11-26 18:00:00	MSFT	Stock	20.37	20.37	20.37	20.37	200.0
2008-11-26 18:30:00	MSFT	Stock	20.37	20.4	20.37	20.39	2150.0
2008-11-26 19:00:00	MSFT	Stock	20.39	20.39	20.39	20.39	350.0

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

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