PREVIEW / etf_30min / 2010-07-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-01.parquet
  size:    270 KB
  rows:    8,927

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-07-01 04:00:00	SPY	ETF	102.91	102.98	102.89	102.92	1800.0
2010-07-01 04:30:00	SPY	ETF	102.85	103.0	102.85	102.95	3100.0
2010-07-01 05:00:00	SPY	ETF	102.95	102.95	102.73	102.73	4800.0
2010-07-01 05:30:00	SPY	ETF	102.75	102.76	102.75	102.75	3400.0
2010-07-01 06:00:00	SPY	ETF	102.8	103.1	102.8	103.1	73300.0
2010-07-01 06:30:00	SPY	ETF	103.05	103.26	103.05	103.25	133900.0
2010-07-01 07:00:00	SPY	ETF	103.26	103.26	103.0	103.06	492404.0
2010-07-01 07:30:00	SPY	ETF	103.05	103.05	102.82	102.86	1320082.0
2010-07-01 08:00:00	SPY	ETF	102.86	103.22	102.75	102.92	2912977.0
2010-07-01 08:30:00	SPY	ETF	102.93	103.1432	102.42	103.12	6161878.0
2010-07-01 09:00:00	SPY	ETF	103.11	103.27	102.48	103.15	3195673.0
2010-07-01 09:30:00	SPY	ETF	103.15	103.49	102.77	102.81	33000005.0
2010-07-01 10:00:00	SPY	ETF	102.85	102.87	101.93	102.1317	43671504.0
2010-07-01 10:30:00	SPY	ETF	102.14	102.21	101.26	101.5	38977346.0
2010-07-01 11:00:00	SPY	ETF	101.5	101.89	101.13	101.87	29905742.0
2010-07-01 11:30:00	SPY	ETF	101.87	102.25	101.75	102.03	23671359.0
2010-07-01 12:00:00	SPY	ETF	102.04	102.04	101.68	101.91	13776696.0
2010-07-01 12:30:00	SPY	ETF	101.9	102.93	101.85	102.52	27774492.0
2010-07-01 13:00:00	SPY	ETF	102.52	102.79	102.27	102.5	11904018.0
2010-07-01 13:30:00	SPY	ETF	102.5	102.98	102.44	102.7901	17563677.0
2010-07-01 14:00:00	SPY	ETF	102.79	103.13	102.6	102.78	18264468.0
2010-07-01 14:30:00	SPY	ETF	102.78	102.89	102.08	102.47	23739878.0
2010-07-01 15:00:00	SPY	ETF	102.47	102.89	102.32	102.72	21797661.0
2010-07-01 15:30:00	SPY	ETF	102.71	103.04	102.38	102.79	38284880.0
2010-07-01 16:00:00	SPY	ETF	102.8	102.86	102.1	102.69	17940193.0
2010-07-01 16:30:00	SPY	ETF	102.69	103.1432	102.66	102.69	5880010.0
2010-07-01 17:00:00	SPY	ETF	102.69	102.78	102.68	102.77	246933.0
2010-07-01 17:30:00	SPY	ETF	102.75	102.78	102.7	102.75	80940.0
2010-07-01 18:00:00	SPY	ETF	102.78	102.86	102.77	102.82	119599.0
2010-07-01 18:30:00	SPY	ETF	102.83	102.88	102.82	102.85	92571.0
2010-07-01 19:00:00	SPY	ETF	102.87	102.87	102.81	102.84	8234.0
2010-07-01 19:30:00	SPY	ETF	102.85	102.93	102.77	102.93	53135.0
2010-07-01 04:30:00	QQQ	ETF	42.58	42.65	42.58	42.65	3100.0
2010-07-01 06:00:00	QQQ	ETF	42.65	42.7	42.65	42.67	27500.0
2010-07-01 06:30:00	QQQ	ETF	42.66	42.73	42.66	42.73	2100.0
2010-07-01 07:00:00	QQQ	ETF	42.72	42.72	42.64	42.64	74448.0
2010-07-01 07:30:00	QQQ	ETF	42.62	42.64	42.57	42.58	735832.0
2010-07-01 08:00:00	QQQ	ETF	42.57	42.66	42.54	42.64	2962071.0
2010-07-01 08:30:00	QQQ	ETF	42.62	42.75	42.45	42.72	1316705.0
2010-07-01 09:00:00	QQQ	ETF	42.73	42.86	42.73	42.82	1399053.0
2010-07-01 09:30:00	QQQ	ETF	42.82	42.96	42.6	42.67	18011753.0
2010-07-01 10:00:00	QQQ	ETF	42.67	42.67	42.19	42.23	18836214.0
2010-07-01 10:30:00	QQQ	ETF	42.23	42.26	41.77	42.01	16946441.0
2010-07-01 11:00:00	QQQ	ETF	42.0	42.39	41.9	42.3801	12705282.0
2010-07-01 11:30:00	QQQ	ETF	42.38	42.51	42.31	42.41	9332772.0
2010-07-01 12:00:00	QQQ	ETF	42.41	42.42	42.21	42.2719	8020118.0
2010-07-01 12:30:00	QQQ	ETF	42.27	42.73	42.26	42.54	8992315.0
2010-07-01 13:00:00	QQQ	ETF	42.53	42.8256	42.42	42.5	4138281.0
2010-07-01 13:30:00	QQQ	ETF	42.5	42.71	42.48	42.63	6296944.0
2010-07-01 14:00:00	QQQ	ETF	42.62	42.79	42.54	42.58	6231843.0

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

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