PREVIEW / etf_30min / 2010-05-27

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-27.parquet
  size:    269 KB
  rows:    9,026

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-05-27 04:00:00	SPY	ETF	108.62	108.68	108.44	108.44	21436.0
2010-05-27 04:30:00	SPY	ETF	108.55	108.8	108.54	108.75	47803.0
2010-05-27 05:00:00	SPY	ETF	108.81	109.22	108.81	109.19	36449.0
2010-05-27 05:30:00	SPY	ETF	109.22	109.46	109.14	109.46	69700.0
2010-05-27 06:00:00	SPY	ETF	109.42	109.65	109.35	109.46	249220.0
2010-05-27 06:30:00	SPY	ETF	109.49	109.49	109.19	109.26	225801.0
2010-05-27 07:00:00	SPY	ETF	109.25	109.29	109.01	109.04	1635196.0
2010-05-27 07:30:00	SPY	ETF	109.04	109.19	108.95	109.04	945103.0
2010-05-27 08:00:00	SPY	ETF	109.04	109.37	108.87	109.3	2547962.0
2010-05-27 08:30:00	SPY	ETF	109.3	109.6	106.97	108.84	4270487.0
2010-05-27 09:00:00	SPY	ETF	108.83	109.2	108.77	109.2	1752019.0
2010-05-27 09:30:00	SPY	ETF	109.19	109.44	108.86	109.13	36735498.0
2010-05-27 10:00:00	SPY	ETF	109.13	109.78	108.7801	109.76	27102594.0
2010-05-27 10:30:00	SPY	ETF	109.76	109.98	109.46	109.6917	22241348.0
2010-05-27 11:00:00	SPY	ETF	109.69	109.88	109.39	109.82	19463358.0
2010-05-27 11:30:00	SPY	ETF	109.83	109.9	109.38	109.845	12817687.0
2010-05-27 12:00:00	SPY	ETF	109.84	109.87	109.35	109.69	12024179.0
2010-05-27 12:30:00	SPY	ETF	109.69	109.74	109.55	109.59	9184187.0
2010-05-27 13:00:00	SPY	ETF	109.59	109.85	109.26	109.74	13695902.0
2010-05-27 13:30:00	SPY	ETF	109.74	109.97	109.67	109.71	11962691.0
2010-05-27 14:00:00	SPY	ETF	109.71	110.27	109.66	110.16	14830731.0
2010-05-27 14:30:00	SPY	ETF	110.16	110.21	109.87	109.97	11273968.0
2010-05-27 15:00:00	SPY	ETF	109.97	110.35	109.82	109.965	18273794.0
2010-05-27 15:30:00	SPY	ETF	109.975	110.8	109.94	110.78	40890243.0
2010-05-27 16:00:00	SPY	ETF	110.77	110.79	108.99	110.53	19701065.0
2010-05-27 16:30:00	SPY	ETF	110.55	110.721	110.2197	110.63	15430122.0
2010-05-27 17:00:00	SPY	ETF	110.76	110.76	106.8	110.71	561096.0
2010-05-27 17:30:00	SPY	ETF	110.71	110.76	110.68	110.68	62340.0
2010-05-27 18:00:00	SPY	ETF	110.67	110.9	110.65	110.74	291780.0
2010-05-27 18:30:00	SPY	ETF	110.75	110.75	110.59	110.59	64230.0
2010-05-27 19:00:00	SPY	ETF	110.6	110.66	110.56	110.65	70966.0
2010-05-27 19:30:00	SPY	ETF	110.69	110.78	110.65	110.7	68314.0
2010-05-27 04:00:00	QQQ	ETF	44.93	44.95	44.85	44.85	8223.0
2010-05-27 04:30:00	QQQ	ETF	44.95	45.02	44.95	45.02	1043.0
2010-05-27 05:00:00	QQQ	ETF	45.05	45.18	45.05	45.17	2011.0
2010-05-27 05:30:00	QQQ	ETF	45.21	45.3	45.18	45.3	8000.0
2010-05-27 06:00:00	QQQ	ETF	45.28	45.35	45.24	45.24	15123.0
2010-05-27 06:30:00	QQQ	ETF	45.28	45.3	45.18	45.18	89235.0
2010-05-27 07:00:00	QQQ	ETF	45.16	45.2	45.1	45.12	522572.0
2010-05-27 07:30:00	QQQ	ETF	45.12	45.13	45.04	45.08	615525.0
2010-05-27 08:00:00	QQQ	ETF	45.08	45.22	44.99	45.22	3643208.0
2010-05-27 08:30:00	QQQ	ETF	45.19	45.19	44.93	45.05	1129421.0
2010-05-27 09:00:00	QQQ	ETF	45.05	45.21	45.02	45.21	1101017.0
2010-05-27 09:30:00	QQQ	ETF	45.22	45.37	45.09	45.22	15364486.0
2010-05-27 10:00:00	QQQ	ETF	45.21	45.47	45.1	45.46	11382512.0
2010-05-27 10:30:00	QQQ	ETF	45.46	45.55	45.26	45.37	10731749.0
2010-05-27 11:00:00	QQQ	ETF	45.37	45.5	45.28	45.48	7715610.0
2010-05-27 11:30:00	QQQ	ETF	45.47	45.49	45.33	45.46	4949591.0
2010-05-27 12:00:00	QQQ	ETF	45.46	45.5	45.38	45.46	6663175.0
2010-05-27 12:30:00	QQQ	ETF	45.46	45.49	45.38	45.43	5079302.0

> showing 50 of 9,026 rows — these rows as CSV

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