PREVIEW / stock_30min / 2009-08-28

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-08-28.parquet
  size:    1.3 MB
  rows:    69,709
  symbols: 3,392

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-08-28 04:30:00	AAPL	Stock	6.1014	6.1014	6.1014	6.1014	14000.0
2009-08-28 05:00:00	AAPL	Stock	6.1018	6.1029	6.1018	6.1029	19600.0
2009-08-28 05:30:00	AAPL	Stock	6.1071	6.1143	6.1071	6.1143	11200.0
2009-08-28 06:00:00	AAPL	Stock	6.1075	6.1075	6.1075	6.1075	2800.0
2009-08-28 06:30:00	AAPL	Stock	6.1111	6.1111	6.1071	6.1071	14000.0
2009-08-28 07:00:00	AAPL	Stock	6.1246	6.1246	6.1143	6.1179	75040.0
2009-08-28 07:30:00	AAPL	Stock	6.1196	6.1232	6.1107	6.1207	483140.0
2009-08-28 08:00:00	AAPL	Stock	6.1179	6.1389	6.1179	6.1364	2146452.0
2009-08-28 08:30:00	AAPL	Stock	6.1364	6.1393	6.1307	6.1329	3043656.0
2009-08-28 09:00:00	AAPL	Stock	6.1325	6.1696	6.13	6.1493	5895036.0
2009-08-28 09:30:00	AAPL	Stock	6.1525	6.1604	6.0629	6.0782	118518176.0
2009-08-28 10:00:00	AAPL	Stock	6.0786	6.0993	6.0586	6.0634	43007272.0
2009-08-28 10:30:00	AAPL	Stock	6.0646	6.0975	6.0539	6.0846	28210476.0
2009-08-28 11:00:00	AAPL	Stock	6.0846	6.0918	6.075	6.0896	13907656.0
2009-08-28 11:30:00	AAPL	Stock	6.0895	6.0975	6.0621	6.0695	22862420.0
2009-08-28 12:00:00	AAPL	Stock	6.0686	6.0832	6.0311	6.0368	27935572.0
2009-08-28 12:30:00	AAPL	Stock	6.0368	6.045	6.0196	6.0207	20754412.0
2009-08-28 13:00:00	AAPL	Stock	6.0207	6.0539	6.0189	6.0489	21052976.0
2009-08-28 13:30:00	AAPL	Stock	6.0482	6.0607	6.0475	6.0564	13175372.0
2009-08-28 14:00:00	AAPL	Stock	6.0568	6.0629	6.0457	6.0604	15140804.0
2009-08-28 14:30:00	AAPL	Stock	6.0593	6.0768	6.0536	6.0754	20077204.0
2009-08-28 15:00:00	AAPL	Stock	6.0746	6.1054	6.0743	6.1004	29335712.0
2009-08-28 15:30:00	AAPL	Stock	6.1004	6.1032	6.0471	6.075	51288356.0
2009-08-28 16:00:00	AAPL	Stock	6.0693	6.0797	6.06	6.0732	13972252.0
2009-08-28 16:30:00	AAPL	Stock	6.0629	6.0732	6.0607	6.0607	148120.0
2009-08-28 17:00:00	AAPL	Stock	6.06	6.0664	6.0536	6.0625	330932.0
2009-08-28 17:30:00	AAPL	Stock	6.0607	6.0639	6.0571	6.0625	93296.0
2009-08-28 18:00:00	AAPL	Stock	6.0643	6.0732	6.0643	6.0704	180880.0
2009-08-28 18:30:00	AAPL	Stock	6.0704	6.0711	6.0661	6.0711	33600.0
2009-08-28 19:00:00	AAPL	Stock	6.0707	6.0746	6.0707	6.0746	79996.0
2009-08-28 19:30:00	AAPL	Stock	6.0754	6.0782	6.0714	6.0782	48272.0
2009-08-28 06:00:00	MSFT	Stock	24.79	24.79	24.79	24.79	1000.0
2009-08-28 07:30:00	MSFT	Stock	24.82	24.82	24.82	24.82	200.0
2009-08-28 08:00:00	MSFT	Stock	24.8	24.84	24.78	24.8	25398.0
2009-08-28 08:30:00	MSFT	Stock	24.81	24.83	24.8	24.8	14767.0
2009-08-28 09:00:00	MSFT	Stock	24.8	25.25	24.8	25.08	615970.0
2009-08-28 09:30:00	MSFT	Stock	25.08	25.49	25.04	25.3	11816516.0
2009-08-28 10:00:00	MSFT	Stock	25.3	25.31	24.95	24.99	6602467.0
2009-08-28 10:30:00	MSFT	Stock	25.0	25.07	24.89	25.06	5064044.0
2009-08-28 11:00:00	MSFT	Stock	25.06	25.08	25.0	25.008	2340774.0
2009-08-28 11:30:00	MSFT	Stock	25.002	25.03	24.93	24.94	2350160.0
2009-08-28 12:00:00	MSFT	Stock	24.938	24.96	24.71	24.72	4231686.0
2009-08-28 12:30:00	MSFT	Stock	24.719	24.77	24.65	24.65	2361540.0
2009-08-28 13:00:00	MSFT	Stock	24.641	24.83	24.64	24.76	2552427.0
2009-08-28 13:30:00	MSFT	Stock	24.762	24.81	24.75	24.79	1334313.0
2009-08-28 14:00:00	MSFT	Stock	24.794	24.86	24.75	24.83	1678146.0
2009-08-28 14:30:00	MSFT	Stock	24.825	24.83	24.74	24.817	2100112.0
2009-08-28 15:00:00	MSFT	Stock	24.82	24.85	24.76	24.79	2097786.0
2009-08-28 15:30:00	MSFT	Stock	24.78	24.8	24.61	24.68	7406395.0
2009-08-28 16:00:00	MSFT	Stock	24.69	24.968	24.68	24.68	2600510.0

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

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