PREVIEW / etf_30min / 2010-05-19

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-19.parquet
  size:    270 KB
  rows:    9,112

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-19 04:00:00	SPY	ETF	111.43	111.61	111.31	111.31	5200.0
2010-05-19 04:30:00	SPY	ETF	111.32	111.32	111.12	111.23	12516.0
2010-05-19 05:00:00	SPY	ETF	111.32	111.43	111.11	111.12	16720.0
2010-05-19 05:30:00	SPY	ETF	111.21	111.22	111.0	111.05	26212.0
2010-05-19 06:00:00	SPY	ETF	111.05	111.26	111.04	111.1	43225.0
2010-05-19 06:30:00	SPY	ETF	111.15	111.38	111.11	111.3	82940.0
2010-05-19 07:00:00	SPY	ETF	111.36	111.7	111.36	111.62	1045702.0
2010-05-19 07:30:00	SPY	ETF	111.62	111.63	111.29	111.63	754184.0
2010-05-19 08:00:00	SPY	ETF	111.61	112.1	111.3667	111.68	5035287.0
2010-05-19 08:30:00	SPY	ETF	111.8	112.19	111.6	112.13	3775320.0
2010-05-19 09:00:00	SPY	ETF	112.11	112.31	111.31	111.77	3649864.0
2010-05-19 09:30:00	SPY	ETF	111.77	112.77	111.74	112.34	42917723.0
2010-05-19 10:00:00	SPY	ETF	112.35	112.6	110.82	111.61	56411808.0
2010-05-19 10:30:00	SPY	ETF	111.61	112.6	111.21	111.58	31468362.0
2010-05-19 11:00:00	SPY	ETF	111.58	111.67	110.68	110.94	24275689.0
2010-05-19 11:30:00	SPY	ETF	110.95	111.06	110.36	110.925	28891797.0
2010-05-19 12:00:00	SPY	ETF	110.93	111.59	110.5208	111.39	22508973.0
2010-05-19 12:30:00	SPY	ETF	111.39	111.82	110.99	111.82	17375681.0
2010-05-19 13:00:00	SPY	ETF	111.8	112.15	111.47	111.91	20658481.0
2010-05-19 13:30:00	SPY	ETF	111.9	112.23	111.59	111.93	16710306.0
2010-05-19 14:00:00	SPY	ETF	111.93	112.29	111.47	111.76	16244320.0
2010-05-19 14:30:00	SPY	ETF	111.7501	112.13	111.53	111.76	19480281.0
2010-05-19 15:00:00	SPY	ETF	111.77	111.89	111.22	111.85	22956833.0
2010-05-19 15:30:00	SPY	ETF	111.845	112.31	111.59	111.79	43351397.0
2010-05-19 16:00:00	SPY	ETF	111.8	112.72	110.863	111.5	9227764.0
2010-05-19 16:30:00	SPY	ETF	111.5	112.422	111.5	112.02	4986943.0
2010-05-19 17:00:00	SPY	ETF	112.01	112.01	111.76	111.92	159023.0
2010-05-19 17:30:00	SPY	ETF	111.93	112.03	111.83	111.98	55915.0
2010-05-19 18:00:00	SPY	ETF	112.0	112.05	111.74	111.94	191695.0
2010-05-19 18:30:00	SPY	ETF	111.95	111.95	111.82	111.87	56733.0
2010-05-19 19:00:00	SPY	ETF	111.87	112.07	111.85	112.0	51350.0
2010-05-19 19:30:00	SPY	ETF	112.0	112.12	111.86	112.05	106359.0
2010-05-19 04:30:00	QQQ	ETF	46.03	46.03	46.0	46.0	300.0
2010-05-19 05:30:00	QQQ	ETF	46.05	46.05	45.98	45.98	300.0
2010-05-19 06:00:00	QQQ	ETF	45.95	46.0	45.94	46.0	8600.0
2010-05-19 06:30:00	QQQ	ETF	46.06	46.1	46.05	46.08	43779.0
2010-05-19 07:00:00	QQQ	ETF	46.11	46.2	46.09	46.16	75214.0
2010-05-19 07:30:00	QQQ	ETF	46.14	46.2	46.05	46.2	119472.0
2010-05-19 08:00:00	QQQ	ETF	46.19	46.39	46.06	46.22	1287218.0
2010-05-19 08:30:00	QQQ	ETF	46.22	46.45	46.22	46.41	1255416.0
2010-05-19 09:00:00	QQQ	ETF	46.4	46.42	46.25	46.27	460868.0
2010-05-19 09:30:00	QQQ	ETF	46.26	46.63	46.22	46.39	20157914.0
2010-05-19 10:00:00	QQQ	ETF	46.39	46.4067	45.64	46.0	19275263.0
2010-05-19 10:30:00	QQQ	ETF	46.01	46.15	45.88	46.08	15103486.0
2010-05-19 11:00:00	QQQ	ETF	46.08	46.13	45.68	45.7716	11921771.0
2010-05-19 11:30:00	QQQ	ETF	45.78	45.86	45.55	45.7501	11279429.0
2010-05-19 12:00:00	QQQ	ETF	45.75	46.06	45.7	45.99	8310332.0
2010-05-19 12:30:00	QQQ	ETF	45.99	46.12	45.79	46.11	6195321.0
2010-05-19 13:00:00	QQQ	ETF	46.11	46.28	45.97	46.155	7690615.0
2010-05-19 13:30:00	QQQ	ETF	46.15	46.31	46.04	46.18	5276240.0

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

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