PREVIEW / etf_30min / 2009-05-28

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-28.parquet
  size:    219 KB
  rows:    7,230

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-05-28 04:00:00	SPY	ETF	89.93	89.99	89.93	89.96	565.0
2009-05-28 04:30:00	SPY	ETF	90.02	90.04	90.02	90.04	13900.0
2009-05-28 05:00:00	SPY	ETF	90.09	90.19	90.08	90.11	3000.0
2009-05-28 05:30:00	SPY	ETF	90.1	90.17	90.06	90.06	1000.0
2009-05-28 06:00:00	SPY	ETF	90.1	90.1	89.94	89.94	44900.0
2009-05-28 06:30:00	SPY	ETF	89.92	89.92	89.92	89.92	100.0
2009-05-28 07:00:00	SPY	ETF	90.0	90.13	89.95	89.96	104021.0
2009-05-28 07:30:00	SPY	ETF	89.97	90.07	89.59	89.68	556117.0
2009-05-28 08:00:00	SPY	ETF	89.73	89.9	89.68	89.86	1248320.0
2009-05-28 08:30:00	SPY	ETF	89.84	90.15	89.76	89.99	3500416.0
2009-05-28 09:00:00	SPY	ETF	89.98	90.45	89.86	90.45	2374406.0
2009-05-28 09:30:00	SPY	ETF	90.46	90.7	90.16	90.225	24989083.0
2009-05-28 10:00:00	SPY	ETF	90.21	90.45	89.1	89.39	34446701.0
2009-05-28 10:30:00	SPY	ETF	89.39	89.93	89.3	89.89	16621727.0
2009-05-28 11:00:00	SPY	ETF	89.9	90.32	89.5	90.16	19569603.0
2009-05-28 11:30:00	SPY	ETF	90.17	90.61	90.1	90.52	15129204.0
2009-05-28 12:00:00	SPY	ETF	90.52	90.6	89.92	89.96	15166728.0
2009-05-28 12:30:00	SPY	ETF	89.95	90.15	89.67	89.77	14418045.0
2009-05-28 13:00:00	SPY	ETF	89.78	91.03	89.7	90.76	36567071.0
2009-05-28 13:30:00	SPY	ETF	90.77	90.93	90.4	90.66	16293274.0
2009-05-28 14:00:00	SPY	ETF	90.64	91.25	90.59	91.11	18590770.0
2009-05-28 14:30:00	SPY	ETF	91.11	91.34	90.9	91.11	14190848.0
2009-05-28 15:00:00	SPY	ETF	91.11	91.26	90.63	90.89	14595183.0
2009-05-28 15:30:00	SPY	ETF	90.9	91.17	90.71	90.95	27027043.0
2009-05-28 16:00:00	SPY	ETF	90.95	91.04	90.1	91.0	11733031.0
2009-05-28 16:30:00	SPY	ETF	91.0	91.04	90.94	90.98	192897.0
2009-05-28 17:00:00	SPY	ETF	90.97	91.0	90.93	90.99	20463.0
2009-05-28 17:30:00	SPY	ETF	90.98	91.06	90.94	90.96	21748.0
2009-05-28 18:00:00	SPY	ETF	90.96	90.96	90.9	90.96	28736.0
2009-05-28 18:30:00	SPY	ETF	90.9	90.94	90.85	90.89	24200.0
2009-05-28 19:00:00	SPY	ETF	90.89	90.92	90.85	90.92	5985.0
2009-05-28 19:30:00	SPY	ETF	90.92	90.95	90.86	90.92	15000.0
2009-05-28 05:00:00	QQQ	ETF	34.73	34.75	34.73	34.73	1200.0
2009-05-28 05:30:00	QQQ	ETF	34.72	34.72	34.72	34.72	200.0
2009-05-28 06:00:00	QQQ	ETF	34.68	34.68	34.68	34.68	300.0
2009-05-28 06:30:00	QQQ	ETF	34.7	34.7	34.67	34.67	408.0
2009-05-28 07:00:00	QQQ	ETF	34.68	34.71	34.64	34.67	8500.0
2009-05-28 07:30:00	QQQ	ETF	34.69	34.69	34.54	34.57	19346.0
2009-05-28 08:00:00	QQQ	ETF	34.57	34.67	34.57	34.66	207706.0
2009-05-28 08:30:00	QQQ	ETF	34.64	34.73	34.53	34.66	822897.0
2009-05-28 09:00:00	QQQ	ETF	34.67	34.79	34.62	34.77	578085.0
2009-05-28 09:30:00	QQQ	ETF	34.78	34.93	34.64	34.68	11309605.0
2009-05-28 10:00:00	QQQ	ETF	34.68	34.7	34.21	34.46	15268393.0
2009-05-28 10:30:00	QQQ	ETF	34.46	34.51	34.34	34.4999	6369503.0
2009-05-28 11:00:00	QQQ	ETF	34.5	34.66	34.49	34.56	5671360.0
2009-05-28 11:30:00	QQQ	ETF	34.56	34.74	34.53	34.72	5723417.0
2009-05-28 12:00:00	QQQ	ETF	34.72	34.75	34.45	34.4899	7828296.0
2009-05-28 12:30:00	QQQ	ETF	34.48	34.53	34.42	34.47	3589691.0
2009-05-28 13:00:00	QQQ	ETF	34.47	34.95	34.47	34.85	14815532.0
2009-05-28 13:30:00	QQQ	ETF	34.85	34.91	34.74	34.82	4942910.0

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

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