PREVIEW / stock_30min / 2006-11-20

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-11-20.parquet
  size:    977 KB
  rows:    52,277
  symbols: 2,446

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
2006-11-20 04:00:00	AAPL	Stock	3.0575	3.0575	3.0575	3.0575	14000.0
2006-11-20 07:00:00	AAPL	Stock	3.0454	3.0521	3.0404	3.0521	39200.0
2006-11-20 07:30:00	AAPL	Stock	3.0521	3.0529	3.0521	3.0529	10276.0
2006-11-20 08:00:00	AAPL	Stock	3.0525	3.0643	3.0525	3.0625	247436.0
2006-11-20 08:30:00	AAPL	Stock	3.0625	3.0657	3.0593	3.0636	286860.0
2006-11-20 09:00:00	AAPL	Stock	3.0607	3.0643	3.0486	3.0511	967652.0
2006-11-20 09:30:00	AAPL	Stock	3.05	3.0664	3.0429	3.0529	64721132.0
2006-11-20 10:00:00	AAPL	Stock	3.0529	3.0625	3.0464	3.0546	36146600.0
2006-11-20 10:30:00	AAPL	Stock	3.0546	3.1071	3.0546	3.0914	68903548.0
2006-11-20 11:00:00	AAPL	Stock	3.0911	3.0961	3.0789	3.0843	40791016.0
2006-11-20 11:30:00	AAPL	Stock	3.0843	3.0996	3.0811	3.0996	30126460.0
2006-11-20 12:00:00	AAPL	Stock	3.0996	3.1071	3.0929	3.0957	42851676.0
2006-11-20 12:30:00	AAPL	Stock	3.0957	3.1	3.0914	3.0975	24340064.0
2006-11-20 13:00:00	AAPL	Stock	3.0975	3.1025	3.0929	3.0957	33986456.0
2006-11-20 13:30:00	AAPL	Stock	3.0961	3.1018	3.0911	3.0961	18964428.0
2006-11-20 14:00:00	AAPL	Stock	3.0964	3.105	3.0725	3.0807	51127860.0
2006-11-20 14:30:00	AAPL	Stock	3.0814	3.0882	3.0714	3.086	43570408.0
2006-11-20 15:00:00	AAPL	Stock	3.0861	3.0889	3.0761	3.0796	31713752.0
2006-11-20 15:30:00	AAPL	Stock	3.0793	3.0918	3.0782	3.09	69032432.0
2006-11-20 16:00:00	AAPL	Stock	3.0889	3.0936	3.0821	3.09	1626296.0
2006-11-20 16:30:00	AAPL	Stock	3.0896	3.0896	3.0889	3.0893	1873928.0
2006-11-20 17:00:00	AAPL	Stock	3.0911	3.0921	3.09	3.0911	114800.0
2006-11-20 17:30:00	AAPL	Stock	3.0886	3.0886	3.0871	3.0875	3197208.0
2006-11-20 18:00:00	AAPL	Stock	3.0911	3.0911	3.0911	3.0911	16548.0
2006-11-20 19:00:00	AAPL	Stock	3.0907	3.0907	3.0904	3.0907	56000.0
2006-11-20 19:30:00	AAPL	Stock	3.0893	3.0925	3.0893	3.0896	173460.0
2006-11-20 04:30:00	MSFT	Stock	29.5	29.5	29.5	29.5	1000.0
2006-11-20 06:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	2000.0
2006-11-20 07:00:00	MSFT	Stock	29.6	29.6	29.6	29.6	200.0
2006-11-20 07:30:00	MSFT	Stock	29.57	29.6	29.5	29.5	26350.0
2006-11-20 08:00:00	MSFT	Stock	29.58	29.6	29.51	29.56	33000.0
2006-11-20 08:30:00	MSFT	Stock	29.56	29.6	29.4	29.59	514621.0
2006-11-20 09:00:00	MSFT	Stock	29.59	29.6	29.4	29.51	588466.0
2006-11-20 09:30:00	MSFT	Stock	29.52	29.72	29.5	29.67	10990637.0
2006-11-20 10:00:00	MSFT	Stock	29.66	29.75	29.65	29.73	6421307.0
2006-11-20 10:30:00	MSFT	Stock	29.73	29.83	29.71	29.818	6494377.0
2006-11-20 11:00:00	MSFT	Stock	29.82	29.9	29.79	29.86	5758862.0
2006-11-20 11:30:00	MSFT	Stock	29.87	29.91	29.84	29.9	3249396.0
2006-11-20 12:00:00	MSFT	Stock	29.9	29.93	29.85	29.91	3910930.0
2006-11-20 12:30:00	MSFT	Stock	29.9	29.97	29.9	29.96	7208676.0
2006-11-20 13:00:00	MSFT	Stock	29.96	29.96	29.86	29.91	2962413.0
2006-11-20 13:30:00	MSFT	Stock	29.92	30.0	29.91	29.98	8588832.0
2006-11-20 14:00:00	MSFT	Stock	29.98	30.0	29.798	29.82	7349463.0
2006-11-20 14:30:00	MSFT	Stock	29.83	29.94	29.81	29.92	3593694.0
2006-11-20 15:00:00	MSFT	Stock	29.92	29.94	29.87	29.94	3964361.0
2006-11-20 15:30:00	MSFT	Stock	29.94	29.96	29.83	29.9	9820225.0
2006-11-20 16:00:00	MSFT	Stock	29.91	29.97	29.83	29.97	186996.0
2006-11-20 16:30:00	MSFT	Stock	29.96	29.97	29.95	29.97	1593090.0
2006-11-20 17:00:00	MSFT	Stock	29.89	29.97	29.89	29.97	722290.0
2006-11-20 17:30:00	MSFT	Stock	29.97	29.97	29.92	29.92	600.0

> showing 50 of 52,277 rows — these rows as CSV

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