PREVIEW / etf_30min / 2010-04-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-01.parquet
  size:    251 KB
  rows:    8,440

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-04-01 04:00:00	SPY	ETF	117.58	117.61	117.56	117.61	3320.0
2010-04-01 04:30:00	SPY	ETF	117.6	117.63	117.6	117.63	230.0
2010-04-01 05:00:00	SPY	ETF	117.53	117.53	117.53	117.53	100.0
2010-04-01 05:30:00	SPY	ETF	117.52	117.55	117.51	117.51	2409.0
2010-04-01 06:00:00	SPY	ETF	117.52	117.54	117.51	117.52	20500.0
2010-04-01 06:30:00	SPY	ETF	117.52	117.52	117.42	117.45	35400.0
2010-04-01 07:00:00	SPY	ETF	117.48	117.58	117.45	117.52	236200.0
2010-04-01 07:30:00	SPY	ETF	117.53	117.55	117.48	117.51	280019.0
2010-04-01 08:00:00	SPY	ETF	117.51	117.6	116.99	117.54	782181.0
2010-04-01 08:30:00	SPY	ETF	117.6	117.79	117.0	117.69	1483062.0
2010-04-01 09:00:00	SPY	ETF	117.69	117.81	117.0	117.79	1273274.0
2010-04-01 09:30:00	SPY	ETF	117.8	118.19	117.77	118.04	22157386.0
2010-04-01 10:00:00	SPY	ETF	118.05	118.25	117.85	117.97	15808294.0
2010-04-01 10:30:00	SPY	ETF	117.98	118.07	117.75	117.838	9294853.0
2010-04-01 11:00:00	SPY	ETF	117.83	117.98	117.71	117.91	7482073.0
2010-04-01 11:30:00	SPY	ETF	117.905	118.03	117.88	117.93	5720106.0
2010-04-01 12:00:00	SPY	ETF	117.9378	117.96	117.83	117.85	5012049.0
2010-04-01 12:30:00	SPY	ETF	117.8401	117.91	117.8	117.85	4287031.0
2010-04-01 13:00:00	SPY	ETF	117.842	117.9	117.79	117.87	3065701.0
2010-04-01 13:30:00	SPY	ETF	117.88	117.94	117.47	117.54	9527115.0
2010-04-01 14:00:00	SPY	ETF	117.55	117.64	117.38	117.44	11506167.0
2010-04-01 14:30:00	SPY	ETF	117.45	117.52	117.1	117.41	16862431.0
2010-04-01 15:00:00	SPY	ETF	117.41	117.5133	117.31	117.43	6984120.0
2010-04-01 15:30:00	SPY	ETF	117.43	117.85	117.4	117.81	16222283.0
2010-04-01 16:00:00	SPY	ETF	117.81	117.94	117.29	117.8	17409050.0
2010-04-01 16:30:00	SPY	ETF	117.8	117.86	117.79	117.84	1218129.0
2010-04-01 17:00:00	SPY	ETF	117.84	117.96	117.82	117.93	140125.0
2010-04-01 17:30:00	SPY	ETF	117.95	117.95	117.86	117.94	26164.0
2010-04-01 18:00:00	SPY	ETF	117.93	117.94	117.83	117.88	23536.0
2010-04-01 18:30:00	SPY	ETF	117.86	117.88	117.82	117.86	20600.0
2010-04-01 19:00:00	SPY	ETF	117.86	117.89	117.83	117.86	56708.0
2010-04-01 19:30:00	SPY	ETF	117.89	117.89	117.75	117.79	32808.0
2010-04-01 05:30:00	QQQ	ETF	48.21	48.23	48.21	48.23	4100.0
2010-04-01 06:00:00	QQQ	ETF	48.24	48.24	48.23	48.23	4500.0
2010-04-01 07:00:00	QQQ	ETF	48.27	48.28	48.25	48.28	48179.0
2010-04-01 07:30:00	QQQ	ETF	48.28	48.3	48.27	48.29	20300.0
2010-04-01 08:00:00	QQQ	ETF	48.29	48.34	48.27	48.34	425348.0
2010-04-01 08:30:00	QQQ	ETF	48.36	48.41	48.29	48.34	512905.0
2010-04-01 09:00:00	QQQ	ETF	48.34	48.37	48.16	48.34	218539.0
2010-04-01 09:30:00	QQQ	ETF	48.34	48.66	48.34	48.6	8524565.0
2010-04-01 10:00:00	QQQ	ETF	48.61	48.7	48.45	48.51	6371228.0
2010-04-01 10:30:00	QQQ	ETF	48.51	48.54	48.36	48.395	5152114.0
2010-04-01 11:00:00	QQQ	ETF	48.39	48.4	48.26	48.34	4551374.0
2010-04-01 11:30:00	QQQ	ETF	48.34	48.38	48.3399	48.35	3841505.0
2010-04-01 12:00:00	QQQ	ETF	48.36	48.38	48.29	48.3	2680593.0
2010-04-01 12:30:00	QQQ	ETF	48.3	48.34	48.27	48.319	2048913.0
2010-04-01 13:00:00	QQQ	ETF	48.32	48.32	48.27	48.29	1498672.0
2010-04-01 13:30:00	QQQ	ETF	48.291	48.31	47.99	48.02	6779240.0
2010-04-01 14:00:00	QQQ	ETF	48.03	48.08	47.95	47.9699	6719150.0
2010-04-01 14:30:00	QQQ	ETF	47.96	48.01	47.79	47.98	12534837.0

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

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