PREVIEW / stock_30min / 2009-10-26

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-26.parquet
  size:    1.4 MB
  rows:    72,202
  symbols: 3,393

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-10-26 05:00:00	AAPL	Stock	7.3161	7.3161	7.3125	7.3125	5600.0
2009-10-26 07:00:00	AAPL	Stock	7.3089	7.3089	7.3054	7.3054	5600.0
2009-10-26 07:30:00	AAPL	Stock	7.31	7.31	7.31	7.31	2800.0
2009-10-26 08:00:00	AAPL	Stock	7.3	7.3036	7.2786	7.3021	589148.0
2009-10-26 08:30:00	AAPL	Stock	7.2968	7.2982	7.2811	7.2879	344148.0
2009-10-26 09:00:00	AAPL	Stock	7.2857	7.2939	7.2646	7.2675	961744.0
2009-10-26 09:30:00	AAPL	Stock	7.2675	7.375	7.1464	7.3675	79337636.0
2009-10-26 10:00:00	AAPL	Stock	7.3664	7.3839	7.3489	7.3496	39177376.0
2009-10-26 10:30:00	AAPL	Stock	7.3496	7.3607	7.3279	7.3493	35365680.0
2009-10-26 11:00:00	AAPL	Stock	7.3486	7.3579	7.3218	7.3354	35250824.0
2009-10-26 11:30:00	AAPL	Stock	7.335	7.3354	7.25	7.2511	54879132.0
2009-10-26 12:00:00	AAPL	Stock	7.25	7.2611	7.2143	7.2482	44562728.0
2009-10-26 12:30:00	AAPL	Stock	7.2482	7.2639	7.2196	7.25	23674476.0
2009-10-26 13:00:00	AAPL	Stock	7.25	7.2532	7.2089	7.2292	22167852.0
2009-10-26 13:30:00	AAPL	Stock	7.2279	7.2629	7.2232	7.2593	19949216.0
2009-10-26 14:00:00	AAPL	Stock	7.2593	7.2657	7.2246	7.245	20615924.0
2009-10-26 14:30:00	AAPL	Stock	7.2436	7.244	7.2232	7.2347	24081596.0
2009-10-26 15:00:00	AAPL	Stock	7.2329	7.2489	7.2171	7.2225	20365212.0
2009-10-26 15:30:00	AAPL	Stock	7.2229	7.2571	7.2143	7.2243	45502576.0
2009-10-26 16:00:00	AAPL	Stock	7.2318	7.2899	7.2232	7.2286	8910132.0
2009-10-26 16:30:00	AAPL	Stock	7.2286	7.2339	7.2286	7.2314	179200.0
2009-10-26 17:00:00	AAPL	Stock	7.2293	7.2357	7.2179	7.2179	117964.0
2009-10-26 17:30:00	AAPL	Stock	7.2211	7.2211	7.185	7.185	908040.0
2009-10-26 18:00:00	AAPL	Stock	7.1857	7.2314	7.1786	7.1875	758772.0
2009-10-26 18:30:00	AAPL	Stock	7.1839	7.1875	7.1786	7.1875	883064.0
2009-10-26 19:00:00	AAPL	Stock	7.1857	7.1964	7.1857	7.1893	320264.0
2009-10-26 19:30:00	AAPL	Stock	7.1861	7.1932	7.1839	7.1839	108640.0
2009-10-26 04:00:00	MSFT	Stock	28.27	28.28	28.27	28.28	400.0
2009-10-26 04:30:00	MSFT	Stock	28.27	28.32	28.27	28.32	700.0
2009-10-26 06:00:00	MSFT	Stock	28.27	28.27	28.25	28.25	5000.0
2009-10-26 07:00:00	MSFT	Stock	28.3	28.34	28.25	28.26	5700.0
2009-10-26 07:30:00	MSFT	Stock	28.25	28.3	28.22	28.22	66384.0
2009-10-26 08:00:00	MSFT	Stock	28.22	28.25	28.14	28.24	88376.0
2009-10-26 08:30:00	MSFT	Stock	28.24	28.27	28.18	28.25	118499.0
2009-10-26 09:00:00	MSFT	Stock	28.25	28.42	28.1	28.14	328131.0
2009-10-26 09:30:00	MSFT	Stock	28.13	28.74	28.11	28.68	17922785.0
2009-10-26 10:00:00	MSFT	Stock	28.68	28.95	28.68	28.87	15043437.0
2009-10-26 10:30:00	MSFT	Stock	28.88	28.97	28.83	28.97	8736627.0
2009-10-26 11:00:00	MSFT	Stock	28.97	29.02	28.75	28.9	12834718.0
2009-10-26 11:30:00	MSFT	Stock	28.9	28.91	28.61	28.62	11973147.0
2009-10-26 12:00:00	MSFT	Stock	28.62	28.88	28.61	28.865	7031335.0
2009-10-26 12:30:00	MSFT	Stock	28.86	28.92	28.77	28.87	4998780.0
2009-10-26 13:00:00	MSFT	Stock	28.87	28.88	28.67	28.711	4845716.0
2009-10-26 13:30:00	MSFT	Stock	28.72	28.87	28.71	28.78	4135511.0
2009-10-26 14:00:00	MSFT	Stock	28.79	28.8	28.64	28.69	5160893.0
2009-10-26 14:30:00	MSFT	Stock	28.68	28.69	28.51	28.632	7619416.0
2009-10-26 15:00:00	MSFT	Stock	28.63	28.7	28.56	28.609	5471675.0
2009-10-26 15:30:00	MSFT	Stock	28.61	28.82	28.6	28.69	11006234.0
2009-10-26 16:00:00	MSFT	Stock	28.7	28.835	28.614	28.74	3108964.0
2009-10-26 16:30:00	MSFT	Stock	28.72	28.77	28.667	28.75	77741.0

> showing 50 of 72,202 rows — these rows as CSV

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