PREVIEW / etf_30min / 2010-05-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-26.parquet
  size:    272 KB
  rows:    9,066

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-26 04:00:00	SPY	ETF	108.34	108.34	108.2	108.2	1350.0
2010-05-26 04:30:00	SPY	ETF	108.32	108.39	108.24	108.39	892.0
2010-05-26 05:00:00	SPY	ETF	108.47	108.64	108.47	108.64	2715.0
2010-05-26 05:30:00	SPY	ETF	108.63	108.7	108.4	108.4	31375.0
2010-05-26 06:00:00	SPY	ETF	108.4	108.49	108.3	108.31	21700.0
2010-05-26 06:30:00	SPY	ETF	108.25	108.54	108.2	108.51	49800.0
2010-05-26 07:00:00	SPY	ETF	108.5	108.84	108.5	108.79	349613.0
2010-05-26 07:30:00	SPY	ETF	108.77	108.78	108.66	108.76	229248.0
2010-05-26 08:00:00	SPY	ETF	108.78	109.0	108.75	108.94	1582466.0
2010-05-26 08:30:00	SPY	ETF	108.92	109.08	108.5	108.56	3515816.0
2010-05-26 09:00:00	SPY	ETF	108.56	108.83	108.39	108.51	3668344.0
2010-05-26 09:30:00	SPY	ETF	108.48	109.25	108.45	109.14	47083399.0
2010-05-26 10:00:00	SPY	ETF	109.14	109.39	108.7	109.09	31536389.0
2010-05-26 10:30:00	SPY	ETF	109.08	109.47	108.85	109.0	26689039.0
2010-05-26 11:00:00	SPY	ETF	109.0	109.11	108.47	108.47	20687389.0
2010-05-26 11:30:00	SPY	ETF	108.48	108.72	108.18	108.61	22344341.0
2010-05-26 12:00:00	SPY	ETF	108.61	108.96	108.54	108.68	9519034.0
2010-05-26 12:30:00	SPY	ETF	108.67	108.885	108.4	108.88	10122822.0
2010-05-26 13:00:00	SPY	ETF	108.88	109.0	108.69	108.8017	7637336.0
2010-05-26 13:30:00	SPY	ETF	108.8	109.18	108.72	108.95	8617395.0
2010-05-26 14:00:00	SPY	ETF	108.95	109.05	107.7791	108.68	12807120.0
2010-05-26 14:30:00	SPY	ETF	108.69	108.75	107.91	108.24	29468651.0
2010-05-26 15:00:00	SPY	ETF	108.24	108.52	106.95	107.24	32696196.0
2010-05-26 15:30:00	SPY	ETF	107.23	108.65	106.85	107.15	50216100.0
2010-05-26 16:00:00	SPY	ETF	107.14	109.4	106.46	106.5	14574721.0
2010-05-26 16:30:00	SPY	ETF	106.5	107.17	106.42	106.74	5385227.0
2010-05-26 17:00:00	SPY	ETF	106.73	109.01	106.1	106.12	1526004.0
2010-05-26 17:30:00	SPY	ETF	106.17	106.65	106.17	106.45	329422.0
2010-05-26 18:00:00	SPY	ETF	106.46	107.17	106.15	106.35	428270.0
2010-05-26 18:30:00	SPY	ETF	106.35	106.5	106.34	106.5	73831.0
2010-05-26 19:00:00	SPY	ETF	106.51	106.65	106.47	106.57	115870.0
2010-05-26 19:30:00	SPY	ETF	106.54	106.86	106.44	106.83	262134.0
2010-05-26 04:00:00	QQQ	ETF	44.91	44.91	44.91	44.91	200.0
2010-05-26 04:30:00	QQQ	ETF	44.93	45.0	44.93	45.0	1200.0
2010-05-26 05:00:00	QQQ	ETF	45.01	45.01	45.01	45.01	100.0
2010-05-26 05:30:00	QQQ	ETF	45.08	45.08	44.93	44.93	1500.0
2010-05-26 06:00:00	QQQ	ETF	44.95	44.95	44.89	44.93	4400.0
2010-05-26 06:30:00	QQQ	ETF	44.87	45.02	44.87	45.02	20073.0
2010-05-26 07:00:00	QQQ	ETF	45.0	45.12	45.0	45.09	104578.0
2010-05-26 07:30:00	QQQ	ETF	45.12	45.13	45.08	45.11	29062.0
2010-05-26 08:00:00	QQQ	ETF	45.11	45.24	45.11	45.16	460379.0
2010-05-26 08:30:00	QQQ	ETF	45.16	45.24	44.97	45.02	1005186.0
2010-05-26 09:00:00	QQQ	ETF	45.02	45.13	44.93	44.93	1429565.0
2010-05-26 09:30:00	QQQ	ETF	44.93	45.44	44.91	45.3896	19860262.0
2010-05-26 10:00:00	QQQ	ETF	45.3801	45.53	45.25	45.39	10058050.0
2010-05-26 10:30:00	QQQ	ETF	45.39	45.57	45.26	45.3219	7259214.0
2010-05-26 11:00:00	QQQ	ETF	45.32	45.35	45.04	45.06	6373642.0
2010-05-26 11:30:00	QQQ	ETF	45.06	45.16	44.92	45.09	6336750.0
2010-05-26 12:00:00	QQQ	ETF	45.09	45.21	45.03	45.07	3921766.0
2010-05-26 12:30:00	QQQ	ETF	45.065	45.16	44.97	45.1585	3903718.0

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

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