PREVIEW / etf_30min / 2010-06-02

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-02.parquet
  size:    256 KB
  rows:    8,405

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
2010-06-02 04:00:00	SPY	ETF	107.86	107.95	107.55	107.58	10300.0
2010-06-02 04:30:00	SPY	ETF	107.62	107.64	107.44	107.63	26900.0
2010-06-02 05:00:00	SPY	ETF	107.66	107.78	107.66	107.78	700.0
2010-06-02 05:30:00	SPY	ETF	107.83	108.24	107.83	108.15	6300.0
2010-06-02 06:00:00	SPY	ETF	108.1	108.18	107.96	107.98	6300.0
2010-06-02 06:30:00	SPY	ETF	107.98	108.11	107.75	108.0	125850.0
2010-06-02 07:00:00	SPY	ETF	108.15	108.19	107.9	108.13	764235.0
2010-06-02 07:30:00	SPY	ETF	108.11	108.15	107.93	108.08	217250.0
2010-06-02 08:00:00	SPY	ETF	108.1	108.1	107.84	107.9	1178552.0
2010-06-02 08:30:00	SPY	ETF	107.9	107.95	107.7	107.83	1293870.0
2010-06-02 09:00:00	SPY	ETF	107.82	108.09	107.75	108.08	1361665.0
2010-06-02 09:30:00	SPY	ETF	108.08	108.28	107.61	107.94	27249446.0
2010-06-02 10:00:00	SPY	ETF	107.94	108.52	107.8	108.25	24260038.0
2010-06-02 10:30:00	SPY	ETF	108.25	108.57	108.0	108.29	14908952.0
2010-06-02 11:00:00	SPY	ETF	108.3	108.7625	108.29	108.6	12485950.0
2010-06-02 11:30:00	SPY	ETF	108.6	109.1	108.5	108.94	10948371.0
2010-06-02 12:00:00	SPY	ETF	108.94	109.13	108.83	108.91	7322167.0
2010-06-02 12:30:00	SPY	ETF	108.91	109.14	108.87	109.07	5797999.0
2010-06-02 13:00:00	SPY	ETF	109.07	109.25	108.9	108.96	7269300.0
2010-06-02 13:30:00	SPY	ETF	108.96	109.08	108.75	108.82	10794779.0
2010-06-02 14:00:00	SPY	ETF	108.82	108.87	108.5217	108.8	11131946.0
2010-06-02 14:30:00	SPY	ETF	108.79	109.58	108.63	109.46	21233140.0
2010-06-02 15:00:00	SPY	ETF	109.46	109.89	109.45	109.87	20751883.0
2010-06-02 15:30:00	SPY	ETF	109.87	110.34	109.59	110.31	36478442.0
2010-06-02 16:00:00	SPY	ETF	110.31	110.33	107.9954	110.2	7128311.0
2010-06-02 16:30:00	SPY	ETF	110.23	110.33	107.5093	110.3	10722907.0
2010-06-02 17:00:00	SPY	ETF	110.26	110.47	110.26	110.45	442821.0
2010-06-02 17:30:00	SPY	ETF	110.44	110.5	110.39	110.45	70576.0
2010-06-02 18:00:00	SPY	ETF	110.43	110.43	110.2	110.21	129230.0
2010-06-02 18:30:00	SPY	ETF	110.2	110.26	110.15	110.18	49716.0
2010-06-02 19:00:00	SPY	ETF	110.19	110.24	110.15	110.24	11734.0
2010-06-02 19:30:00	SPY	ETF	110.24	110.34	110.18	110.25	42513.0
2010-06-02 20:00:00	SPY	ETF	110.29	110.29	110.29	110.29	100.0
2010-06-02 04:00:00	QQQ	ETF	45.32	45.32	45.32	45.32	600.0
2010-06-02 05:00:00	QQQ	ETF	45.26	45.32	45.26	45.32	1100.0
2010-06-02 05:30:00	QQQ	ETF	45.44	45.44	45.44	45.44	100.0
2010-06-02 06:00:00	QQQ	ETF	45.38	45.45	45.37	45.37	1600.0
2010-06-02 06:30:00	QQQ	ETF	45.35	45.4	45.35	45.4	400.0
2010-06-02 07:00:00	QQQ	ETF	45.47	45.51	45.42	45.51	627867.0
2010-06-02 07:30:00	QQQ	ETF	45.48	45.5	45.43	45.49	103125.0
2010-06-02 08:00:00	QQQ	ETF	45.47	45.48	45.39	45.41	676515.0
2010-06-02 08:30:00	QQQ	ETF	45.41	45.42	45.31	45.34	248046.0
2010-06-02 09:00:00	QQQ	ETF	45.35	45.45	45.32	45.44	641409.0
2010-06-02 09:30:00	QQQ	ETF	45.45	45.51	45.13	45.31	17702105.0
2010-06-02 10:00:00	QQQ	ETF	45.31	45.65	45.27	45.53	11915023.0
2010-06-02 10:30:00	QQQ	ETF	45.53	45.64	45.44	45.54	4887604.0
2010-06-02 11:00:00	QQQ	ETF	45.54	45.715	45.535	45.66	4445779.0
2010-06-02 11:30:00	QQQ	ETF	45.665	45.82	45.62	45.77	3851734.0
2010-06-02 12:00:00	QQQ	ETF	45.77	45.86	45.75	45.7617	3202545.0
2010-06-02 12:30:00	QQQ	ETF	45.76	45.91	45.76	45.9	2937024.0

> showing 50 of 8,405 rows — these rows as CSV

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