PREVIEW / etf_30min / 2010-05-10

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-10.parquet
  size:    278 KB
  rows:    9,364

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-05-10 04:00:00	SPY	ETF	115.75	116.01	115.72	116.01	63559.0
2010-05-10 04:30:00	SPY	ETF	115.94	116.33	115.82	116.25	50500.0
2010-05-10 05:00:00	SPY	ETF	116.23	116.64	116.23	116.64	57295.0
2010-05-10 05:30:00	SPY	ETF	116.52	116.57	116.11	116.23	62028.0
2010-05-10 06:00:00	SPY	ETF	116.22	116.23	115.82	115.89	342891.0
2010-05-10 06:30:00	SPY	ETF	115.94	116.21	115.93	116.06	427571.0
2010-05-10 07:00:00	SPY	ETF	116.0	116.66	115.95	116.56	2131157.0
2010-05-10 07:30:00	SPY	ETF	116.56	116.69	116.11	116.21	2191349.0
2010-05-10 08:00:00	SPY	ETF	116.2	116.5407	112.6	115.85	9529264.0
2010-05-10 08:30:00	SPY	ETF	115.85	116.14	115.55	116.01	4990088.0
2010-05-10 09:00:00	SPY	ETF	116.01	116.01	114.21	115.81	5944482.0
2010-05-10 09:30:00	SPY	ETF	115.81	116.65	115.61	115.98	71165586.0
2010-05-10 10:00:00	SPY	ETF	115.98	116.31	115.35	115.36	37303068.0
2010-05-10 10:30:00	SPY	ETF	115.35	115.96	115.27	115.6	35723226.0
2010-05-10 11:00:00	SPY	ETF	115.6	116.12	115.58	116.11	23343699.0
2010-05-10 11:30:00	SPY	ETF	116.11	116.43	115.88	116.24	17117880.0
2010-05-10 12:00:00	SPY	ETF	116.24	116.28	115.91	115.93	11701810.0
2010-05-10 12:30:00	SPY	ETF	115.93	116.11	115.78	115.78	11183623.0
2010-05-10 13:00:00	SPY	ETF	115.79	116.56	115.02	115.49	28357157.0
2010-05-10 13:30:00	SPY	ETF	115.49	116.0	115.055	115.2001	17819874.0
2010-05-10 14:00:00	SPY	ETF	115.2	115.7	114.91	115.39	21035027.0
2010-05-10 14:30:00	SPY	ETF	115.39	115.72	115.15	115.69	11766482.0
2010-05-10 15:00:00	SPY	ETF	115.69	115.7	115.1	115.51	15890266.0
2010-05-10 15:30:00	SPY	ETF	115.51	116.25	115.2609	116.16	36927533.0
2010-05-10 16:00:00	SPY	ETF	116.15	116.56	111.309	116.18	16845619.0
2010-05-10 16:30:00	SPY	ETF	116.16	116.32	111.309	116.26	5714266.0
2010-05-10 17:00:00	SPY	ETF	116.25	116.29	111.309	116.11	2148341.0
2010-05-10 17:30:00	SPY	ETF	116.15	116.15	116.06	116.08	32602.0
2010-05-10 18:00:00	SPY	ETF	116.07	116.17	116.03	116.04	60275.0
2010-05-10 18:30:00	SPY	ETF	116.03	116.1	116.03	116.1	22154.0
2010-05-10 19:00:00	SPY	ETF	116.11	116.11	116.01	116.08	39120.0
2010-05-10 19:30:00	SPY	ETF	116.04	116.11	115.98	116.02	116831.0
2010-05-10 04:00:00	QQQ	ETF	47.42	47.47	47.42	47.46	33079.0
2010-05-10 04:30:00	QQQ	ETF	47.52	47.6	47.52	47.6	10201.0
2010-05-10 05:00:00	QQQ	ETF	47.59	47.73	47.56	47.73	59853.0
2010-05-10 05:30:00	QQQ	ETF	47.71	47.71	47.55	47.62	20392.0
2010-05-10 06:00:00	QQQ	ETF	47.55	47.55	47.42	47.43	19650.0
2010-05-10 06:30:00	QQQ	ETF	47.54	47.58	47.49	47.56	11216.0
2010-05-10 07:00:00	QQQ	ETF	47.45	47.61	47.43	47.6	391718.0
2010-05-10 07:30:00	QQQ	ETF	47.6	47.62	47.38	47.42	253921.0
2010-05-10 08:00:00	QQQ	ETF	47.43	47.48	46.14	47.33	710869.0
2010-05-10 08:30:00	QQQ	ETF	47.32	47.48	47.22	47.42	1398452.0
2010-05-10 09:00:00	QQQ	ETF	47.4	47.44	45.41	47.42	2434037.0
2010-05-10 09:30:00	QQQ	ETF	47.42	47.79	47.38	47.56	26672444.0
2010-05-10 10:00:00	QQQ	ETF	47.561	47.69	47.36	47.37	17599591.0
2010-05-10 10:30:00	QQQ	ETF	47.37	47.6	47.37	47.52	10224341.0
2010-05-10 11:00:00	QQQ	ETF	47.52	47.7	47.48	47.64	7603096.0
2010-05-10 11:30:00	QQQ	ETF	47.64	47.8	47.55	47.75	6151562.0
2010-05-10 12:00:00	QQQ	ETF	47.76	47.77	47.63	47.64	3896046.0
2010-05-10 12:30:00	QQQ	ETF	47.64	47.7	47.56	47.59	3494893.0

> showing 50 of 9,364 rows — these rows as CSV

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