PREVIEW / etf_30min / 2010-06-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-23.parquet
  size:    247 KB
  rows:    8,211

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-06-23 04:00:00	SPY	ETF	110.12	110.15	110.05	110.13	16906.0
2010-06-23 04:30:00	SPY	ETF	110.12	110.16	110.0	110.06	6659.0
2010-06-23 05:00:00	SPY	ETF	110.0	110.05	109.95	110.01	13050.0
2010-06-23 05:30:00	SPY	ETF	110.02	110.02	109.96	110.0	5250.0
2010-06-23 06:00:00	SPY	ETF	110.04	110.2	110.04	110.11	9750.0
2010-06-23 06:30:00	SPY	ETF	110.13	110.13	109.97	110.01	3730.0
2010-06-23 07:00:00	SPY	ETF	110.0	110.08	109.97	110.07	309338.0
2010-06-23 07:30:00	SPY	ETF	110.07	110.09	109.9	109.97	150755.0
2010-06-23 08:00:00	SPY	ETF	109.98	110.18	109.92	109.95	769821.0
2010-06-23 08:30:00	SPY	ETF	109.97	110.11	109.91	110.02	648771.0
2010-06-23 09:00:00	SPY	ETF	110.01	110.02	109.61	109.64	1751394.0
2010-06-23 09:30:00	SPY	ETF	109.64	109.6599	109.19	109.5225	28080417.0
2010-06-23 10:00:00	SPY	ETF	109.55	109.56	108.48	108.66	32482555.0
2010-06-23 10:30:00	SPY	ETF	108.66	109.19	108.65	109.029	18293707.0
2010-06-23 11:00:00	SPY	ETF	109.03	109.09	108.82	108.99	10314134.0
2010-06-23 11:30:00	SPY	ETF	108.99	109.05	108.72	108.85	8041155.0
2010-06-23 12:00:00	SPY	ETF	108.8501	108.97	108.75	108.93	5526272.0
2010-06-23 12:30:00	SPY	ETF	108.9201	109.23	108.84	109.15	8572466.0
2010-06-23 13:00:00	SPY	ETF	109.15	109.3	109.08	109.23	8930030.0
2010-06-23 13:30:00	SPY	ETF	109.22	109.3625	109.14	109.31	5879059.0
2010-06-23 14:00:00	SPY	ETF	109.31	109.45	108.89	109.37	21481034.0
2010-06-23 14:30:00	SPY	ETF	109.37	110.03	109.05	109.2	31393846.0
2010-06-23 15:00:00	SPY	ETF	109.21	109.45	108.8	109.31	28515003.0
2010-06-23 15:30:00	SPY	ETF	109.3	109.59	109.0	109.21	31795060.0
2010-06-23 16:00:00	SPY	ETF	109.21	109.83	108.67	109.15	8423557.0
2010-06-23 16:30:00	SPY	ETF	109.14	112.4175	108.99	109.07	403846.0
2010-06-23 17:00:00	SPY	ETF	109.05	109.08	108.92	108.93	114366.0
2010-06-23 17:30:00	SPY	ETF	108.93	108.98	108.93	108.98	42021.0
2010-06-23 18:00:00	SPY	ETF	108.96	109.26	108.95	108.98	97941.0
2010-06-23 18:30:00	SPY	ETF	108.98	109.01	108.93	108.94	27860.0
2010-06-23 19:00:00	SPY	ETF	108.96	109.06	108.96	109.02	15296.0
2010-06-23 19:30:00	SPY	ETF	109.05	109.08	108.95	109.06	29850.0
2010-06-23 04:00:00	QQQ	ETF	46.42	46.44	46.42	46.44	1933.0
2010-06-23 04:30:00	QQQ	ETF	46.42	46.42	46.42	46.42	100.0
2010-06-23 05:00:00	QQQ	ETF	46.4	46.4	46.4	46.4	13000.0
2010-06-23 06:00:00	QQQ	ETF	46.45	46.47	46.43	46.43	13600.0
2010-06-23 06:30:00	QQQ	ETF	46.39	46.41	46.39	46.4	4600.0
2010-06-23 07:00:00	QQQ	ETF	46.39	46.41	46.37	46.4	31735.0
2010-06-23 07:30:00	QQQ	ETF	46.4	46.41	46.36	46.36	35144.0
2010-06-23 08:00:00	QQQ	ETF	46.39	46.5	46.37	46.39	436499.0
2010-06-23 08:30:00	QQQ	ETF	46.38	46.46	46.37	46.41	281110.0
2010-06-23 09:00:00	QQQ	ETF	46.41	46.41	46.24	46.29	353001.0
2010-06-23 09:30:00	QQQ	ETF	46.29	46.35	46.02	46.16	12207838.0
2010-06-23 10:00:00	QQQ	ETF	46.15	46.16	45.69	45.7	12287246.0
2010-06-23 10:30:00	QQQ	ETF	45.7	46.07	45.69	45.9997	5459799.0
2010-06-23 11:00:00	QQQ	ETF	46.0	46.01	45.84	45.97	2774377.0
2010-06-23 11:30:00	QQQ	ETF	45.96	46.0	45.82	45.91	2307130.0
2010-06-23 12:00:00	QQQ	ETF	45.905	45.97	45.87	45.94	1651648.0
2010-06-23 12:30:00	QQQ	ETF	45.94	46.12	45.9	46.0699	2056857.0
2010-06-23 13:00:00	QQQ	ETF	46.07	46.16	46.02	46.1	2584604.0

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

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