PREVIEW / etf_30min / 2010-01-06

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-06.parquet
  size:    234 KB
  rows:    8,121

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-01-06 04:00:00	SPY	ETF	113.32	113.37	113.32	113.37	900.0
2010-01-06 04:30:00	SPY	ETF	113.31	113.31	113.31	113.31	118.0
2010-01-06 05:30:00	SPY	ETF	113.28	113.44	113.28	113.44	17618.0
2010-01-06 06:00:00	SPY	ETF	113.49	113.49	113.35	113.35	20100.0
2010-01-06 06:30:00	SPY	ETF	113.34	113.36	113.34	113.36	300.0
2010-01-06 07:00:00	SPY	ETF	113.39	113.39	113.19	113.24	95783.0
2010-01-06 07:30:00	SPY	ETF	113.24	113.39	113.23	113.35	138900.0
2010-01-06 08:00:00	SPY	ETF	113.37	113.45	113.22	113.45	2404175.0
2010-01-06 08:30:00	SPY	ETF	113.45	113.6	113.44	113.57	879967.0
2010-01-06 09:00:00	SPY	ETF	113.56	113.57	113.45	113.5	546509.0
2010-01-06 09:30:00	SPY	ETF	113.52	113.7	113.43	113.57	13212871.0
2010-01-06 10:00:00	SPY	ETF	113.56	113.8	113.51	113.73	10722606.0
2010-01-06 10:30:00	SPY	ETF	113.73	113.76	113.52	113.76	6635698.0
2010-01-06 11:00:00	SPY	ETF	113.76	113.845	113.72	113.76	6245004.0
2010-01-06 11:30:00	SPY	ETF	113.76	113.88	113.6701	113.705	6517866.0
2010-01-06 12:00:00	SPY	ETF	113.71	113.75	113.52	113.53	7257520.0
2010-01-06 12:30:00	SPY	ETF	113.5312	113.7	113.52	113.69	3204899.0
2010-01-06 13:00:00	SPY	ETF	113.69	113.78	113.67	113.74	5836105.0
2010-01-06 13:30:00	SPY	ETF	113.745	113.76	113.54	113.63	5714058.0
2010-01-06 14:00:00	SPY	ETF	113.63	113.84	113.63	113.8	7028475.0
2010-01-06 14:30:00	SPY	ETF	113.8	113.99	113.79	113.9	7065656.0
2010-01-06 15:00:00	SPY	ETF	113.9	113.93	113.73	113.815	7725260.0
2010-01-06 15:30:00	SPY	ETF	113.81	113.89	113.61	113.74	13472400.0
2010-01-06 16:00:00	SPY	ETF	113.73	113.76	113.67	113.74	5465769.0
2010-01-06 16:30:00	SPY	ETF	113.72	113.94	113.51	113.71	2413800.0
2010-01-06 17:00:00	SPY	ETF	113.7	113.7	113.66	113.68	2085322.0
2010-01-06 17:30:00	SPY	ETF	113.7	113.74	113.67	113.73	26100.0
2010-01-06 18:00:00	SPY	ETF	113.71	113.75	113.65	113.74	25360.0
2010-01-06 18:30:00	SPY	ETF	113.73	113.73	113.7	113.7	2600.0
2010-01-06 19:00:00	SPY	ETF	113.67	113.74	113.67	113.72	2400.0
2010-01-06 19:30:00	SPY	ETF	113.74	113.81	113.73	113.79	26915.0
2010-01-06 04:30:00	QQQ	ETF	46.33	46.33	46.29	46.29	650.0
2010-01-06 05:00:00	QQQ	ETF	46.31	46.31	46.31	46.31	500.0
2010-01-06 05:30:00	QQQ	ETF	46.38	46.38	46.38	46.38	1000.0
2010-01-06 06:00:00	QQQ	ETF	46.37	46.39	46.33	46.36	2000.0
2010-01-06 06:30:00	QQQ	ETF	46.35	46.35	46.33	46.33	25000.0
2010-01-06 07:00:00	QQQ	ETF	46.34	46.34	46.21	46.22	590280.0
2010-01-06 07:30:00	QQQ	ETF	46.23	46.3	46.22	46.29	147144.0
2010-01-06 08:00:00	QQQ	ETF	46.3	46.32	46.26	46.31	674821.0
2010-01-06 08:30:00	QQQ	ETF	46.32	46.41	46.21	46.4	1748787.0
2010-01-06 09:00:00	QQQ	ETF	46.4	46.4	46.34	46.39	354582.0
2010-01-06 09:30:00	QQQ	ETF	46.39	46.55	46.36	46.4	14050445.0
2010-01-06 10:00:00	QQQ	ETF	46.4	46.52	46.35	46.4	5128633.0
2010-01-06 10:30:00	QQQ	ETF	46.4	46.45	46.35	46.45	5674220.0
2010-01-06 11:00:00	QQQ	ETF	46.45	46.5	46.42	46.465	1835936.0
2010-01-06 11:30:00	QQQ	ETF	46.4698	46.485	46.28	46.28	5993899.0
2010-01-06 12:00:00	QQQ	ETF	46.28	46.3	46.14	46.16	7061731.0
2010-01-06 12:30:00	QQQ	ETF	46.16	46.265	46.15	46.24	2824350.0
2010-01-06 13:00:00	QQQ	ETF	46.24	46.29	46.24	46.2767	1021733.0
2010-01-06 13:30:00	QQQ	ETF	46.2767	46.28	46.07	46.115	5845063.0

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

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