PREVIEW / etf_30min / 2010-03-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-23.parquet
  size:    249 KB
  rows:    8,291

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-03-23 04:30:00	SPY	ETF	116.87	116.88	116.87	116.88	200.0
2010-03-23 05:00:00	SPY	ETF	116.8	116.89	116.8	116.89	400.0
2010-03-23 05:30:00	SPY	ETF	116.9	116.9	116.89	116.89	1000.0
2010-03-23 06:00:00	SPY	ETF	116.885	116.885	116.84	116.84	9000.0
2010-03-23 06:30:00	SPY	ETF	116.87	116.87	116.84	116.84	5025.0
2010-03-23 07:00:00	SPY	ETF	116.84	116.84	116.7	116.7	124808.0
2010-03-23 07:30:00	SPY	ETF	116.67	116.75	116.56	116.58	187578.0
2010-03-23 08:00:00	SPY	ETF	116.57	116.69	116.54	116.67	358220.0
2010-03-23 08:30:00	SPY	ETF	116.66	116.74	116.57	116.74	1355041.0
2010-03-23 09:00:00	SPY	ETF	116.74	116.85	116.73	116.76	1374883.0
2010-03-23 09:30:00	SPY	ETF	116.76	116.86	116.43	116.631	16037854.0
2010-03-23 10:00:00	SPY	ETF	116.63	116.97	116.51	116.8699	19648900.0
2010-03-23 10:30:00	SPY	ETF	116.86	116.89	116.53	116.59	12863038.0
2010-03-23 11:00:00	SPY	ETF	116.5825	116.63	116.38	116.59	14788566.0
2010-03-23 11:30:00	SPY	ETF	116.59	116.78	116.49	116.74	12299121.0
2010-03-23 12:00:00	SPY	ETF	116.75	116.95	116.71	116.86	9146665.0
2010-03-23 12:30:00	SPY	ETF	116.86	116.89	116.705	116.79	5954211.0
2010-03-23 13:00:00	SPY	ETF	116.7801	116.99	116.78	116.92	6795182.0
2010-03-23 13:30:00	SPY	ETF	116.92	116.93	116.7	116.7	6481873.0
2010-03-23 14:00:00	SPY	ETF	116.7	116.99	116.7	116.96	6765091.0
2010-03-23 14:30:00	SPY	ETF	116.97	117.03	116.5837	116.98	9224460.0
2010-03-23 15:00:00	SPY	ETF	116.97	117.43	116.92	117.385	21386142.0
2010-03-23 15:30:00	SPY	ETF	117.38	117.51	117.31	117.42	23495670.0
2010-03-23 16:00:00	SPY	ETF	117.42	117.4619	116.55	117.4	7724176.0
2010-03-23 16:30:00	SPY	ETF	117.4	117.45	117.37	117.43	2157248.0
2010-03-23 17:00:00	SPY	ETF	117.42	117.47	117.41	117.43	66397.0
2010-03-23 17:30:00	SPY	ETF	117.42	117.42	117.39	117.4	77653.0
2010-03-23 18:00:00	SPY	ETF	117.35	117.45	117.35	117.44	95750.0
2010-03-23 18:30:00	SPY	ETF	117.41	117.47	117.41	117.42	24837.0
2010-03-23 19:00:00	SPY	ETF	117.44	117.44	117.38	117.38	90472.0
2010-03-23 19:30:00	SPY	ETF	117.38	117.41	117.38	117.4	105241.0
2010-03-23 04:00:00	QQQ	ETF	47.95	47.95	47.95	47.95	1211.0
2010-03-23 06:30:00	QQQ	ETF	48.02	48.03	48.02	48.03	300.0
2010-03-23 07:00:00	QQQ	ETF	48.02	48.02	47.99	47.99	300.0
2010-03-23 07:30:00	QQQ	ETF	47.95	47.98	47.93	47.94	78011.0
2010-03-23 08:00:00	QQQ	ETF	47.92	47.99	47.92	47.98	102625.0
2010-03-23 08:30:00	QQQ	ETF	47.98	48.03	47.95	48.02	216819.0
2010-03-23 09:00:00	QQQ	ETF	48.03	48.07	48.0	48.0	346895.0
2010-03-23 09:30:00	QQQ	ETF	48.0	48.075	47.87	47.98	6159946.0
2010-03-23 10:00:00	QQQ	ETF	47.9701	48.08	47.88	48.038	6913220.0
2010-03-23 10:30:00	QQQ	ETF	48.0317	48.05	47.84	47.8716	4944771.0
2010-03-23 11:00:00	QQQ	ETF	47.87	47.93	47.77	47.89	4194195.0
2010-03-23 11:30:00	QQQ	ETF	47.89	47.97	47.86	47.95	3730023.0
2010-03-23 12:00:00	QQQ	ETF	47.95	48.02	47.93	47.9881	2914309.0
2010-03-23 12:30:00	QQQ	ETF	47.99	48.0	47.93	47.98	1814874.0
2010-03-23 13:00:00	QQQ	ETF	47.98	48.07	47.97	48.05	2161753.0
2010-03-23 13:30:00	QQQ	ETF	48.05	48.05	47.94	47.95	2678109.0
2010-03-23 14:00:00	QQQ	ETF	47.95	48.09	47.94	48.09	3532796.0
2010-03-23 14:30:00	QQQ	ETF	48.09	48.12	48.05	48.11	3427130.0
2010-03-23 15:00:00	QQQ	ETF	48.1099	48.28	48.08	48.27	6018640.0

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

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