PREVIEW / etf_30min / 2010-02-25

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-25.parquet
  size:    252 KB
  rows:    8,296

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-02-25 04:00:00	SPY	ETF	110.2	110.3	110.2	110.23	3800.0
2010-02-25 04:30:00	SPY	ETF	110.45	110.55	110.45	110.55	1100.0
2010-02-25 05:30:00	SPY	ETF	110.45	110.45	110.35	110.35	22300.0
2010-02-25 06:00:00	SPY	ETF	110.36	110.37	110.28	110.34	24300.0
2010-02-25 06:30:00	SPY	ETF	110.32	110.43	110.23	110.35	44300.0
2010-02-25 07:00:00	SPY	ETF	110.34	110.35	110.1	110.1	266928.0
2010-02-25 07:30:00	SPY	ETF	110.11	110.2	110.0	110.2	495989.0
2010-02-25 08:00:00	SPY	ETF	110.16	110.34	109.65	110.07	1174995.0
2010-02-25 08:30:00	SPY	ETF	110.08	110.08	109.6	109.7	5597793.0
2010-02-25 09:00:00	SPY	ETF	109.72	109.73	109.2	109.24	5248514.0
2010-02-25 09:30:00	SPY	ETF	109.24	109.38	108.94	109.2617	28381747.0
2010-02-25 10:00:00	SPY	ETF	109.26	109.46	109.06	109.44	21575966.0
2010-02-25 10:30:00	SPY	ETF	109.45	109.5	109.26	109.33	14189314.0
2010-02-25 11:00:00	SPY	ETF	109.3383	109.43	109.15	109.22	12094618.0
2010-02-25 11:30:00	SPY	ETF	109.22	109.25	109.05	109.14	12066284.0
2010-02-25 12:00:00	SPY	ETF	109.14	109.39	109.09	109.3	9818272.0
2010-02-25 12:30:00	SPY	ETF	109.3	109.55	109.29	109.41	12129035.0
2010-02-25 13:00:00	SPY	ETF	109.41	109.47	109.31	109.34	6570045.0
2010-02-25 13:30:00	SPY	ETF	109.34	110.1	109.34	110.09	18696582.0
2010-02-25 14:00:00	SPY	ETF	110.09	110.32	109.98	110.07	25746757.0
2010-02-25 14:30:00	SPY	ETF	110.07	110.27	110.03	110.2	13502177.0
2010-02-25 15:00:00	SPY	ETF	110.19	110.58	110.11	110.46	21871338.0
2010-02-25 15:30:00	SPY	ETF	110.46	110.75	110.37	110.71	35097332.0
2010-02-25 16:00:00	SPY	ETF	110.71	110.8879	109.2	110.66	10981890.0
2010-02-25 16:30:00	SPY	ETF	110.66	111.063	109.29	110.63	2063941.0
2010-02-25 17:00:00	SPY	ETF	110.62	110.74	110.58	110.61	198955.0
2010-02-25 17:30:00	SPY	ETF	110.63	110.67	110.61	110.66	52925.0
2010-02-25 18:00:00	SPY	ETF	110.66	110.69	110.62	110.62	88874.0
2010-02-25 18:30:00	SPY	ETF	110.63	110.81	110.63	110.8	62962.0
2010-02-25 19:00:00	SPY	ETF	110.8	110.94	110.77	110.88	175815.0
2010-02-25 19:30:00	SPY	ETF	110.86	111.0	110.81	110.98	283804.0
2010-02-25 04:00:00	QQQ	ETF	44.35	44.37	44.35	44.37	1100.0
2010-02-25 04:30:00	QQQ	ETF	44.39	44.53	44.39	44.53	7800.0
2010-02-25 05:30:00	QQQ	ETF	44.5	44.5	44.47	44.47	1300.0
2010-02-25 06:00:00	QQQ	ETF	44.42	44.42	44.42	44.42	3333.0
2010-02-25 06:30:00	QQQ	ETF	44.49	44.49	44.41	44.46	17300.0
2010-02-25 07:00:00	QQQ	ETF	44.44	44.44	44.4	44.4	4404.0
2010-02-25 07:30:00	QQQ	ETF	44.39	44.4	44.35	44.4	69898.0
2010-02-25 08:00:00	QQQ	ETF	44.41	44.44	44.4	44.41	139828.0
2010-02-25 08:30:00	QQQ	ETF	44.4	44.4	44.2	44.23	1542218.0
2010-02-25 09:00:00	QQQ	ETF	44.23	44.25	44.09	44.11	1636998.0
2010-02-25 09:30:00	QQQ	ETF	44.11	44.14	43.83	43.94	13619534.0
2010-02-25 10:00:00	QQQ	ETF	43.94	44.03	43.86	44.0	8280864.0
2010-02-25 10:30:00	QQQ	ETF	43.99	44.02	43.91	43.9499	5494865.0
2010-02-25 11:00:00	QQQ	ETF	43.94	44.04	43.91	43.96	5391924.0
2010-02-25 11:30:00	QQQ	ETF	43.96	43.985	43.87	43.91	4161853.0
2010-02-25 12:00:00	QQQ	ETF	43.9	44.0	43.88	43.96	2931281.0
2010-02-25 12:30:00	QQQ	ETF	43.96	44.04	43.9462	44.005	3537225.0
2010-02-25 13:00:00	QQQ	ETF	44.01	44.04	43.97	44.0	3020582.0
2010-02-25 13:30:00	QQQ	ETF	44.0	44.38	44.0	44.38	7652819.0

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

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