PREVIEW / stock_30min / 2009-09-09

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-09-09.parquet
  size:    1.3 MB
  rows:    70,539
  symbols: 3,366

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-09-09 05:00:00	AAPL	Stock	6.1946	6.1946	6.1946	6.1946	2800.0
2009-09-09 07:00:00	AAPL	Stock	6.1939	6.1943	6.1786	6.1821	46480.0
2009-09-09 07:30:00	AAPL	Stock	6.175	6.175	6.1714	6.1718	14840.0
2009-09-09 08:00:00	AAPL	Stock	6.175	6.1775	6.155	6.175	570500.0
2009-09-09 08:30:00	AAPL	Stock	6.1764	6.1771	6.1664	6.1693	289352.0
2009-09-09 09:00:00	AAPL	Stock	6.1689	6.1732	6.1643	6.17	393568.0
2009-09-09 09:30:00	AAPL	Stock	6.1721	6.1829	6.1254	6.1657	56640276.0
2009-09-09 10:00:00	AAPL	Stock	6.1657	6.1839	6.1579	6.1646	29089564.0
2009-09-09 10:30:00	AAPL	Stock	6.1646	6.1671	6.1511	6.1586	16840880.0
2009-09-09 11:00:00	AAPL	Stock	6.1589	6.1764	6.1543	6.1725	22548960.0
2009-09-09 11:30:00	AAPL	Stock	6.1718	6.1964	6.1711	6.1914	31688748.0
2009-09-09 12:00:00	AAPL	Stock	6.1918	6.2139	6.1871	6.2136	36145956.0
2009-09-09 12:30:00	AAPL	Stock	6.2136	6.2311	6.1993	6.2257	52288964.0
2009-09-09 13:00:00	AAPL	Stock	6.2257	6.2275	6.1804	6.1954	102390092.0
2009-09-09 13:30:00	AAPL	Stock	6.1957	6.2054	6.1614	6.1746	61369784.0
2009-09-09 14:00:00	AAPL	Stock	6.176	6.2232	6.0607	6.09	171443692.0
2009-09-09 14:30:00	AAPL	Stock	6.09	6.1143	6.075	6.0925	79663752.0
2009-09-09 15:00:00	AAPL	Stock	6.0932	6.1236	6.0923	6.1111	56584920.0
2009-09-09 15:30:00	AAPL	Stock	6.1121	6.135	6.0993	6.1086	80575180.0
2009-09-09 16:00:00	AAPL	Stock	6.1121	6.1214	6.1067	6.1136	9762816.0
2009-09-09 16:30:00	AAPL	Stock	6.1139	6.1214	6.11	6.1107	605024.0
2009-09-09 17:00:00	AAPL	Stock	6.1161	6.1179	6.1071	6.1071	406084.0
2009-09-09 17:30:00	AAPL	Stock	6.1046	6.1121	6.1007	6.1061	194712.0
2009-09-09 18:00:00	AAPL	Stock	6.1121	6.1121	6.1071	6.1089	280616.0
2009-09-09 18:30:00	AAPL	Stock	6.1089	6.1107	6.1054	6.1071	27776.0
2009-09-09 19:00:00	AAPL	Stock	6.11	6.11	6.1039	6.1071	60144.0
2009-09-09 19:30:00	AAPL	Stock	6.1046	6.1082	6.1032	6.1032	111720.0
2009-09-09 20:00:00	AAPL	Stock	6.1939	6.1939	6.1939	6.1939	15232.0
2009-09-09 07:00:00	MSFT	Stock	24.9	24.9	24.89	24.9	1200.0
2009-09-09 07:30:00	MSFT	Stock	24.83	24.83	24.77	24.77	300.0
2009-09-09 08:00:00	MSFT	Stock	24.8	24.82	24.77	24.79	1400.0
2009-09-09 08:30:00	MSFT	Stock	24.8	24.82	24.8	24.82	1050.0
2009-09-09 09:00:00	MSFT	Stock	24.8	24.8	24.7	24.74	10102.0
2009-09-09 09:30:00	MSFT	Stock	24.74	24.92	24.71	24.81	4859318.0
2009-09-09 10:00:00	MSFT	Stock	24.81	24.88	24.78	24.79	3130966.0
2009-09-09 10:30:00	MSFT	Stock	24.8	24.85	24.77	24.8	2537981.0
2009-09-09 11:00:00	MSFT	Stock	24.8	24.88	24.79	24.875	5117483.0
2009-09-09 11:30:00	MSFT	Stock	24.875	24.95	24.865	24.941	3973416.0
2009-09-09 12:00:00	MSFT	Stock	24.95	24.95	24.82	24.861	2737452.0
2009-09-09 12:30:00	MSFT	Stock	24.862	24.91	24.86	24.89	2513723.0
2009-09-09 13:00:00	MSFT	Stock	24.892	24.91	24.82	24.86	3561092.0
2009-09-09 13:30:00	MSFT	Stock	24.862	24.862	24.81	24.84	2634354.0
2009-09-09 14:00:00	MSFT	Stock	24.84	24.86	24.7	24.73	4014753.0
2009-09-09 14:30:00	MSFT	Stock	24.72	24.76	24.665	24.72	2568760.0
2009-09-09 15:00:00	MSFT	Stock	24.72	24.83	24.7	24.8	3320565.0
2009-09-09 15:30:00	MSFT	Stock	24.79	24.84	24.75	24.79	6369544.0
2009-09-09 16:00:00	MSFT	Stock	24.79	24.83	24.768	24.77	1933790.0
2009-09-09 16:30:00	MSFT	Stock	24.78	24.8	24.78	24.78	3177.0
2009-09-09 17:00:00	MSFT	Stock	24.8	24.8	24.625	24.625	61600.0
2009-09-09 17:30:00	MSFT	Stock	24.78	24.78	24.75	24.75	2029.0

> showing 50 of 70,539 rows — these rows as CSV

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