PREVIEW / etf_30min / 2009-07-21

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-21.parquet
  size:    232 KB
  rows:    7,591

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-07-21 04:00:00	SPY	ETF	95.21	95.3	95.2	95.27	1000.0
2009-07-21 04:30:00	SPY	ETF	95.3	95.35	95.25	95.25	750.0
2009-07-21 05:00:00	SPY	ETF	95.21	95.35	95.2	95.26	4000.0
2009-07-21 05:30:00	SPY	ETF	95.26	95.31	95.26	95.31	200.0
2009-07-21 06:00:00	SPY	ETF	95.37	95.5	95.37	95.43	1905.0
2009-07-21 06:30:00	SPY	ETF	95.45	95.45	95.4	95.42	4200.0
2009-07-21 07:00:00	SPY	ETF	95.37	95.47	95.34	95.39	15800.0
2009-07-21 07:30:00	SPY	ETF	95.39	95.82	95.39	95.73	631352.0
2009-07-21 08:00:00	SPY	ETF	95.73	95.8	95.0	95.79	1079721.0
2009-07-21 08:30:00	SPY	ETF	95.79	95.82	94.9	95.77	1081837.0
2009-07-21 09:00:00	SPY	ETF	95.77	96.05	95.75	95.87	2170158.0
2009-07-21 09:30:00	SPY	ETF	95.87	95.9	95.18	95.42	28666395.0
2009-07-21 10:00:00	SPY	ETF	95.43	95.55	94.95	95.32	19241280.0
2009-07-21 10:30:00	SPY	ETF	95.32	95.61	95.22	95.41	13260232.0
2009-07-21 11:00:00	SPY	ETF	95.41	95.46	95.14	95.245	8667290.0
2009-07-21 11:30:00	SPY	ETF	95.24	95.4682	94.6	94.65	14834010.0
2009-07-21 12:00:00	SPY	ETF	94.64	94.84	94.61	94.79	6603965.0
2009-07-21 12:30:00	SPY	ETF	94.79	94.85	94.56	94.65	9161132.0
2009-07-21 13:00:00	SPY	ETF	94.65	94.75	94.42	94.74	10318299.0
2009-07-21 13:30:00	SPY	ETF	94.73	94.83	94.64	94.71	8825943.0
2009-07-21 14:00:00	SPY	ETF	94.7199	94.98	94.7	94.85	9646554.0
2009-07-21 14:30:00	SPY	ETF	94.8417	95.43	94.7	95.12	21045518.0
2009-07-21 15:00:00	SPY	ETF	95.13	95.28	95.03	95.2204	15807796.0
2009-07-21 15:30:00	SPY	ETF	95.22	95.58	95.12	95.58	27564206.0
2009-07-21 16:00:00	SPY	ETF	95.57	95.85	95.4795	95.63	4324381.0
2009-07-21 16:30:00	SPY	ETF	95.72	96.0	95.38	95.99	5594224.0
2009-07-21 17:00:00	SPY	ETF	95.97	96.01	95.82	95.88	969693.0
2009-07-21 17:30:00	SPY	ETF	95.88	95.88	95.82	95.86	3064387.0
2009-07-21 18:00:00	SPY	ETF	95.84	95.93	95.57	95.8	241554.0
2009-07-21 18:30:00	SPY	ETF	95.8	95.85	95.8	95.83	29265.0
2009-07-21 19:00:00	SPY	ETF	95.85	95.86	95.82	95.83	13310.0
2009-07-21 19:30:00	SPY	ETF	95.84	95.87	95.62	95.62	72033.0
2009-07-21 20:00:00	SPY	ETF	95.64	95.64	95.64	95.64	100.0
2009-07-21 04:30:00	QQQ	ETF	37.89	37.89	37.89	37.89	200.0
2009-07-21 05:00:00	QQQ	ETF	37.89	37.89	37.88	37.88	7000.0
2009-07-21 06:30:00	QQQ	ETF	37.93	37.93	37.93	37.93	200.0
2009-07-21 07:00:00	QQQ	ETF	37.95	37.95	37.93	37.95	6300.0
2009-07-21 07:30:00	QQQ	ETF	37.94	38.09	37.94	38.03	90217.0
2009-07-21 08:00:00	QQQ	ETF	38.04	38.04	37.99	38.04	214965.0
2009-07-21 08:30:00	QQQ	ETF	38.04	38.06	37.72	38.01	521274.0
2009-07-21 09:00:00	QQQ	ETF	38.0	38.1	38.0	38.06	913805.0
2009-07-21 09:30:00	QQQ	ETF	38.07	38.08	37.77	37.87	17424008.0
2009-07-21 10:00:00	QQQ	ETF	37.87	37.92	37.69	37.89	9159068.0
2009-07-21 10:30:00	QQQ	ETF	37.9	38.02	37.86	37.95	8768714.0
2009-07-21 11:00:00	QQQ	ETF	37.96	37.99	37.87	37.92	4433089.0
2009-07-21 11:30:00	QQQ	ETF	37.92	37.928	37.7	37.73	7494755.0
2009-07-21 12:00:00	QQQ	ETF	37.73	37.81	37.72	37.7774	5276449.0
2009-07-21 12:30:00	QQQ	ETF	37.78	37.81	37.68	37.7301	4997592.0
2009-07-21 13:00:00	QQQ	ETF	37.73	37.8	37.64	37.79	8039544.0
2009-07-21 13:30:00	QQQ	ETF	37.8	37.87	37.75	37.8095	6315427.0

> showing 50 of 7,591 rows — these rows as CSV

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