PREVIEW / etf_30min / 2009-06-26

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-26.parquet
  size:    207 KB
  rows:    6,910

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-06-26 04:00:00	SPY	ETF	92.0	92.0	91.85	91.9	5400.0
2009-06-26 04:30:00	SPY	ETF	92.02	92.02	92.02	92.02	350.0
2009-06-26 05:00:00	SPY	ETF	92.07	92.07	91.97	91.97	1050.0
2009-06-26 05:30:00	SPY	ETF	91.92	91.92	91.84	91.84	640.0
2009-06-26 06:00:00	SPY	ETF	91.8	91.85	91.7	91.7	89100.0
2009-06-26 06:30:00	SPY	ETF	91.7	91.85	91.7	91.85	113100.0
2009-06-26 07:00:00	SPY	ETF	91.85	91.94	91.82	91.89	23241.0
2009-06-26 07:30:00	SPY	ETF	91.87	91.98	91.8	91.93	128524.0
2009-06-26 08:00:00	SPY	ETF	91.93	92.09	91.67	92.07	461087.0
2009-06-26 08:30:00	SPY	ETF	92.08	92.29	91.58	91.68	2569449.0
2009-06-26 09:00:00	SPY	ETF	91.68	91.775	91.58	91.76	1410445.0
2009-06-26 09:30:00	SPY	ETF	91.77	92.04	91.48	91.55	27260849.0
2009-06-26 10:00:00	SPY	ETF	91.54	91.86	91.4	91.73	15714051.0
2009-06-26 10:30:00	SPY	ETF	91.74	91.82	91.38	91.515	13058411.0
2009-06-26 11:00:00	SPY	ETF	91.51	91.55	91.27	91.45	9899336.0
2009-06-26 11:30:00	SPY	ETF	91.45	91.62	91.34	91.58	8588476.0
2009-06-26 12:00:00	SPY	ETF	91.59	91.75	91.52	91.57	8247547.0
2009-06-26 12:30:00	SPY	ETF	91.5695	91.87	91.495	91.75	7184027.0
2009-06-26 13:00:00	SPY	ETF	91.75	91.79	91.62	91.7	9754275.0
2009-06-26 13:30:00	SPY	ETF	91.69	91.77	91.55	91.65	5551591.0
2009-06-26 14:00:00	SPY	ETF	91.65	91.7	91.52	91.63	4905006.0
2009-06-26 14:30:00	SPY	ETF	91.645	91.93	91.58	91.9125	6415312.0
2009-06-26 15:00:00	SPY	ETF	91.91	92.02	91.79	91.889	8688335.0
2009-06-26 15:30:00	SPY	ETF	91.88	92.24	91.77	91.78	20277794.0
2009-06-26 16:00:00	SPY	ETF	91.79	92.13	91.688	91.83	8534795.0
2009-06-26 16:30:00	SPY	ETF	91.83	91.9	91.77	91.9	251607.0
2009-06-26 17:00:00	SPY	ETF	91.85	91.91	91.8	91.88	47303.0
2009-06-26 17:30:00	SPY	ETF	91.88	91.91	91.84	91.88	25350.0
2009-06-26 18:00:00	SPY	ETF	91.86	91.91	91.86	91.91	21791.0
2009-06-26 18:30:00	SPY	ETF	91.9	91.9	91.84	91.87	11437.0
2009-06-26 19:00:00	SPY	ETF	91.86	91.87	91.84	91.86	8802.0
2009-06-26 19:30:00	SPY	ETF	91.86	91.87	91.82	91.85	10175.0
2009-06-26 06:00:00	QQQ	ETF	36.18	36.18	36.17	36.17	1828.0
2009-06-26 06:30:00	QQQ	ETF	36.18	36.18	36.15	36.15	450.0
2009-06-26 07:30:00	QQQ	ETF	36.2	36.23	36.15	36.21	70936.0
2009-06-26 08:00:00	QQQ	ETF	36.22	36.25	36.16	36.24	142606.0
2009-06-26 08:30:00	QQQ	ETF	36.25	36.32	36.07	36.1	456146.0
2009-06-26 09:00:00	QQQ	ETF	36.1	36.13	36.07	36.13	646612.0
2009-06-26 09:30:00	QQQ	ETF	36.13	36.41	36.05	36.22	18899988.0
2009-06-26 10:00:00	QQQ	ETF	36.22	36.38	36.16	36.3	9288248.0
2009-06-26 10:30:00	QQQ	ETF	36.3	36.34	36.19	36.24	6270804.0
2009-06-26 11:00:00	QQQ	ETF	36.249	36.28	36.17	36.25	3774358.0
2009-06-26 11:30:00	QQQ	ETF	36.25	36.34	36.21	36.33	2974399.0
2009-06-26 12:00:00	QQQ	ETF	36.33	36.4	36.32	36.36	4163738.0
2009-06-26 12:30:00	QQQ	ETF	36.36	36.44	36.3	36.389	3910559.0
2009-06-26 13:00:00	QQQ	ETF	36.39	36.42	36.34	36.39	3326682.0
2009-06-26 13:30:00	QQQ	ETF	36.39	36.43	36.33	36.37	3481784.0
2009-06-26 14:00:00	QQQ	ETF	36.37	36.4	36.33	36.36	4431116.0
2009-06-26 14:30:00	QQQ	ETF	36.37	36.45	36.34	36.44	2674955.0
2009-06-26 15:00:00	QQQ	ETF	36.4399	36.48	36.36	36.4	6649673.0

> showing 50 of 6,910 rows — these rows as CSV

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