PREVIEW / etf_30min / 2010-07-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-23.parquet
  size:    251 KB
  rows:    8,340

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-23 04:00:00	SPY	ETF	109.71	109.85	109.69	109.85	2800.0
2010-07-23 04:30:00	SPY	ETF	109.91	109.94	109.85	109.85	10100.0
2010-07-23 05:00:00	SPY	ETF	109.64	109.64	109.64	109.64	1950.0
2010-07-23 05:30:00	SPY	ETF	109.67	109.7	109.65	109.7	20400.0
2010-07-23 06:00:00	SPY	ETF	109.67	109.67	109.59	109.63	23500.0
2010-07-23 06:30:00	SPY	ETF	109.65	109.91	109.65	109.7	41525.0
2010-07-23 07:00:00	SPY	ETF	109.81	109.91	109.66	109.7	599870.0
2010-07-23 07:30:00	SPY	ETF	109.71	109.79	109.7	109.72	500239.0
2010-07-23 08:00:00	SPY	ETF	109.72	109.85	109.64	109.83	1756927.0
2010-07-23 08:30:00	SPY	ETF	109.83	109.85	109.58	109.63	944177.0
2010-07-23 09:00:00	SPY	ETF	109.64	109.71	109.14	109.25	3976332.0
2010-07-23 09:30:00	SPY	ETF	109.24	109.66	108.96	109.03	24033869.0
2010-07-23 10:00:00	SPY	ETF	109.04	109.61	108.93	109.57	14819301.0
2010-07-23 10:30:00	SPY	ETF	109.58	109.84	109.45	109.52	11300433.0
2010-07-23 11:00:00	SPY	ETF	109.53	109.74	109.43	109.6	9161950.0
2010-07-23 11:30:00	SPY	ETF	109.6	109.85	109.37	109.68	10662452.0
2010-07-23 12:00:00	SPY	ETF	109.69	109.97	109.23	109.6	25154463.0
2010-07-23 12:30:00	SPY	ETF	109.6	109.66	109.17	109.58	13672843.0
2010-07-23 13:00:00	SPY	ETF	109.58	110.26	109.335	110.25	14795605.0
2010-07-23 13:30:00	SPY	ETF	110.23	110.43	110.11	110.2999	14060690.0
2010-07-23 14:00:00	SPY	ETF	110.29	110.55	109.3	110.25	13184166.0
2010-07-23 14:30:00	SPY	ETF	110.25	110.57	110.16	110.43	9407045.0
2010-07-23 15:00:00	SPY	ETF	110.42	110.47	110.13	110.29	9507501.0
2010-07-23 15:30:00	SPY	ETF	110.28	110.46	109.86	110.41	30969928.0
2010-07-23 16:00:00	SPY	ETF	110.41	110.69	109.145	110.67	8279034.0
2010-07-23 16:30:00	SPY	ETF	110.66	110.71	110.4297	110.65	2408169.0
2010-07-23 17:00:00	SPY	ETF	110.64	110.74	110.64	110.72	135353.0
2010-07-23 17:30:00	SPY	ETF	110.74	110.77	110.7	110.7	73522.0
2010-07-23 18:00:00	SPY	ETF	110.7	110.71	110.41	110.68	42820.0
2010-07-23 18:30:00	SPY	ETF	110.7	110.7	110.65	110.68	2289.0
2010-07-23 19:00:00	SPY	ETF	110.65	110.67	110.65	110.65	18182.0
2010-07-23 19:30:00	SPY	ETF	110.67	110.79	110.65	110.79	34292.0
2010-07-23 04:00:00	QQQ	ETF	45.86	45.86	45.8	45.8	500.0
2010-07-23 05:00:00	QQQ	ETF	45.75	45.75	45.75	45.75	400.0
2010-07-23 06:00:00	QQQ	ETF	45.76	45.76	45.76	45.76	300.0
2010-07-23 06:30:00	QQQ	ETF	45.78	45.83	45.76	45.76	700.0
2010-07-23 07:00:00	QQQ	ETF	45.81	45.85	45.76	45.77	60434.0
2010-07-23 07:30:00	QQQ	ETF	45.78	45.78	45.72	45.75	403267.0
2010-07-23 08:00:00	QQQ	ETF	45.73	45.8	45.67	45.77	2397941.0
2010-07-23 08:30:00	QQQ	ETF	45.77	45.77	45.62	45.63	1062618.0
2010-07-23 09:00:00	QQQ	ETF	45.64	45.68	45.46	45.48	1155845.0
2010-07-23 09:30:00	QQQ	ETF	45.46	45.75	45.41	45.42	13216725.0
2010-07-23 10:00:00	QQQ	ETF	45.42	45.7101	45.38	45.69	4675406.0
2010-07-23 10:30:00	QQQ	ETF	45.69	45.82	45.66	45.67	4670788.0
2010-07-23 11:00:00	QQQ	ETF	45.68	45.74	45.55	45.66	3324217.0
2010-07-23 11:30:00	QQQ	ETF	45.66	45.75	45.59	45.67	2770400.0
2010-07-23 12:00:00	QQQ	ETF	45.68	45.8	45.44	45.59	9076147.0
2010-07-23 12:30:00	QQQ	ETF	45.59	45.6	45.38	45.58	3569434.0
2010-07-23 13:00:00	QQQ	ETF	45.59	45.96	45.47	45.96	5202468.0
2010-07-23 13:30:00	QQQ	ETF	45.95	46.07	45.89	45.94	4480971.0

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

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