PREVIEW / etf_30min / 2010-08-11

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-11.parquet
  size:    273 KB
  rows:    9,161

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-08-11 04:00:00	SPY	ETF	112.11	112.11	111.26	111.26	9200.0
2010-08-11 04:30:00	SPY	ETF	111.34	111.45	111.3	111.3	1103.0
2010-08-11 05:00:00	SPY	ETF	111.25	111.25	111.1	111.1	3800.0
2010-08-11 05:30:00	SPY	ETF	111.08	111.08	110.98	110.98	2395.0
2010-08-11 06:00:00	SPY	ETF	110.94	110.94	110.71	110.74	76634.0
2010-08-11 06:30:00	SPY	ETF	110.86	110.99	110.86	110.99	160379.0
2010-08-11 07:00:00	SPY	ETF	110.97	111.01	110.87	110.99	282286.0
2010-08-11 07:30:00	SPY	ETF	110.99	110.99	110.83	110.92	809693.0
2010-08-11 08:00:00	SPY	ETF	110.94	112.1	110.86	110.93	898241.0
2010-08-11 08:30:00	SPY	ETF	110.91	110.92	110.68	110.75	1256430.0
2010-08-11 09:00:00	SPY	ETF	110.77	110.77	110.49	110.64	1988221.0
2010-08-11 09:30:00	SPY	ETF	110.65	110.69	109.92	110.16	38241842.0
2010-08-11 10:00:00	SPY	ETF	110.16	110.32	109.95	110.1417	20389506.0
2010-08-11 10:30:00	SPY	ETF	110.14	110.14	109.73	109.76	18235814.0
2010-08-11 11:00:00	SPY	ETF	109.75	110.0577	109.38	109.58	21795223.0
2010-08-11 11:30:00	SPY	ETF	109.58	109.71	109.56	109.64	11464210.0
2010-08-11 12:00:00	SPY	ETF	109.63	109.68	109.48	109.53	9990564.0
2010-08-11 12:30:00	SPY	ETF	109.53	109.6	109.23	109.27	9945234.0
2010-08-11 13:00:00	SPY	ETF	109.27	109.5901	109.27	109.55	10040676.0
2010-08-11 13:30:00	SPY	ETF	109.555	109.61	109.35	109.4	7768585.0
2010-08-11 14:00:00	SPY	ETF	109.4	109.72	109.4	109.645	8320325.0
2010-08-11 14:30:00	SPY	ETF	109.64	109.6555	109.12	109.28	15452987.0
2010-08-11 15:00:00	SPY	ETF	109.28	109.41	109.18	109.3199	14177834.0
2010-08-11 15:30:00	SPY	ETF	109.315	109.58	109.14	109.2901	43488233.0
2010-08-11 16:00:00	SPY	ETF	109.29	112.407	108.91	109.0	20411200.0
2010-08-11 16:30:00	SPY	ETF	109.0	109.04	108.68	108.68	12350772.0
2010-08-11 17:00:00	SPY	ETF	108.68	112.4069	107.88	108.13	2363975.0
2010-08-11 17:30:00	SPY	ETF	108.14	108.32	108.14	108.24	499408.0
2010-08-11 18:00:00	SPY	ETF	108.23	109.3	108.15	108.2	253949.0
2010-08-11 18:30:00	SPY	ETF	108.2	108.32	108.2	108.29	55202.0
2010-08-11 19:00:00	SPY	ETF	108.3	108.31	108.23	108.28	55107.0
2010-08-11 19:30:00	SPY	ETF	108.28	108.44	108.28	108.44	100555.0
2010-08-11 04:00:00	QQQ	ETF	46.2	46.2	46.1	46.1	6900.0
2010-08-11 04:30:00	QQQ	ETF	46.12	46.17	46.12	46.17	300.0
2010-08-11 05:00:00	QQQ	ETF	46.08	46.08	46.08	46.08	300.0
2010-08-11 05:30:00	QQQ	ETF	46.04	46.04	45.99	46.01	3790.0
2010-08-11 06:00:00	QQQ	ETF	45.96	45.96	45.88	45.89	4000.0
2010-08-11 06:30:00	QQQ	ETF	45.93	45.99	45.93	45.99	21500.0
2010-08-11 07:00:00	QQQ	ETF	45.98	46.02	45.95	46.02	41200.0
2010-08-11 07:30:00	QQQ	ETF	46.0	46.0	45.96	46.0	73539.0
2010-08-11 08:00:00	QQQ	ETF	46.3857	46.3857	45.96	45.97	372459.0
2010-08-11 08:30:00	QQQ	ETF	45.99	45.99	45.92	45.94	388218.0
2010-08-11 09:00:00	QQQ	ETF	45.95	45.95	45.88	45.9	1390764.0
2010-08-11 09:30:00	QQQ	ETF	45.91	45.92	45.45	45.6	15985459.0
2010-08-11 10:00:00	QQQ	ETF	45.6	45.68	45.52	45.61	5612729.0
2010-08-11 10:30:00	QQQ	ETF	45.61	45.6101	45.36	45.38	6597606.0
2010-08-11 11:00:00	QQQ	ETF	45.38	45.41	45.25	45.34	5964042.0
2010-08-11 11:30:00	QQQ	ETF	45.33	45.43	45.33	45.38	5166304.0
2010-08-11 12:00:00	QQQ	ETF	45.37	45.4947	45.32	45.34	1882993.0
2010-08-11 12:30:00	QQQ	ETF	45.34	45.37	45.21	45.2401	2825704.0

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

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