PREVIEW / etf_30min / 2010-05-07

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-07.parquet
  size:    285 KB
  rows:    9,601

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-07 04:00:00	SPY	ETF	113.0	113.7	113.0	113.62	6100.0
2010-05-07 04:30:00	SPY	ETF	113.64	113.73	113.09	113.09	18390.0
2010-05-07 05:00:00	SPY	ETF	113.02	113.09	112.76	112.99	9570.0
2010-05-07 05:30:00	SPY	ETF	113.0	113.38	113.0	113.22	6800.0
2010-05-07 06:00:00	SPY	ETF	113.32	113.64	113.28	113.38	96170.0
2010-05-07 06:30:00	SPY	ETF	113.4	113.88	113.4	113.82	126750.0
2010-05-07 07:00:00	SPY	ETF	113.82	113.89	113.4	113.52	803064.0
2010-05-07 07:30:00	SPY	ETF	113.49	113.7	113.04	113.1	1863075.0
2010-05-07 08:00:00	SPY	ETF	113.1	113.8	112.0	113.74	8544839.0
2010-05-07 08:30:00	SPY	ETF	113.53	114.1	112.96	113.37	9762805.0
2010-05-07 09:00:00	SPY	ETF	113.37	113.48	112.18	112.64	3637891.0
2010-05-07 09:30:00	SPY	ETF	112.64	113.77	112.15	112.52	69213244.0
2010-05-07 10:00:00	SPY	ETF	112.51	113.35	109.58	110.29	74187837.0
2010-05-07 10:30:00	SPY	ETF	110.3	112.09	110.288	110.96	73316468.0
2010-05-07 11:00:00	SPY	ETF	110.96	113.0895	110.55	111.75	66237389.0
2010-05-07 11:30:00	SPY	ETF	111.76	112.8	111.07	112.41	42281781.0
2010-05-07 12:00:00	SPY	ETF	112.41	113.26	109.41	112.24	34136403.0
2010-05-07 12:30:00	SPY	ETF	112.24	113.0	111.74	111.94	24756552.0
2010-05-07 13:00:00	SPY	ETF	111.94	112.24	111.29	111.59	28260344.0
2010-05-07 13:30:00	SPY	ETF	111.6	112.47	111.52	111.99	18474211.0
2010-05-07 14:00:00	SPY	ETF	111.99	112.18	111.19	111.21	25088019.0
2010-05-07 14:30:00	SPY	ETF	111.21	111.97	111.13	111.5	21125164.0
2010-05-07 15:00:00	SPY	ETF	111.5	111.58	110.66	111.13	40312907.0
2010-05-07 15:30:00	SPY	ETF	111.13	111.56	110.55	111.3	58960665.0
2010-05-07 16:00:00	SPY	ETF	111.18	113.2	110.5804	111.35	19733223.0
2010-05-07 16:30:00	SPY	ETF	111.35	113.0315	111.32	111.63	6742160.0
2010-05-07 17:00:00	SPY	ETF	111.64	111.91	111.57	111.75	3337525.0
2010-05-07 17:30:00	SPY	ETF	111.75	111.88	111.6	111.6	288084.0
2010-05-07 18:00:00	SPY	ETF	111.58	111.65	111.34	111.47	353142.0
2010-05-07 18:30:00	SPY	ETF	111.45	111.45	111.3	111.4	114361.0
2010-05-07 19:00:00	SPY	ETF	111.44	111.64	111.4	111.6	64767.0
2010-05-07 19:30:00	SPY	ETF	111.6	111.86	111.5	111.79	219632.0
2010-05-07 04:00:00	QQQ	ETF	46.7	46.75	46.7	46.75	1700.0
2010-05-07 04:30:00	QQQ	ETF	46.72	46.73	46.6	46.6	3550.0
2010-05-07 05:00:00	QQQ	ETF	46.58	46.58	46.46	46.46	1400.0
2010-05-07 05:30:00	QQQ	ETF	46.64	46.64	46.64	46.64	100.0
2010-05-07 06:00:00	QQQ	ETF	46.69	46.83	46.69	46.81	9100.0
2010-05-07 06:30:00	QQQ	ETF	46.84	46.98	46.84	46.93	14613.0
2010-05-07 07:00:00	QQQ	ETF	46.94	46.94	46.79	46.82	247194.0
2010-05-07 07:30:00	QQQ	ETF	46.83	46.88	46.64	46.64	568407.0
2010-05-07 08:00:00	QQQ	ETF	46.6	46.98	46.52	46.98	3962062.0
2010-05-07 08:30:00	QQQ	ETF	46.99	47.0	46.53	46.62	2523829.0
2010-05-07 09:00:00	QQQ	ETF	46.63	46.65	46.22	46.23	1641929.0
2010-05-07 09:30:00	QQQ	ETF	46.22	46.8	45.91	46.11	36144965.0
2010-05-07 10:00:00	QQQ	ETF	46.1199	46.2	44.47	44.85	41228623.0
2010-05-07 10:30:00	QQQ	ETF	44.85	45.6999	44.84	45.421	39979353.0
2010-05-07 11:00:00	QQQ	ETF	45.43	46.37	45.36	45.73	29582238.0
2010-05-07 11:30:00	QQQ	ETF	45.73	46.25	45.19	46.08	18626347.0
2010-05-07 12:00:00	QQQ	ETF	46.07	46.4	45.89	46.02	10980854.0
2010-05-07 12:30:00	QQQ	ETF	46.02	46.07	45.78	45.8401	6563449.0

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

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