PREVIEW / stock_30min / 2009-10-06

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-06.parquet
  size:    1.3 MB
  rows:    71,841
  symbols: 3,394

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-06 04:30:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	11200.0
2009-10-06 05:00:00	AAPL	Stock	6.6786	6.6911	6.6786	6.6911	9800.0
2009-10-06 06:00:00	AAPL	Stock	6.6875	6.6875	6.6875	6.6875	5600.0
2009-10-06 06:30:00	AAPL	Stock	6.6789	6.6789	6.6711	6.6786	38808.0
2009-10-06 07:00:00	AAPL	Stock	6.6904	6.6918	6.6643	6.6714	167804.0
2009-10-06 07:30:00	AAPL	Stock	6.6804	6.6871	6.675	6.6871	89040.0
2009-10-06 08:00:00	AAPL	Stock	6.6875	6.7107	6.6786	6.7107	2093700.0
2009-10-06 08:30:00	AAPL	Stock	6.7071	6.7111	6.7039	6.7107	1178072.0
2009-10-06 09:00:00	AAPL	Stock	6.7107	6.7154	6.7054	6.7054	2141524.0
2009-10-06 09:30:00	AAPL	Stock	6.7054	6.7375	6.6893	6.7211	75435472.0
2009-10-06 10:00:00	AAPL	Stock	6.7214	6.7668	6.7186	6.7479	67999988.0
2009-10-06 10:30:00	AAPL	Stock	6.7464	6.7611	6.7357	6.7521	32528748.0
2009-10-06 11:00:00	AAPL	Stock	6.7529	6.7782	6.7511	6.7661	39485096.0
2009-10-06 11:30:00	AAPL	Stock	6.7657	6.7714	6.7504	6.7575	25148620.0
2009-10-06 12:00:00	AAPL	Stock	6.7575	6.7764	6.7557	6.7664	25557308.0
2009-10-06 12:30:00	AAPL	Stock	6.7664	6.7768	6.7539	6.7611	20862744.0
2009-10-06 13:00:00	AAPL	Stock	6.7611	6.7743	6.7411	6.7704	34517868.0
2009-10-06 13:30:00	AAPL	Stock	6.77	6.77	6.7343	6.7407	26825484.0
2009-10-06 14:00:00	AAPL	Stock	6.7407	6.7436	6.7	6.7029	41949768.0
2009-10-06 14:30:00	AAPL	Stock	6.7032	6.7392	6.7	6.7321	28445844.0
2009-10-06 15:00:00	AAPL	Stock	6.7318	6.7593	6.7279	6.7571	32525696.0
2009-10-06 15:30:00	AAPL	Stock	6.7564	6.7857	6.7518	6.7857	76843676.0
2009-10-06 16:00:00	AAPL	Stock	6.7857	6.7929	6.7536	6.7857	14635208.0
2009-10-06 16:30:00	AAPL	Stock	6.7896	6.7896	6.7868	6.7893	162092.0
2009-10-06 17:00:00	AAPL	Stock	6.7871	6.7893	6.7825	6.7839	188496.0
2009-10-06 17:30:00	AAPL	Stock	6.7839	6.7875	6.7839	6.7875	74312.0
2009-10-06 18:00:00	AAPL	Stock	6.7893	6.7921	6.785	6.7893	544992.0
2009-10-06 18:30:00	AAPL	Stock	6.7875	6.7893	6.7868	6.7871	93044.0
2009-10-06 19:00:00	AAPL	Stock	6.7871	6.7882	6.7839	6.7854	225316.0
2009-10-06 19:30:00	AAPL	Stock	6.7854	6.7857	6.7768	6.7821	316484.0
2009-10-06 07:00:00	MSFT	Stock	24.88	24.88	24.86	24.86	1900.0
2009-10-06 07:30:00	MSFT	Stock	24.85	24.87	24.85	24.87	1801.0
2009-10-06 08:00:00	MSFT	Stock	24.87	24.87	24.74	24.8	16029.0
2009-10-06 08:30:00	MSFT	Stock	24.8	24.8	24.75	24.75	7615.0
2009-10-06 09:00:00	MSFT	Stock	24.78	24.79	24.65	24.68	44911.0
2009-10-06 09:30:00	MSFT	Stock	24.68	24.92	24.655	24.91	6426576.0
2009-10-06 10:00:00	MSFT	Stock	24.91	25.08	24.88	24.97	5066681.0
2009-10-06 10:30:00	MSFT	Stock	24.97	25.08	24.97	25.03	2838508.0
2009-10-06 11:00:00	MSFT	Stock	25.031	25.21	25.03	25.17	3488603.0
2009-10-06 11:30:00	MSFT	Stock	25.178	25.2	25.12	25.13	2881285.0
2009-10-06 12:00:00	MSFT	Stock	25.12	25.15	25.03	25.06	2327099.0
2009-10-06 12:30:00	MSFT	Stock	25.062	25.18	25.06	25.09	1986820.0
2009-10-06 13:00:00	MSFT	Stock	25.09	25.15	25.05	25.14	2250714.0
2009-10-06 13:30:00	MSFT	Stock	25.13	25.16	25.04	25.072	2274614.0
2009-10-06 14:00:00	MSFT	Stock	25.08	25.11	24.92	24.94	3685019.0
2009-10-06 14:30:00	MSFT	Stock	24.94	25.04	24.92	24.99	2662722.0
2009-10-06 15:00:00	MSFT	Stock	24.99	25.16	24.97	25.14	2910503.0
2009-10-06 15:30:00	MSFT	Stock	25.14	25.17	25.07	25.12	5673980.0
2009-10-06 16:00:00	MSFT	Stock	25.12	25.17	25.033	25.14	2384574.0
2009-10-06 16:30:00	MSFT	Stock	25.165	25.165	25.11	25.11	1546.0

> showing 50 of 71,841 rows — these rows as CSV

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